Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TransferText Export FileName

Status
Not open for further replies.
Jackie

Jackie

MIS
Feb 9, 2000
148
US
How do you use the TransferText action and allow the user to enter the destingation for the exported file.

When a file name is not specified, I would like Access 2000 to display the "Export Query Window" that allows the user to specify a filename and distination.

Leaving this parameter blank as indicated below causes an error.

DoCmd.TransferText acExportDelim, "TblInspections Export Specification", "qry_export_inspection_data", , False, ""


Thank you,

Jackie
 
Status
Not open for further replies.

Similar threads

FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
803
Andrzejek
Andrzejek
aldi07
  • Locked
  • Question
Exporting PwerPoint slides as jpg into a folder using vba Access 1
Replies
6
Views
384
aldi07
aldi07
tbclbd
  • Locked
  • Question
Export Access tables to CSV file - records need to have varying record lengths
Replies
1
Views
281
Darrylles
Darrylles
Trob70
  • Locked
  • Question
Export to Excel - Comma in a string 1
Replies
2
Views
120
Andrzejek
Andrzejek
puforee
  • Locked
  • Question
Can I export query data to .xlsm file
Replies
13
Views
580
puforee
puforee

Part and Inventory Search

Sponsor

Back
Top