The OutputTo macro command outputs files into the MyDocuments folder, and I have a process which needs to do that periodically… but if there are leftover files from the last time that was run, my user gets hit with a dozen requests to overwrite the preceding files. I’d like to delete those from within the Microsoft Access 2003 macro which creates the reports, but I don’t see how to do that.
Alternatively, if I could send the files to a specific directory (e.g., C:\TEMP), I know how to delete files there; is there a way to direct the OutputTo command to send the files it creates to C:\TEMP?
Thank you kindly.