[VBA Access] exporting query with parameter

[Brunner]

I have a procedure in the access' module and I want it to export a query to
an xls file:

but the problem is that it must be exported with parameter (ex. date range).
And that's the problem:

"How to export query with parameter?"

Any ideas?


Brunner

 

[Cindy M.]

Hi Brunner,

I have a procedure in the access' module and I want it to export a query to
an xls file:


but the problem is that it must be exported with parameter (ex. date range).
And that's the problem:

"How to export query with parameter?"

Any ideas?

The best place to ask this would be an ACCESS newsgroup - very few Access
specialists frequent the office.developer groups. In a general way, what you'd
need to do is generate the QueryDef as part of your code. Then you can specify
any parameters as part of the SQL that makes up the query. While I could,
given time, work this out for myself again, I think it's better if you get
help from people who really know what they're doing

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail