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

100+
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??

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


MindBender77
100+
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?

Regards,
Bender
Dec 12 '08 #2

100+
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

Command

eg

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

hope this clears things up

Dan
Dec 12 '08 #3

ADezii
Expert 5K+
P: 8,624
@Dan2kx
Kindly reference this previous Thread:
http://bytes.com/topic/access/answer...perlink-filter
Dec 12 '08 #4

100+
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

Dan
Dec 13 '08 #5

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

Post your reply

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