473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Command line Values

365 100+
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
5 1377
MindBender77
234 100+
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
Dan2kx
365 100+
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
8,834 Expert 8TB
@Dan2kx
Kindly reference this previous Thread:
http://bytes.com/topic/access/answer...perlink-filter
Dec 12 '08 #4
Dan2kx
365 100+
"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
8,834 Expert 8TB
@Dan2kx
You are quite welcome.
Dec 13 '08 #6

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

Similar topics

4
by: Edvard Majakari | last post by:
Hi, I was wondering what would be the most elegant way for creating a Python class wrapper for a command line utility, which takes three types of arguments: 1. options with values (--foo=bar)...
9
by: Manlio Perillo | last post by:
Regards. In the standard library there are two modules for command line parsing: optparse and getopt. In the Python Cookbook there is another simple method for parsing, using a docstring. ...
5
by: Stewart Saathoff | last post by:
Hello, I was wondering if anyone knows how to parse command line variables upon execution of an application. For example, I want to be able to type this at a command line: "myapp.exe...
6
by: Ben | last post by:
I'm designing a fairly involved database system. As part fo the process, I use the \i command a great deal. I set up fairly involved queries, sometimes simply for the purpose of shortening column...
5
by: clsmith66 | last post by:
I've been asked to find out if a project is possible, but I'm not having much luck finding the information I need, I hope some one can help. I need to see if I can build a windows service on the...
8
by: Andrew Robert | last post by:
Hi Everyone. I tried the following to get input into optionparser from either a file or command line. The code below detects the passed file argument and prints the file contents but the...
5
Deathwing
by: Deathwing | last post by:
Helll I am trying to figure out how to enter arguments throught he command line for a program I have created that is already working. I just want to adapt it to work at the command line. Here is the...
0
pbmods
by: pbmods | last post by:
FIXING NETINFO ERRORS ON THE COMMAND LINE LEVEL: ADVANCED PREREQS: TERMINAL / COMMAND LINE, USERS AND GROUPS Intro Today, while performing routine maintenance, I noticed that I was no...
2
by: db2learner | last post by:
Hi, I am new to DB2 and i just started worked on it a couple of days back. I have created basic EMPLOYEE table from control centre which has 2 fields: EmpNo, EmpName. I am trying to write...
51
by: Ojas | last post by:
Hi!, I just out of curiosity want to know how top detect the client side application under which the script is getting run. I mean to ask the how to know whether the script is running under...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.