Create report by VBA

[hin87_at_yahoo.com]

Hi

How can I create a report by vb codes?


Thanks,

 

[Duane Hookom]

Start by opening any module/code window and pressing F1. Search for
"CreateReport" and then "CreateReportControl". This type of solution isn't
for the beginner. Is there a particular requirement of your application to
create reports on the fly?

 

[hin87_at_yahoo.com]

Anybody have any ideas on this??

 

[hin87_at_yahoo.com]

Yes, I have fields that need to expand horizontal base on the number
of columns.

Take example,

Mon
Tue
Wed

I would create only 3 fields
Mon Tue Wed

instead ofcreating 7 fields for
Mon Tue Wed Thu Fri

 

[Duane Hookom]

Did you read up on the functions that I suggested? I think you would be much
better creating a report with extra controls and then make them visible or
not and set control sources and other properties.

We might need to know more about your requirements so we could provide other
suggestions.