Passing a command line argument into Access

R

richardb

Found post 8/20/2005 from ofer and tried his solution. Also consulted on-line
docs, but still having no success passing a command line argument. Latest try
was this in a shortcut:

"G:\Access Projects\Scanning\Scanning.mdb" /cmdHOME OFFICE

Then I created a button on a form with click event:

Dim LocationID As String 'Also tried leaving it as a variant.
LocationID = Command()

MsgBox "LocationID is " & LocationID

Keeps coming up blank and I can't figure out what is wrong. Have tried
different uses of quotes in the short cut, but no luck. Help appreciated.

richard
 
K

Kevin K. Sullivan

If you want Access to read the command line, you *must* reference
msaccess.exe. The command line arguments are ignored if your shortcut
is just to the .mdb file. I've been there - it's very frustrating.

Try the format:

PathToAccessApp MDBfile /cmd ArgumentToPassIn

put each piece that may have spaces between double quotes:

"C:\Program Files\Microsoft Office\msaccess.exe" "G:\Access
Projects\Scanning\Scanning.mdb" /cmd "HOME OFFICE"
 
R

richardb

Thanks Kevin, I wouldn't have guessed. My problem now is to find
msaccess.exe. It is not in the C:\Program Files\Microsoft Office folder or
any sub folder so far as I could find. Any thoughts?
 
R

Rick Brandt

richardb said:
Thanks Kevin, I wouldn't have guessed. My problem now is to find
msaccess.exe. It is not in the C:\Program Files\Microsoft Office
folder or any sub folder so far as I could find. Any thoughts?
Click to expand...

Usually it's at...

C:\Program Files\Microsoft Office\Office\MSAccess.exe
 
R

richardb

It was in Office11. Please ignore last post.

Kevin K. Sullivan said:
If you want Access to read the command line, you *must* reference
msaccess.exe. The command line arguments are ignored if your shortcut
is just to the .mdb file. I've been there - it's very frustrating.

Try the format:

PathToAccessApp MDBfile /cmd ArgumentToPassIn

put each piece that may have spaces between double quotes:

"C:\Program Files\Microsoft Office\msaccess.exe" "G:\Access
Projects\Scanning\Scanning.mdb" /cmd "HOME OFFICE"
Click to expand...
 
Top