3011 - Transfertext

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have a form that exports a table with the following command:
docmd.transfertext asExportFixed, "tbl_el Export Specification",
"tbl_el", "C:\tbl_el.txt"

That works great on my test system. When I copy the database and send
it to my client, they get - 3011 can't the object find "tbl_el#txt".
(Yes #).

I've verified that tbl_el Export Specification exists. I create the
table in code. The only time I use the TXT extension is in the docmd.

Any ideas?

Jim
 
Hello Jim,

This (with the #) can happen if the export specification doesn't
actually match the structure of the query or table being exported.
Typically, there's a discrepancy in the field names. That sounds
unlikely in the situation you describe, but a couple of web searches
over the years haven't suggested anything else.
 
Back
Top