TransferText-naming file

[Cindy_B]

Hey, I finally got the TransferText macro up and running with a button on the form. It pulls text fields from a query into a comma delimited file and saves as 'myfile.txt' which leads me to another question...
The query is set to automatically pull records from the currrent data so all the user has to do is click the button. However, the users would like to be able to name the file first before the TransferText runs. As of now, every day the file with different date info is saved in the same text file, overwriting the existing file. If someone forgets to go in and rename the file, it gets overwritten. (No big deal because it can be run again just by changing the date in the query.) But, it would be nice and smooth just to let the user name the file everyday. Is this possible?
Thanks!!!!

Cindy

 

[jfgambit]

Cindy:
Not sure how your VB skills are, but look this link over to learn how to create a common dialog box for exporting files:

http://www.mvps.org/access/api/api0001.htm

 

[Cindy_B]

My VB skills are basic...I don't think I can handle the info on that link. I guess there's no other way?
But thanks for replying.