From: Douglas J. Steele on 23 Nov 2009 15:58 Sorry, nothing comes to mind. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "gmazza via AccessMonster.com" <u37142(a)uwe> wrote in message news:9f8f82508d24f(a)uwe... > strFile = "P:\Nav\SCMHeader0000001.txt" > > Douglas J. Steele wrote: >>What's in strFile when the TransferText command is running? >> >>>I don't have that extension, I have & ".txt" >>> >>[quoted text clipped - 31 lines] >>>>>>>>in >>>>>>>>them. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1 >
From: gmazza via AccessMonster.com on 23 Nov 2009 16:11 Its weird because when I take out the specs and just leave a comma like this: DoCmd.TransferText acExportDelim, , "SCMHeader", strFile then the Export works fine, but every field in the .txt file has quotes around it. Only way to get rid of the quotes is to use specs no? So when I remove the specs the Export doesn't complain about a file not exisitng, but now I have no specs and need to get rid of the quotes. Any thoughts on that? Douglas J. Steele wrote: >Sorry, nothing comes to mind. > >> strFile = "P:\Nav\SCMHeader0000001.txt" >> >[quoted text clipped - 5 lines] >>>>>>>>>in >>>>>>>>>them. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1
First
|
Prev
|
Pages: 1 2 3 Prev: Format Memo field Next: Custom toolbar in advanced filter query window |