Change File Name to Linked Database

[surfbum3000]

I created a macro with the following parameters:

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

I run the macro using Scheduled Tasks on the first day of each month. The macro works fine, but I have to manually open the macro each month and change the .mdb file name to the next month after it runs.

Is there a way to use code to change the Database Name to the the next month? In this example, the file name needs to be changed to C:\LOGS\102006CALLS.MDB

 

[PHV]

Use the DoCmd.TransferDatabase method and the Format and Date functions (all in VBA).

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