With Saving (export?) records; naming the exportfile and path

[TjS]

Situation wanted within access db:
1 push button [export]
2. pop-up [save as], with browser to search for a path
3. typing a filename
4. clicking on [save]

But, dont know how to do that...please advise

 

[ezfriend]

To save the file, check out this site: http://www.mvps.org/access/api/api0001.htm

This will allow you to define the location and file name that you will be saving to.
Look at the variable in that website: strSaveFileName

Once you have this file name, you can use the DoCmd.TransferText to export your data from the table.

e.g.

If strSaveFileName <> "" then 'assuming that the user enter the file name
DoCmd.TransferText acExportDelim, , TableName, strSaveFileName
End If

Hope this help.

ez.