By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,470 Members | 1,455 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,470 IT Pros & Developers. It's quick & easy.

Help required passing variables from a top level macro to queries.

P: n/a

I have written 3 seperate macros in access to run 3 queries to
export 3 .xls files.

Sometimes I will need to run them individually.

Sometimes I will need to run them all together therefore I have
written a top level macro to run the 3 macros.

The problem I have is that each of the queries require me to input a
start and end date. When I run the top level macro I have to enter the
dates 3 times. Obviously I would like to enter the dates only once.

Can anybody point me to a tutorial that will explain in a step by step
process how I go about doing this.
Feb 15 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.