Can User Input Be Used in a TransferDatabase MACRO ???

  • Thread starter Thread starter kev100 via AccessMonster.com
  • Start date Start date
K

kev100 via AccessMonster.com

I posted a question similar to this in the Import/Linking forum....and
received a possible VBA coding solution.

This may be the more appropriate forum and am posting here, just in case.
Since I'm not real familiar with VBA coding...I'm hoping there may be some
little-known feature in Access that makes this possible...

I've set up a Macro to Import a non-Access table into an Access table.

In the TransferDatabase macro...there is a field for the source table name.
I currently have the exact name of the source table..and it works fine.

However, I'm needing to prompt the User for the NAME of the Source table that
is being imported.

In other words....is it possible to use some type of user input for that
field of the Macro...rather than it being fixed?

There are several tables....any one of which the user may need to import
depending on the task at hand.

Is it possible to use some sort of paramater input variable in the source
table field?

Something like...
Source: [Enter Table Name Suffix:] (?)

I have tried the above syntax....but it does not work...I only used it to try
to illustrate what is needed.

Thanks very much.
 
Back
Top