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 <*> 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/
