Re: pass a parameter value into a macro argument

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 01/16/05 

Date: Sun, 16 Jan 2005 16:51:25 -0500

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

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"dan_in_nz" <dan_in_nz@discussions.microsoft.com> wrote in message 
news:EE060AD6-A1AA-45A9-83C9-8586274B5F3F@microsoft.com...
> 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.