Dear All,

I want to open an access database via a shortcut, that will be sent in an email. I would like to pass an argument into the application which could be used by the start-up form to select a particular record to display.

Is this possible? I know I can choose which form/page to display on start-up but is there any way to send arguments, something akin to the way you can pass information in a URLs query string.

Any suggestions appreciated.

Welcome to P2P. You're talking about something akin to an argument in DOS, i.e.

C:\Program Files\Microsoft Office\Office10\msaccess.exe myfile.mdb %1

Where the %1 will be read by myfile.mdb when it opens. Then based on %1, the mdb will open one form or another. Right?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Yes, I think so. I'd like to create the shortcut in advance and then be able to link to the shortcut and pass the argument value allow with the shortcut address?

Then once Access opens be able to read this argument as a variable for my form.

My ultimate goal is to create a textual link to a shortcut or the location of the mdb file, in an email, which will also specify the record I wish the initial form to open in Access.