Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
records per page in detail section
Hi, I am creating a report at runtime, whose recordsource is SQL query. I can get a report all right, but in print preview mode it displays only three records per page in detail section. How do i print more records per page? I have code like this. strSqlQuery = "Select * from...- SPC03
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
labels at runtime in report header section
Hi, I am trying to create labels in report header section at runtime. The number of labels vary each time. I am using code like this. DoCmd.OpenReport "Report1", acViewDesign Set rpt = Reports("Report1") Set lblNew = CreateReportControl(rpt.Name, acLabel, acHeader, _, ...- SPC03
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
