Use Current Date on text file

  • Thread starter Sammy via AccessMonster.com
  • Start date
S

Sammy via AccessMonster.com

I'm have a button on a form that will transfer text from a query to a text
file on my c:drive named "testfile05-01-07.txt"

I need to transfer text everyday, once a day. I don't want to overwrite the
file each time. Instead I want to create a new file each day with the above
name but the current date: example testfile05-02-07, then on the next day a
new file should be named "testfile05-03-07", etc..

Here's my code to transfer to the text file:
DoCmd.TransferText acExportDelim, , "QryExport", "c:\temp\testfile05-01-07.
txt", True

Please help.

Thanks,
Sammy
 
K

Klatuu

Sammy, here is a suggestion for you.
Scott's answer is partially correct, but the problem is it will create a
file name like
c:\temp\testfile05\01\2007.txt
Which is probably not what you want. There are issues with the \ in file
names. In addition, to easily locate the file visually, I would suggest you
use a year, month, day format. It will sort them in date order that way.
Here is what I would use:

DoCmd.TransferText acExportDelim, , "QryExport", "c:\temp\testfile" &
Format(Date,"yy-mm-dd") & ".txt", True
 
Top