command line parameter

[dave]

Hello
I'm developing report schedular application that will execute report on
sepcified time.
I want to write batch file that open ms access and run report and close
itself..
Important thing is can we read command line parameteres in access...rest of
the things
I can handle it..
I m thinking to pass report name in batch file command line and put that
batch file in windows
schedular..
is it possible?
thanx
dave

 

[Steve Huff]

Hello
I'm developing report schedular application that will execute report on
sepcified time.
I want to write batch file that open ms access and run report and close
itself..
Important thing is can we read command line parameteres in access...rest
of
the things
I can handle it..

Yes you can read command line paramters in access by using the /cmd switch
and then using the Command function to get the paraters.

For example the shortcut would be:

c:\program files\office path\msaccess.exe
"c:\path_to_some_db\nameofdatabase.mdb" /cmd "hello world"

then a call to the function Command in nameofdatabase.mdb would return
"hello world"