problem with file name....

[erin_0502]

hie friends......................

why when i use this coding

DoCmd.TransferText acExportDelim, , td.Name, sExportLocation & td.Name & ".txt", True

the file name look like this td.Name not exactly in text file (td.Name.txt)

can anibody help me....

 

[Guus2005]

R U sure?
The command looks fine to me!

 

[erin_0502]

i think so but when i see the file it not exactly....

 

[Guus2005]

Try this:

     Dim strFilename as string

     strFilename = sExportLocation & td.Name & ".txt"
     debug.print strfilename
     DoCmd.TransferText acExportDelim, , td.Name, strFilename, True

Check your immediate window.
If td.Name is valid, perhaps "td.Name" is the value of the variable td.Name?

HTH

 

[Bungle]

Do you have Windows set to display extensions for known file types on that folder?

 

[erin_0502]

Do you have Windows set to display extensions for known file types on that folder?

No....did importent to i have Windows set...
can u give me more explination...

 

[erin_0502]

Try this:

     Dim strFilename as string

     strFilename = sExportLocation & td.Name & ".txt"
     debug.print strfilename
     DoCmd.TransferText acExportDelim, , td.Name, strFilename, True

Check your immediate window.
If td.Name is valid, perhaps "td.Name" is the value of the variable td.Name?

HTH

I'm still cannot get exactly file name with .txt file when i try using this code

 

[erin_0502]

thank for every one....
my problem ok now....
hehehe....
thank a lot....