TransferText Error with Export spec

P

PaulP

I'm using Access 2007 with Windows XP. When I specify the Export Spec within
the code I get an error "The text file spec 'Create-Pallet-Labels' does not
exist." I can run the code without the spec. I see the spec in the list of
saved exports.

Do I need some type of qualification so that the spec can be found within
the form?
The code is assigned to a button on a form.

Code:
Private Sub Pallet_Label_Button_Click()
On Error GoTo Err_Pallet_Label_Button_Click

DoCmd.TransferText acExportDelim, "Create-Pallet-Labels",
"Pallet-Label-Extract", _
"C:\Pallet-Labels.CSV", False

Exit_Pallet_Label_Button_Click:
Exit Sub

Err_Pallet_Label_Button_Click:
MsgBox Err.Description
Resume Exit_Pallet_Label_Button_Click

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top