asked on Can I suppress Page 1 of an Access report?
Just curious if I can throw some VBA in the On Load event of an access report to suppress or hide page one. I have a rather unusual (so I think) report where all of my data is in the Report Footer. Because I'm using just the report footer and my data extends more than one page, I'm getting a blank first page. If there is some kind of cancel vba I can put on the report so that it will suppress the first page, that will accomplish my goal perfectly!
Thanks for the help!
Thanks for the help!
Microsoft Access
Last Comment
Jeremy Campbell
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Guess I should have mentioned I tried that.. I set all their visibilities to false and set the height to 0..
Do you know if it is possible to connect to my datasource for this report in VBA and keep the report unbound, then I could place all of my sumations, which are currently in the report footer in the detail section?
Do you know if it is possible to connect to my datasource for this report in VBA and keep the report unbound, then I could place all of my sumations, which are currently in the report footer in the detail section?
<<Do you know if it is possible to connect to my datasource for this report in VBA and keep the report unbound, then I could place all of my sumations, which are currently in the report footer in the detail section?>>
Absolutly.
See my second comment though first.
Jim.
Absolutly.
See my second comment though first.
Jim.
ASKER
Thanks Jim.. That did the trick for that. Just needed to set KeepTogether property to false.
Jim.