Prev: Format Memo field
Next: Custom toolbar in advanced filter query window
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