By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

Command line Values

P: 365
my apologies if this is covered elsewhere, but the search facility failed to respond for me...

but my question is as follows:

As i understand you can use the addition of /cmd followed by a variable and access cn use this as a VB variable, reading the helpfiles the code to use this is just (inVB)

if Command = "Value" then do what ever you want

but i cannot seem to return a value, and ideas??

Dec 12 '08 #1
Share this Question
Share on Google+
5 Replies

P: 234
I'm having some trouble understand what it is your attempting to do. Are you asking for information on the usage of docmd in MS Access?

Dec 12 '08 #2

P: 365
No there is a set of controls called command line switches, these allow you to set DB passwords/ open exclusively/ parse a valiable in VB.

How to use command-line switches in Microsoft Access

i am interested in /cmd

the methodology as i understand is that you edit your shortcut to the DB to in clude

"c:\filename\blah.mdb" /cmd "Variable"

to use this variable according to access help you just need to refer to it as



if Command = "Variable" then msgbox "hello it worked"

hope this clears things up

Dec 12 '08 #3

Expert 5K+
P: 8,624
Kindly reference this previous Thread:
Dec 12 '08 #4

P: 365
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Test\Northwind.mdb" /cmd "Fuller"
(all one line obv.)
this is the sortcut path that works, you must open access 1st, followed by db then /cmd

thaks for the link ADezil and the OP of the info

Dec 13 '08 #5

Expert 5K+
P: 8,624
You are quite welcome.
Dec 13 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.