Transfer Database_Part 3

[Rich_Lovina]

I'm running a macro which transfers 5 Access tables weekly into one new table. The import file name changes every week, so can I create a prompt "Amend Import File Name!", such that I do not have to keep amending 5 Append Queries before I start the macro?

The file name has a pattern, e.g

AB##-01-09-01, where both ## and the date need to change.
Many thanks any help on this.

 

[Travis]

Create a form with a text box and a command button. Use this referance in the Queries instead of the Hardcoded name:

Forms![YourFormName].[TextFieldName]

Make sure to validate that the Text field has a valid formated name on the Click Event of the Button prior to running your Queries.

 

[Rich_Lovina]

Tks for input, Travis, but I'm not sure where to place the Forms reference in the queries, such that it would replace the task of right-clicking the mouse, click properties, and changing path details e.g c:/unzipped/ab##01-09-01.mdb.