pass a parameter value into a macro argument

[dan_in_nz]

Hi.
I am writing a macro that will create tables using information from a remote
ODBC database. I am using the TransferDatabase method. To set this up to
work, you need to enter arguments for the ODBC link name, server name.
database name, password and login. I can hardcode these for one location, but
is there a way to set up parameters so that other users in other locations
can enter the information relevant to their sites and have it passed into the
macro arguments. Running MS Access 2000 on Win2k Pro Sp3.

 

[Douglas J. Steele]

I think you'll need to use VBA to get that capability.

 

[Steve Schapel]

Dan,

You can set up a form with unbound textboxes or comboboxes, where the
user can enter the ODBC connection string etc, and then refer to these
controls in the arguments of your TransferDatabase macro action, using
syntax such as...
=[Forms]![NameOfForm]![NameOfControl]