Hi All,
I currently have a btn that exports my query to a text file but as of now I have it hard coded as to where to save and file name. Preferably I would like to allow the user to be prompted to name the file. I'm very new to this and was hoping to be pointed in the best direction.
Thank you
I currently have a btn that exports my query to a text file but as of now I have it hard coded as to where to save and file name. Preferably I would like to allow the user to be prompted to name the file. I'm very new to this and was hoping to be pointed in the best direction.
Code:
Public Sub btn_export_Click()
DoCmd.TransferText transferType:=acExportDelim, SpecificationName:="NGExport", TableName:="qry_RecordsNG_Export", FileName:="V:\_Records\Notary\Name txt files\test.txt", hasfieldnames:=False
End Sub
Thank you