How To ......

[Alain]

Hi to all,

I have build a report generator which allow the end user to select some
criteria and some sorting option to open report according to he's needs by
clicking on a command button..
The main query I use is a Select with no WHERE or Order By clause which it
is already saved in the db.

What I need to do is to take that query export the data thru a command
button in Excel instead of running the report.On the Export, the user needs
the option to save the file wherever he want.

Can anyone point me into the right direction on how to do this

Many Thanks

Alain

 

[Duane Hookom]

Check the query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. It has
all this functionality and more. You just need to import some objects into
your mdb and create a few master queries.

 

[Alain]

Thanks for the info.
I'll look at it

Alain

Check the query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. It has
all this functionality and more. You just need to import some objects into
your mdb and create a few master queries.