Saving Acces tables as a .txt file

  • Thread starter Thread starter Dena
  • Start date Start date
D

Dena

I have a database that was created in Access 2000. Some
of our clients have upgraded to Access 2003 and we are
having trouble with a macro.. We are trying to save a
table as a .txt file. The macro saves the table as
a .txt file, but it will not put our Company Code in
front of .txt. Here's how the macro is set up:

Transfer Text: Export Delimited
Specification Name: FinalAudit Export Specification
Table Name: FinalAudit
File Name: ="c:\audit\"&[Forms]![frmFederalMenu]!
[frmCountComplete]!
Code: 
&".txt"

Any Suggestions!!

Thanks
Dena
 
Dena,

What name is the text file being saved as?

Normally the syntax should have spaces around the &s, i.e.
="C:\audit\" & [Forms]![frmFederalMenu]![frmCountComplete]!
Code: 
 & ".txt"

Also, where is the macro being triggered from?  For example, if it is
activated from an event on the frmFederalMenu form, try it like this...
="C:\audit\" & [frmCountComplete].[Form]![Code] & ".txt"
 
Back
Top