pass a parameter value into a macro argument

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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]
 
Back
Top