Report from Query Automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I have many Queries already made in a database. Now I want to create reports
with these queries, one report to each query.
However they count more than 1000 queries, so I wolud like to use VB.

Does anybody know how to create Reports from Queries automatically using VB?

Thanks a lot!

Marcelo
 
Hi Marcelo,
hmm, not sure that building 1000 similar reports is a good idea.
i think best way would be to build some generic report, which will show any
of your queries in some standard way.
or maybe several reports, if you can group your queries into categories
somehow - say products, customers, etc
 
Hi Alex, tnahks for your answer.

Unfortunely, I can´t join all these reports because each one has to be sent
to a different customer.
I really would like to use a macro to generate all of them, but this idea of
generate a generic standardized report maybe can fit as solution.
Do you know how to do it, to generate a report from a box where you choose
the customer´s name?

Thanks again,

Marcelo

"Alex Dybenko" escreveu:
 
Hi Marcelo,
well, i can not give you some detailed advice, as i dont know all
requirements. just few ideas:
"each one has to be sent to a different customer" - you can build a table
with query name-custmer details and customize report based on this table

If you need to send each customer its own data - then certainly you can make
one reports and filter customer data on report open event

Also you can build reports using VBA, but this is a lot of job. Help gives
you few examples, look at CreateReport method
 
Back
Top