Can I save file name including current date in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Microsoft Access 2000 I need to write a macro that includes the current
date in the filename when saving the output.
 
You can use String concatenation like:

"MyFileName" & "_" & Format(Date(), "yyyymmdd") * ".FileExtension"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to SaveAs current project with added Date & Time in filename 6
Access Transfer Text -how to save current date as file name 1
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Need help in VBA for embedded object in excel 1
IPhone sound quality gets worse each generation 5
Exporting a report as .snp with Date Stamp in Title 9
Export table to txt file with a variable filename 0
Import File Information 0

Back
Top