Merge data from Access to Word - Access 2002

g'day,

last week the following code was working:

DoCmd.TransferText acExportMerge, , "tblAcknowledgment", "c:\temp\Acknowledgment.txt", True

today I am getting run time error 3011:

"Jet engine cannot find object 'Acknowledgment#txt' etc.

I also tried:

DoCmd.TransferText acExportMerge, , "tblAcknowledgment", "c:\temp\Acknowledgment" & ".txt", True

suggestions would be appreciated

Dave
dcobauAsked:
Who is Participating?
 
Bob LambersonConnect With a Mentor Software EngineerCommented:
Hi dcobau,
> run time error 3011
Have you checked out
    http://support.microsoft.com/?kbid=225987  ?

Bob
0
 
dcobauAuthor Commented:
thanks Bob, any idea why it does not over write the ini file like it used to do?

thanks again

Dave
0
 
Bob LambersonSoftware EngineerCommented:
I suspect it is a MS "feature" - thanks for the acknowledgement.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.