when using TransferText, I have problems with the name of the file

[nancylynn]

I am exporting data from a table when a certain form is closed. When exporting the data, I need the filename to be a specified format. For example, the filename has to start with a "T" and then include the day of the month followed by the time in military format. For example:
J21014602.txt

Is this possible?? How?

 

[Steve101]

Nancy,

Check out the "User Defined Date Time Formats" online documentation for the Format function. It should help you to do what you want.

eg. FileName = "T" & (format(now,"ddhhnnss&quot returns a string based on the current datetime, in day, hour, minute, second format, and prefixed with the letter "T".

Im unsure of the standard military format, but this should put you on track,
Cheers,
Steve