change output object to tab delimited

[Richard (South Africa)]

Currently under "design view", under "Macros", I have an "output to" record.
The "output type" has limited options, and I need to get this changed to "tab
delimited format". Please could someone offer some assistance, as I have
found nothing on the net. Thanks

 

[Steve Schapel]

Richard,

I suggest you have a look at the TransferText action, instead of OutputTo.

Go through your output procedure first, manualy, via the File|Export
menu, and when you get to the final screen of the export wizard, click
the 'Advanced' button, where you will be able to save your setup
(including the Tab delimiter) as a Specification. Then, enter this
specification in your macro, in the Specification Name argument of the
TransferText action.

 

[Richard (South Africa)]

Hi Steve

Thanks for the help. I did what you instructed and its working 99% right
now. The file exports no problem, but now I have a new problem, which seems
to be linked to the "transfertext"..

Before the "OutputTo" had an "autostart" feature which automatically opened
the file once the data was exported... now the "autostart" option is not
there. It is an essential part of the process that the file is opened once
the data has been exported. Please could you offer some advice.. thanks so
much, kind regards, Richard (South Africa)

 

[Steve Schapel]

Richard,

You will be able to use a RunApp action at the end of your macro to open
the file. Assuming it is to be opened with Notepad, the Command Line
argument of the RunApp will be something like this...
"C:\Windows\Notepad.exe" "C:\YourFolder\YourFile.txt"

 

[Richard (South Africa)]

Hi Steve

Thanks very much for all your help. Thanks to you I have been able to get it
all working 100%. I needed EXCEL to open the txt file, so I changed one or
two things, but its all working great.

Thanks very much again, I will be coming back HERE if I ever need help with
Access again.

Kind Regards,
Richard

 

[Richard (South Africa)]

Hi Steve

Didnt think I would be checking in so soon again...

At the moment everything works 100%, would just like to streamline my
process some more...

Right now the query connects to a SQL Database. So EVERYTIME I run the
query, it prompts me for the user and password for the SQL server I connect
to (local). Simply put, I need to untick the "Use Trusted Connection" and put
in my user and password each and everytime. This is extremely time consuming,
and not productive. Ive read on the net that it cant be changed, is this
true?? Some help would be great... thanks.

Kind regards,
Richard

 

[Steve Schapel]

Richard,

How are you connecting to the SQL Server database? Linked tables via ODBC?

I notice you have also multi-posted your question to the security
newsgroupo, so I will keep an eye over there.