pass arguments to access

gecko_1

Registered User.
Local time
Today, 22:27
Joined
Feb 7, 2005
Messages
39
Hello,

I want to be able to pass arguments to an access file on start up. I want to be able to grab this value and then perform an action based on this.

Background:
The program will send an email with details for a change request, the recipient will then need to click on a link to accept or reject this change. So I want them to be able to click the link which will trigger the program to save accept or reject.

Regards,
Todd
 
You could use the /cmd option to pass arguments to VB and extract using the Command() function.
 
The other alternative involves creating an environmental variable and then using a Win32 API interface to read your environment. However, this does require more research than richary's option. I'm mentioning it only as an alternative.
 
The simplest solution is to creat a spreadsheet that you import or link to. It will be easy to change and be able to support many columns and rows. It will be much more flexible than just a single argument.
 

Users who are viewing this thread

Back
Top Bottom