Problem with TransferText
am 09.01.2008 21:12:09 von stuart.medlinI seem to have a problem with the use of the TransferText function.
In 2 applications that I have, every few months, it seems to not
export a few records from a table. In another application, every 2-3
months the users would start getting run time errors after they
exported data from my program.
Is anyone aware of problems with this function with these kind of
results. The following is a code fragement:
TIA
Stuart
----------------------------------------------------------
'Create the Pesticide text file names
Card1File = dbDir & "PAACard1.txt"
Card2File = dbDir & "PAACard2.txt"
Card3File = dbDir & "PAACard3.txt"
'Delete the pest card text files
Call DeleteCardFiles(Card1File, Card2File, Card3File)
'Create final text file by appending julian day to the file name
"PAA200"
PAAFile = dbDir & "paa200." & DatePart("y", Now())
'Export the data from tables PestCard1, PestCard2, PestCard3 into
the 3 text
'files. These 3 text files will then be joined into 1 file.
DoCmd.TransferText acExportFixed, "PestCard1 Export Specification",
_
"PestCard1", Card1File, False, ""
DoCmd.TransferText acExportFixed, "PestCard2 Export Specification",
_
"PestCard2", Card2File, False, ""
DoCmd.TransferText acExportFixed, "PestCard3 Export Specification",
_
"PestCard3", Card3File, False, ""