Access 2000 Conversion problem

[nagrajram]

Hi

I am converting some of the projects in Access 97 to Access 2000. One of the code viz., Docmd.TransferText, acExportDelim is not working. It worked in Access 97 but not in Access 2000. Can anyone help me out.

Nags

 

[simongallop]

It's part of Access 9.0 library. Ought to work but make sure that the comma has been removed after TransferText ie should be:

DoCmd.TransferText acExportDelim, etc..

HTH

 

[s0rtd]

same problem

Hi guys...
I am experiencing the same problem.. and my code has the comma removed:

 DoCmd.TransferText acExportDelim, , "tblpatientlabels", strMergeSourceDoc, True - 1

but still the file is not created..any help would be much appreciated.

cheers
Jurgen

 

[WayneRyan]

Hi Jurgen,

Haven't seen you in a while.

I think that what you need to do is get the code in Design View
and "update" your reference to Excel 9.0

Get code in design view,
Tools --> References
choose Excel 9.0

If you have multi-users, then they will tend to "toggle" the
reference back/forth. Then you will need software to switch
the reference back ... Or render the users immobile.

Wayne

 

[s0rtd]

yeah..i haven't been doing a lot with access lately.. but im back!

ok i tried what you suggested but all i have the option for is Microsoft Excel 11.0 Object Library, so i checked that one.

(im running office 2003)

i will see how this goes.

just tried it out - after restarting access, but still no luck.

 

[namliam]

True -1 = -2
true = -1
false = 0
Access is expecting a true or false there and getting neither. It really shouldnt work in 97 either.

Regards