Create report by VBA

D

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?
 
H

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
 
D

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.
 
Top