Create report by VBA

  • Thread starter Thread starter hin87_at_yahoo.com
  • Start date Start date
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?
 
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
 
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.
 
Back
Top