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