OutPut To

[shart00]

I would like to set up a macro that when ran will output reports as a snapshot to a folder on the server. The problem is that I do not want the files to be overwritten each time the macro runs. Therefore, I am looking for a way to include the date in the file name to be saved. Such as when it runs today the file would be:
Attendance 021405
run tomorrow:
Attendance 021505

The format of the date does not matter that much, as long as it can be understood and does not overwrite the previous day's report.

Any suggestions?

 

[PHV]

Time to play with VBA (Format and Date functions, DoCmd.OutputTo method).

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