passing parameters to access when openin the application

[Chattanooga]

hi all,

i would like to check if access was opened with a parameter and then
use the parameter in a vba script.

any ideas??

thanks in advance,
chattanooga

 

[David Lloyd]

One alternative is to use the /cmd switch together with the Command
function. The following articles provide additional information on this
approach.

http://support.microsoft.com/kb/209207/en-us
http://msdn.microsoft.com/library/d...n-us/vbaac11/html/acfctCommand_HV05186437.asp

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


hi all,

i would like to check if access was opened with a parameter and then
use the parameter in a vba script.

any ideas??

thanks in advance,
chattanooga

 

[Douglas J Steele]

Just thought I'd point out (because the fact doesn't seem to be emphasized
in the cited references) that the shortcut to opening the MDB file must
contain the full path to msaccess.exe. While it's sufficient for a shortcut
to only contain the path to the MDB file in "simple" cases, anytime you're
trying to use a command line switch, you must include msaccess.exe in the
shortcut. This is because the switches are for Access, not the database.

 

[Chattanooga]

Just thought I'd point out (because the fact doesn't seem to be emphasized
in the cited references) that the shortcut to opening the MDB file must
contain the full path to msaccess.exe. While it's sufficient for a shortcut
to only contain the path to the MDB file in "simple" cases, anytime you're
trying to use a command line switch, you must include msaccess.exe in the
shortcut. This is because the switches are for Access, not the database.

thanks guys, extactly what i was looking for!!!

cheers