DoCmd.OutputTo problem

[VALKYR]

I have a little problem , and i can not understand why this happens.

I want to output a record to a text (txt) file , but i can not get it to work on it`s own.

i use this code :

DoCmd.OutputTo acReport, "record", "Text Files", "C:/temp/record.txt"

i tryed without the format and path parameters , and after i select what i wnat it outputs the file , but this way it does not work.

i tryed inseta of "Text Files" acFormatTXT ... nothing

if i use "Snapshot Format" and snp extension , everything works ...

Does any of you know why this happens ?

 

[whitespace]

I might be being a bit thick here but have you tried

DoCmd.OutputTo acReport, "record", "Text Files", "C:\temp\record.txt"

(As in using backslash instead of forward slash)

 

[VALKYR]

interesting ... it works ...

thanks for the advice ... i did not think to try this ways because the snapshot format worked .. so i figured it was something else , not the path , thanks again