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

How do I pass a parameter to a MS Access macro?

P: 1
Hello Forum!

I am new to the MS Access realm...

I want to pass a parameter to my MS Access (2000) macro (for instance
to specify the name of a table I want to create. This name would be passed
to several queries inside the macro).

Thanks for your generous help!
(I have searched Google and textbooks before asking for your valuable time).

---Barry
"barrykdd"
Oct 26 '06 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,470
(I have searched Google and textbooks before asking for your valuable time)
Top of my priority list already ;-)

I'm afraid I think the answer is that Macro's don't support parameters.
Looks like it's time to get into VBA code, as Subroutines and Functions can.

NB. I don't think you can pass parameters to event procedures (EG for when you click on a command button) regardless of whether they are macros, subroutines or functions.
Oct 26 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.