Your "From" and "To" textboxes are unbound. You probably should set a default value for them (the value for "To" could be Date(), which will always be the current date), so that they will always have a value. The form itself does not need a control source either, if you just are putting buttons on it to launch reports.
Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of scubafish00 Sent: Monday, October 31, 2005 11:32 AM To: [email protected] Subject: [AccessDevelopers] Re: Count & Parameters I've been looking for this info for a while and now that I've got it I can't get it to work. What do I set the control source of my form to - if at all? I have entered the expression below into the query as instructed but I can't get my form to work......Thanks. --- In [email protected], "Tobi Hoffman" <[EMAIL PROTECTED]> wrote: > > Or, on your form, have two textboxes for the From and To dates, and in the > query, in the criteria line for the date, you put in something like this: > > Between [Forms].[f_Reports].[txtFrom] And [Forms].[f_Reports]. [txtTo] > > This has two main advantages: 1) the textboxes can be made to accept dates > only, so that non-dates cannot be entered which will screw up the query, and > 2) multiple reports which require dates can be run (or multiple runs of the > same report with other settings changed) without having to enter the dates > each time. > > Tobi > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] Behalf Of Jones, Glenn P MSG > (Ret) FL-ARNG > Sent: Thursday, April 21, 2005 7:45 AM > To: [email protected] > Subject: RE: [AccessDevelopers] Count & Parameters > > > Greetings, > Assuming you are using a query to drive your report you may attain the date > range you desire by entering "Between [Enter start date] And [Enter end > date]" When you open the report a dialog box will appear asking you to > "Enter start date" and then another dialog box will appear and ask you to > "Enter end date". This is the easiest way I have found to query within a > range of dates. > > For your count I suggest looking in the help at DCount and Sum. > > Glenn Jones > IHS > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of sboone1982 > Sent: Wednesday, 20 April, 2005 4:58 PM > To: [email protected] > Subject: [AccessDevelopers] Count & Parameters > > > > I have been using Crystal Reports nonstop lately, but now that I have > to create a report with Microsoft's Access I'm hitting break walls. I > need to be able to do a COUNT on units and I also need to add a > parameter on the report for a date range. > > Can anyone shed light on the syntax for either (or both) of these? > > Help please... > Thank you! > > > > > > > Please zip all files prior to uploading to Files section. Yahoo! > Groups Links > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > > ------------------------------------------------------------------- --------- > ---- > Yahoo! Groups Links > > a.. To visit your group on the web, go to: > http://groups.yahoo.com/group/AccessDevelopers/ > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
