Can I pass a variable via command line?

's Computer Specifications

Can I pass a variable via command line like this....?

MyDatabase.mdb "blue"

I couldn't figure out how?

's Computer Specifications

Yes, but your command line must include a reference to the Access
executable, not simply to the MDB file, and you must precede the parameter
with /cmd (or a semi-colon):

"C:\Program Files\Microsoft Office\Office\MSAccess.exe"
"C:\MyFolder\MyDatabase.mdb" /cmd blue

To retrieve the parameter, you use the Command function.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"AbraAbraCadabra" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Can I pass a variable via command line like this....?
>
> MyDatabase.mdb "blue"
>
> I couldn't figure out how?
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sql to pass value to variable to pass to text box	DawnTreader	Microsoft Access Form Coding	4	27th Jan 2009 08:33 PM
How do you pass a jscript variable to a vbscript variable ?	=?Utf-8?B?VEpBTg==?=	Windows XP Internet Explorer	2	6th Jul 2007 02:42 PM
How to pass variable between different variable	hon123456	Microsoft Excel Programming	0	13th Jun 2006 10:17 AM
Pass variable to command button on click event on form	=?Utf-8?B?SlJfMDYwNjIwMDU=?=	Microsoft Access VBA Modules	1	7th Feb 2006 11:19 PM
How to pass a variable to a SQL command	Quarantine	Microsoft ASP .NET	2	28th Jan 2004 03:08 AM