Import file name that changes

[surfbum3000]

I want to import a file name that changes on the 1st of every month. I am using a macro to link to a table within the database. Is there a way I can import a Database Name that changes every month, on the 1st of the month? The format of the filename is MMYYYYCALLS.MDB. The current filename is 062005CALLS.MDB and on 07-01-2005 a new file will be created named 072005CALLS.MDB which I will need to link to.

Action=TransferDatabase
Transfer Type=Link
Database Type=Microsoft Access
Database Name=C:\LOGS\072005CALLS.MDB
Object Type=Table
Source=LoggedCalls
Destination=LoggedCalls
Structure Only=No

 

[PHV]

Have a look at the DoCmd.TransferDatabase method you can play with in VBA and at the Format and Date VBA functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886