TransferText command failing !?!

  • Thread starter Thread starter Dorian
  • Start date Start date
D

Dorian

I have a TransferText command that just started to fail, it worked fine in
the past and no coding changes have occurred. The odd thing is I have an
error trap and err.description returns a blank and err.number is zero. How do
I debug this? What could cause this to fail. here is the code:
strPath = "C:\Exports\TWS\TWS_"
DoCmd.TransferText acExportFixed, "tblTechAssigned", "tblTechAssigned",
strPath & "tblTechAssigned.txt"
There are a series of such commands above this line (for other tables) and
they all worked fine. Yes the table exists and so does the path.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
On error is triggered and goes to my error handler (which then displays
err.description). Its always triggered at the same point exporting this
particular table.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Hi,
Neither is true, code is not falling through. On error is being triggered,
it is the only way to get to my error handler. There are no err.clear
statements.
As I said this code worked until the beginning of this year, then stopped
working, no code changes have been made.
I just noticed though, in my error handler,I do have an 'On Error Resume
Next' before displaying the error, does that reset the error object?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
The intention was not to allow any further errors in the error handler....
but I guess I need another way.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top