H
HockeyPlayerCSU
Sorry about the repeat post, I lost track of the other one.
warrior, not quite sure how passing the variable in the query to VBA
code would work.
I run from the command prompt passing it a job number i.e.
msaccess.exe "c:\office\Jobs.mdb" /cmd 00000163
Now my question becomes: I need to run a query that pulls all the info
related to job number 00000163. In SQL view, the Where Job = Command()
comes back with an error, saying that it was an undefined function in
command.
If in a module I create:
Function Command()
~~~~~~~~~
End Function
What does ~~~~~~~~ need to be to have it pass back the value 00000163
from the command prompt?
Thanks,
Mark
warrior, not quite sure how passing the variable in the query to VBA
code would work.
I run from the command prompt passing it a job number i.e.
msaccess.exe "c:\office\Jobs.mdb" /cmd 00000163
Now my question becomes: I need to run a query that pulls all the info
related to job number 00000163. In SQL view, the Where Job = Command()
comes back with an error, saying that it was an undefined function in
command.
If in a module I create:
Function Command()
~~~~~~~~~
End Function
What does ~~~~~~~~ need to be to have it pass back the value 00000163
from the command prompt?
Thanks,
Mark