PC Review

Thread Tools Rate Thread

TransferText Error with Export spec

Posts: n/a
      26th Oct 2009
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.

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 Sub

MsgBox Err.Description
Resume Exit_Pallet_Label_Button_Click

End Sub

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Saving Import/Export Spec Chris Moore Microsoft Access External Data 1 25th Sep 2009 12:45 AM
Inheritance of static members in the CLR spec vs the C# spec Tim Van Wassenhove Microsoft C# .NET 2 18th Aug 2007 09:35 PM
Re: Inheritance of static members in the CLR spec vs the C# spec GlennDoten Microsoft C# .NET 0 18th Aug 2007 04:06 PM
Export Spec Shannon Microsoft Access 1 23rd Jun 2004 01:25 PM
Import spec is "Empty" in TransferText command? JumboShrimps Microsoft Access External Data 4 9th Feb 2004 09:22 AM




All times are GMT +1. The time now is 09:31 PM.