Opening an Access db with a parameter (s)

[Allen]

Opening by using a shortcut on the desktop with Target Path
"C:\Test.mdb" FunctionName(ByVal x AS Long)
?????

 

[Cheryl Fischer]

If you want your function to be called when the database opens, go to
Tools|Startup and look for the combo box labeled "Display Form/Page".
Select the form that you want to open when your database opens. Then, in
the Open event of that form you can call your function.

hth,

 

[Allen]

Would like to Pass a value into an Access database using
a "Shortcut on the Desktop". Create a shortcut to an
Access database then right click and look at the
properties, look under the "Target:" box. The path for
example would be "C:\Test.mdb" ValuePassed. So when the
user clicks on the shortcut it will pass a value to the
form (or Function)in Access. I'm using the AutoExec macro
to open the form right now. Just don't know how to get the
value from outside to inside access.
Thank you for your help,
Allen

 

[Cheryl Fischer]

In Access Help, check out the topic: Startup command-line options. Perhaps
the /cmd option will work for you.

 

[Allen]

I'll try that.
Thank you for your help and time.

-----Original Message-----
In Access Help, check out the topic: Startup command- line options. Perhaps
the /cmd option will work for you.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX




.