How to run a saved export from within VBA

P

PaulP

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???
 
P

pietlinden

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???

use TransferText and use the query name as the object you want to
export.
 
P

Peter Swettenham

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.
would like to assign this to a button on a form. Anyone have examples or h
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.
would like to assign this to a button on a form. Anyone have examples or h
to info???

=A0Ior house TransferText and use the query name as the object you want
=A0
or h

use TransferText and use the query name as the object you want t
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
 
G

Gina Whipp

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top