how to name a text file with the current DATE() TIME() ?

[Guest]

I'm trying to export a txt file with the current date and time as the name of
the file, like "20061031_113015.txt" the name needs to reflect the new
date-time every time I send the command.
The data of the file will be base on a table that will be generate prior to
the exporting process.
The trigger will be in a control on a form in the "After Upadte" property.
Thank you for your help.

 

[Guest]

Create your file name in a variable and use that in the file name argument of
the TransferText.

strFileName = Format(Now(),"yyyymmdd_hhmmss.txt")

 

[Guest]

Thank you that worked just perfect.
How do I specify the path where the file will be create?

 

[Guest]

Thanks I just change the default folder on the properties secction.

 

[Guest]

If it will allways be the same path and you want to hard code it,
strFileName = "C:\SomeFolder\" & Format(Now(),"yyyymmdd_hhmmss.txt")

If it wil vary and you want the user to be able to choose the path, see the
code at this site:
http://www.mvps.org/access/api/api0001.htm