Command Line Prompt

  • Thread starter Thread starter HockeyPlayerCSU
  • Start date Start date
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
 
Finally Got It!

It is:
Function CheckCommandLine()
Dim CmdLine As Variant
CmdLine = Command()

CheckCommandLine = CmdLine
EndFunction
 
Back
Top