Is it possible to Generate 2 reports on One CLick from ONE entry of Parameters ?

JJordan

Registered User.
Local time
Today, 02:09
Joined
Jul 25, 2002
Messages
53
I would like the user to be able to generate Donation Receipts by Date Range and between $x and $y. I have a query to generate the information that then goes into the receipts Report. What I want is to also generate Mailing Labels for the SAME set of parameters without the user having to enter the parameters again. I know how to run both Reports on One clck (learning slowly :) ) I an not versed in SQL, but I assume I need to some how change the Event Procedure to use the parameters to run both reports ?? No idea how.
 
You need to add unbound boxes to your form that will hold the parameters. Then change the queries to reference the form fields rather than promptind:

Where SomeField = Forms!YourFormName!YourControlName;
 
You need to add unbound boxes to your form that will hold the parameters. Then change the queries to reference the form fields rather than promptind:

Where SomeField = Forms!YourFormName!YourControlName;
 
I think I understand and will try to write that, but using WHERE does not seem to work for BETWEEN

Would I use

WHERE ([Donation Date] Between [Donation Date]=Foms!YourFormName!YourControlName1 and [Donation Date]=Forms!YourFormName!YourControlName2)
 
Your syntax is not correct:

WHERE ([Donation Date] Between Foms!YourFormName!YourControlName1 and Forms!YourFormName!YourControlName2)
 
Thanks Pat. Every time I learn some more basic stuff like this, I get chills :) I did buy an Access Bible (about 3 inches thick) but it does not tell me as much as I need to know about virtual basic and sql. With help from people like you answering stupid questions, someday I will be able to at least get the Tree Trees database up and runing :) THANKS AGAIN !
 
Last edited:
Try the "Access Cookbook", O'Reilly by Ken Getz, Paul Litwin & Andy Baron. $49.95 and comes with a CD. There's a new version out that includes A2002. I learned much of what I know about VBA from their original version of this book which I think was for A1.1
 

Users who are viewing this thread

Back
Top Bottom