Global variable in Macros 1

[alectek]

Hi!
I very new in any kind of Access Programming, so my question may look very stupid.
Working with MS Access 2003.
I need to create three Macros.
First, will OpenQuery to create table
Second and Third, will OpenQuery to append to “First” table.
In every of those queries I need pass “Start Date” & “End Date” parameters.
Where and how should I declare them to do it only once?

Thanks.
Al.


Thanks.
Alec.

 

[SkipVought]

Hi,

You can either declare them in the CALLING procedure, and pass them as parameters or declare them in the (Declarations) area of the module as Public.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}