Parameter Queries

[Omar]

Again, thanks very much for your suggestions and comments,
you all have been extremely instrumental in my ability to
understand access.

I have a parameter querie setup using the "Between [start
date] and [end date] syntax. I have a print menu that I
use to print the report from this querie. When I try to
print, the "start" and "end" date boxes pop up. What I
would like to do is be able to type in these dates in my
form and have access use these dates to run the querie
instead of prompting the user for this information. Thanks

OMAR

 

[Eric Butts]

Hi,

You are wanting to use the Query By Form techinque. Example of query:


Field: Table.* DateEntered
Criteria: BETWEEN Forms![FormName]![textboxStartDate] AND
Forms![FormName]![textboxEndDate]

If you are looking to keep the Query as

Field: Table.* DateEntered
Criteria: BETWEEN [start date] AND [end date]

as passed the results the values of the textbox controls on the Form, then
you would need to use VBA Code. For ideas see: ACC2000: "Too Few
Parameters. Expected 1" Error Message
http://support.microsoft.com/default.aspx?scid=kb;en-us;209203&Product=acc20
00


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."