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
Thank You Billpower, that worked, may i ask you one more question? There is lot of space between page header and Detail section in PrintPreview mode. How do i reduce that? Thanks again. SPC03- SPC03
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
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
thank you Scriverb! You are right,I had a page header section and i was trying to put label in report header section.Thanks again. SPC03- SPC03
- Post #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)
