From within my Outlook custom form, I call an Access macro. The macro runs a query within Access. The code looks like this:
Myshell.Run chr(34)+"MSACCESS.EXE"+chr(34)+chr(34)+"\\Server1\documents\MyDatabase.mdb"+chr(34)+ " /x mcrOpenDelay"
Is there a way to call an Access macro or query and use a variable. For instance, I want to run the query, but for a certain job number, so I need to somehow put the job number in the code that calls out the macro or query.
Hope that makes sense,