If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to pass a memory variable to a report
I have a program that calculates sums of samples taken in a period, how do I
transfer the start date and end date which are entered by the user to the report? |
#2
|
|||
|
|||
how to pass a memory variable to a report
"GrantD" wrote
I have a program that calculates sums of samples taken in a period, how do I transfer the start date and end date which are entered by the user to the report? Assuming they are entered into Text Boxes, or chosen from Combo Boxes on a Form, leave the Form open and access them using the Forms collection, Form's name, and name of the Control. Using Public Variables in a Standard Module is not especially recommended, but works in most environments. A very useful enhancement to Access 2002/2003 was the addition of the OpenArgs argument to the DoCmd.OpenReport... pass them as text strings, and either print them as is, or convert them back to numbers. You can read the OpenArgs argument in the Open event of the Report, and, though I've never had occasion to do so, I believe also in any event that occurs after that. Larry Linson Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|