Software

Ask something
Discussion Locked

using ACCESS form field contents

0 helpful
5 replies

by agschuller

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Using ACCESS form field contents to provide parameter for a dos command.

I need to run a novell dos command 'rconsole' with a parameter that is the contents of a field populated after a combo box value has been selected. What I'm trying to do is automate the command to find the server name and prompt me for a password right away, rather than scrolling through the network to find the server name. I'm stumped here. Any help would be greatly appreciated.

5 replies

by it_cowboy

you could possibly use the "Shell" command which will run an external app. These can be run with parameters, but can be tricky, you have to get all your delimiters in the command right.

Create a windows shortcut with a parameter that works then copy and paste the shortcut into the shell command. Replace the parameter of the shortcut with the variable from the combo box".

ie: your command is "rconsole"
The code for your command button click event would be:
X = Shell("rconsole " & Me!cboServer, vbNormalFocus)

That might work. Post the actual command with a parameter if you cannot get it to work and I'll have a look if you like.

by agschuller

Thanks for the reply, but I already tried that and it failed. Either I didn't do it correctly or the value of the looked up field didn't flow as a parameter for the Netware command that I'm trying to run based on the parameter.

This discussion is closed to new replies.