Creating Reports using VBA

  • Thread starter Thread starter johnb
  • Start date Start date
J

johnb

Hi all

I have a QBF with 10 fields which the user can select
any combination of fields to create a query. I need to
create a Report based on that ever changing query. I am
not sure how to attack this one. Suggestions gratefully
recieved.

TIA
johnb
 
IMHO, the best method is to push the records to Excel and open it. The user
will have total control over formatting of the final results. I have found
the most users are more comfortable with Excel and enjoy the creativity that
this allows.
 
Hi Duane
Thanks for your comments. Unfortunatly its not an option.
However I've cracked it. On page 665 of Litwin, Getz and
gunderloys book Acess 2002 Desktop developers handbook.
There a crosstab report that I've modified and it does
the job.

Many thanks

johnb
 
John,

I noticed you seem to have found a solution. I posted a message yesterday
regarding a very similar issue.

I was trying to approach it using the CreateReport command (Set RepVar =
CreateReport) with the idea of using the CreateReportControl function to
add the the controls.

It will create a report in design mode but I haven't been able to find how
to save or rename the report using VBA.

Any hints / cluse you would have on how to approach this would be
appreciated.

Sincerely,

Wayne Huxman
 
Back
Top