Button to launch an application

[jduenyas]

Hello all developers

I am trying to create a button that will launch ACCESS,  start an APPLICATION and pass the /User USERNAME /pwd PASSWORD string to open the application.

In the Actions tab of the Button, under Launch, I can manually enter the required string and the application opens correctly but if I try to pass the string as a variable the launch fails.

Why does the variable not get resolved to the string in this tab?

The actual string in the the FileName box in the Action tab should be:

APPLICATIONName /user UserName /pwd UserPassword

I tried setting the variable vVariableString as

= 'APPLICATIONName /user ' & UserName & ' /pwd  ' & UserPassword

and as

'APPLICATIONName /user ' & UserName & ' /pwd  ' & UserPassword

=vVariableString nor =$(vVariableString) seemed to work

any ideas?

Thanks

[isingh30]

Did you check the parameters option under launch action in button?

Thanks.

[jduenyas]

When entering the parameters in the box Parameters the loaded ACCESS dos not open the Named application.

When changing the data in the Filename to the variable it fails altogether.

[isingh30]

I am not sure but you can do this with macro.

Thanks.

[jduenyas]

Thanks.

That's an idea. I will try that too.