Peter,
It was suggested to use the TransferText function as with you can use your
saved Export Specification. Did you try that?
--
Gina Whipp
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
in message
Hi, Did you ever get a reply to your question? I am trying to do the same
thing and cannot work out how to do it.
Regards
PaulP wrote:
How to run a saved export from within VBA
23-Oct-09
I have saved an export to a text file that is based on data from a query. I
would like to assign this to a button on a form. Anyone have examples or ho
to info???
Previous Posts In This Thread:
How to run a saved export from within VBA
I have saved an export to a text file that is based on data from a query. I
would like to assign this to a button on a form. Anyone have examples or ho
to info???
=A0Ior house TransferText and use the query name as the object you want
=A0I
or ho
use TransferText and use the query name as the object you want to
export.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Started with SQLite and Visual Studio
http://www.eggheadcafe.com/tutorial...b-b6f46d4f2c6a/get-started-with-sqlite-a.aspx