var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to display the result of a query in notepad with a specific delimiter
do you know how to display the result of a query in the notepad with a delimiter, for example semicolon.
thanks for suggestion
Export the query to a Text file using
Just have a look to its help
what I actually need is the notepad to open and the data to be displayed there. With transfertext method you can write the data to a specified filename. I would like not to save the txt file before the data is written in it. Another question about the transferdata: is it possible to define your own delimiter? thanks
To open the NotePad use the
Shell("C:\WINDOWS\NotPad.EXE", 1) '
You can not send the data to the NotPad directly, you have to store them to a .txt file at first then open it using the NotPad
Shell("C:\WINDOWS\NotPad.EXE yourFileName.txt", 1)
To change the Delimiter you have to write your own Procedure using the
Open yourExportFile For Output As #1
thank hammbakka, I think i'm getting closer. Could you specify a bit more how to set a delimiter. I'm using the transfertext method that transfer the values beetween quotes and delimited by new line.
If you detrimine a specification function name, in which you can choose your Del. then you can write its name in the statement
DoCmd.TransferText acExportDelim, " yourSpecificationName", yourTableOrQueryName, "C:\yourExportFile.txt"