Susan- The code goes in the form. You can't put code in a table.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Gardner > Sent: Monday, June 20, 2005 4:53 PM > To: [email protected] > Subject: RE: [ms_access] Re: Report > > > OK, I spoke too soon, I do have a form, but since I never use it, I > didn't realize it was there. But now I don't really > understand the code. > Does the code go into the form for the table that has all of > my data? I > suppose I should just get a book and see if I can figure it out. LOL I > was hoping this would be quick & easy, but I guess not! > Susan > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of John Viescas > Sent: Monday, June 20, 2005 1:23 PM > To: [email protected] > Subject: RE: [ms_access] Re: Report > > Susan- > > Microsoft Access lets you write complex instructions to make "magic" > happen > when the user does something. For example, you can write instructions > to > perform further tests on data before it gets saved from a form. The > simplest form of instruction-writing or "programming" is macros. You > can > write a macro to respond to many events - such as saving a > record or the > user clicking on something. A more advanced method is to write > instructions > in the Visual Basic programming language. In this case, I've written > instructions to assemble a filter when the user clicks the Search > button. > Download the database I suggested, open it, and open the frmClubSearch > form > in Design view. Select the command button that says "Search" on it. > Open > the Properties window and scroll down until you find the On Click > property. > You should find the words [Event Procedure] there. Click in the > property > and then click the little "builder" button (...) next to the property. > Access should open the Visual Basic editor and show you the > code I wrote > to > dynamically build a filter and open a form. I put lots of comments in > the > code, so you might be able to figure out what it is doing just by > reading > it. > > Let me know when you've got that far and need to ask some more > questions. > > Remember, there are no dumb questions -- only dumb answers. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > > -----Original Message----- > > From: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Gardner > > Sent: Monday, June 20, 2005 2:47 PM > > To: [email protected] > > Subject: RE: [ms_access] Re: Report > > > > > > I know you may be getting exasperated with me, but I'm still > > very lost, > > I don't know what you mean by "Code behind search button" > > Let me tell you that someone else actually built the file > I'm using. I > > have been muddeling my way through how to use it, and (maybe > > in error) I > > thought it was time that I try to learn something a bit > more spiffy. I > > don't mean to sound like one of the high school students, but > > I'm not so > > sure just how much I want to "Learn" since I'm probably only > > going to do > > this one thing and turn it over to someone else. > > But. I'm willing to give it a try, with a little help! > > Susan G > > > > -----Original Message----- > > From: [email protected] > [mailto:[EMAIL PROTECTED] On > > Behalf Of John Viescas > > Sent: Monday, June 20, 2005 8:56 AM > > To: [email protected] > > Subject: RE: [ms_access] Re: Report > > > > Susan- > > > > Go download this sample from my website: > > > > http://www.viescas.com/aftp/Download/EntertainWCalendars.zip > > > > Take a look at frmGroupSearch or frmClubSearch - these are > examples of > > "custom query by form." These forms do an OpenForm rather than > > OpenReport, > > but the concept is the same. The code behind the Search > > button examines > > each potential filter, builds a filter string, and then opens a form > > filtered on the criteria. > > > > John Viescas, author > > "Building Microsoft Access Applications" > > "Microsoft Office Access 2003 Inside Out" > > "Running Microsoft Access 2000" > > "SQL Queries for Mere Mortals" > > http://www.viescas.com/ > > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Gardner > > > Sent: Monday, June 20, 2005 10:22 AM > > > To: [email protected] > > > Subject: RE: [ms_access] Re: Report > > > > > > > > > Thanks, but this is so far over my head, I have not a > clue how to do > > > what you are saying. I know what a basic query is, but > not the other > > > terms. I am going to borrow a book from a friend here in a > > minute, and > > > see if I can find the terms and go from there. I'll let you > > know if I > > > figure it out or not. I don't even have Access on my > > computer at home > > > and tomorrow is my last day at work for the summer. I might > > > see if I can > > > get a copy to play with at home. > > > Thanks, > > > Susan G > > > > > > -----Original Message----- > > > From: [email protected] > > [mailto:[EMAIL PROTECTED] On > > > Behalf Of John Viescas > > > Sent: Saturday, June 18, 2005 6:53 AM > > > To: [email protected] > > > Subject: RE: [ms_access] Re: Report > > > > > > Susan- > > > > > > You need to build a custom "query by form" unbound form that > > > contains an > > > unbound control for each criteria you might want to apply to > > > the report. > > > Write code behind a command button on the form to examine > > > what criteria > > > were > > > entered and dynamically build a filter (like an SQL WHERE > > > clause). Use > > > that > > > filter in the WhereCondition parameter of the OpenReport > > > action to open > > > any > > > report so that it displays only the records that match > the criteria. > > > > > > John Viescas, author > > > "Building Microsoft Access Applications" > > > "Microsoft Office Access 2003 Inside Out" > > > "Running Microsoft Access 2000" > > > "SQL Queries for Mere Mortals" > > > http://www.viescas.com/ > > > > > > > -----Original Message----- > > > > From: [email protected] > > > > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Gardner > > > > Sent: Friday, June 17, 2005 5:18 PM > > > > To: [email protected] > > > > Subject: RE: [ms_access] Re: Report > > > > > > > > > > > > Gee whiz! I guess all I have to do is read! I never noticed > > > that "Keep > > > > together" thingy (technical term here) My reports are > looking much > > > > better! > > > > Now if I could just figure out how to use one letter or > > one listing > > > > report to pull out multiple results! Any ideas? > > > > Susan G > > > > > > > > -----Original Message----- > > > > From: [email protected] > > > [mailto:[EMAIL PROTECTED] On > > > > Behalf Of John Viescas > > > > Sent: Friday, June 17, 2005 12:00 PM > > > > To: [email protected] > > > > Subject: RE: [ms_access] Re: Report > > > > > > > > Susan- > > > > > > > > And you're a blonde? I don't belive it! <s> > > > > > > > > There are Keep Together properties both for the Group in the > > > > Sorting and > > > > Grouping dialog as well as for the Group Header. You can > > > also set the > > > > New > > > > Page property for the header if you want each student on > > a new page. > > > > > > > > John Viescas, author > > > > "Building Microsoft Access Applications" > > > > "Microsoft Office Access 2003 Inside Out" > > > > "Running Microsoft Access 2000" > > > > "SQL Queries for Mere Mortals" > > > > http://www.viescas.com/ > > > > > > > > > -----Original Message----- > > > > > From: [email protected] > > > > > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Gardner > > > > > Sent: Friday, June 17, 2005 1:51 PM > > > > > To: [email protected] > > > > > Subject: [ms_access] Re: Report > > > > > > > > > > > > > > > But... That being said, is there a way to keep each > > > student set of > > > > > fines/lines together? I have the name on the bottom of pg > > > > 1, and the > > > > > detail at the top of pg 2. Is there any command that will > > > keep the > > > > > group together? > > > > > Now I'll go see if I can find that answer too! Seems that > > > > > after I ask a > > > > > question, I find the answer. > > > > > Susan > > > > > > > > > > --- In [email protected], "Susan Gardner" > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > Yeah! I figured it out! From the design view I clicked on > > > > > the sorting > > > > > > and group Icon, then clicked on the Name, went down and > > > > changed the > > > > > > Group Header to yes! I'll just keep plugging away at this, > > > > > maybe I'll > > > > > > figure it all out before I retire! > > > > > > Susan > > > > > > > > > > > > --- In [email protected], "Susan Gardner" > > > <[EMAIL PROTECTED]> > > > > > wrote: > > > > > > > Another question, > > > > > > > Can I insert another part ot a report? I don't know the > > > > term for > > > > > > > the "part" I need another header in the report that > > > > lists who has > > > > > > what > > > > > > > books missing. Currently I get the students name once > > > for each > > > > > > missing > > > > > > > book, but would like to have a name header so I would > > > get their > > > > > name > > > > > > > only once. > > > > > > > Susan > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _____ > > > > > > > > Yahoo! Groups Links > > > > * To visit your group on the web, go to: > > > > http://groups.yahoo.com/group/ms_access/ > > > > > > > > * To unsubscribe from this group, send an email to: > > > > [EMAIL PROTECTED] > > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > * Your use of Yahoo! Groups is subject to the > > > Yahoo! Terms of > > > > <http://docs.yahoo.com/info/terms/> Service. > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _____ > > > > > > Yahoo! Groups Links > > > * To visit your group on the web, go to: > > > http://groups.yahoo.com/group/ms_access/ > > > > > > * To unsubscribe from this group, send an email to: > > > [EMAIL PROTECTED] > > > > <mailto:[EMAIL PROTECTED]> > > > > > > * Your use of Yahoo! Groups is subject to the > > Yahoo! Terms of > > > <http://docs.yahoo.com/info/terms/> Service. > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > _____ > > > > Yahoo! Groups Links > > * To visit your group on the web, go to: > > http://groups.yahoo.com/group/ms_access/ > > > > * To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]> > > > > * Your use of Yahoo! Groups is subject to the > Yahoo! Terms of > > <http://docs.yahoo.com/info/terms/> Service. > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > _____ > > Yahoo! Groups Links > * To visit your group on the web, go to: > http://groups.yahoo.com/group/ms_access/ > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > <http://docs.yahoo.com/info/terms/> Service. > > > [Non-text portions of this message have been removed] > > > > > Yahoo! Groups Links > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
