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] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
