Oh yeah, I'm pretty sure I need a book! Too bad the school teachers here in our High School Business department can't seem to help me. Well thanks, I will be playing with a copy of my data and see what I can come up with Susan -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, June 20, 2005 2:36 PM To: [email protected] Subject: RE: [ms_access] Re: Report Susan-
You must make your own form. As I understood it, you have a report for which you want to specify different criteria - to custom print the report with different data. To do that with one report, you would build a form in which you can enter values for the criteria you want. Add one text box or combo box per criteria and add a command button with code "behind" the click event of the button similar to what you see in my sample. 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:28 PM > To: [email protected] > Subject: RE: [ms_access] Re: Report > > > OK, I printed out the code and thought I'd start by going to the same > place in my own file. But I don't have any "Forms" so I figured I'd go > to "Queries" or the "Report" but.. No "Search" button was to be found. > Where would this code go if one does not have a "Form," or should I be > making one? I'm thinking that I don't need a form, as I merely want to > be able to print out a Letter/report or List, another report, for the > person requesting the information. > I am planning on a trip to our local library after work. The nearest > book store is an hour away, so I won't be going there just yet. > 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/ > > > > > > [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 <*> 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/
