Passing a value to a Macro using Command Line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top