Passing a value to a Macro using Command Line

T

TADropik

I use the following command line and it runs successfully:
"C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe"
"c:\Data\Apps\Client.mdb" /x StartMacro

However, In the Macro I have a Where Condition
Where Condtion: [KEY]=[SBKey]

I would like to pass the value of [SBKey] to the Macro from the Command Line

Is this possible?
 
S

Steve Schapel

TA,

No, as far as I know this is not possible. I think the closest you will
get is for the value of SBKey to be in a control on a form which is open
at the time that the macro is run, and then reference the form control
in the Where Condition argument of the macro action. This may mean
including an OpenForm action in the macro, and possibly a SetValue
action as well to assign the value to the form control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top