Adding / Removing Page Breaks

  • Thread starter Thread starter Michelle M
  • Start date Start date
M

Michelle M

Hi all

I have an application which is a .mde front end / .mdb back end. Depending
on certain circumstances a page break needs to be added or removed from
within a particular report.

I used the DeleteReportControl and CreateReportControl to do this. While
this worked fine in my .mdb environment, you can't alter the design of
anything in the .mde environment using these control.

Can anyone suggest another way that I can do this using .mde? Or another
alternative method using .mdb but keeping the front end secure?

TIA
Michelle

** please only reply to newsgroup **
 
Michelle

Any chance the circumstances could be handled by group, page or report
header/footer section-level events?

Regards

Jeff Boyce
<Office/Access MVP>
 
Hi Jeff

Thanks for your response.

Sadly no, this report is very complex already using footers/ headers,
subforms, etc.

The only way to make the appropriate change is just add/delete the page
break as necessary.

Any other ideas? A possible side question : if I made this into a Access
Project, how does that affect front end/ back end in relation to keeping the
security on the front end (currently .mde)? (FYI: there are 6 users on the
system at the moment) I hope I have explained myself clearly, please let me
know if you need more information.

TIA
Michelle M
 
Michelle

I'll step back here, as I have no experience with programmatically
adding/removing page breaks. Hopefully, other responders do...

Regards

Jeff Boyce
<Office/Access MVP>
 
Consider not "adding" and "removing" the PageBreak, but including code to
make it "visible" (thus causing page break) or "not visible" (not causing a
page break).

Me!MyPageBreak.Visible = True
or
Me!MyPageBreak.Visible = False

If this is dependent on certain conditions, you will, of course, need to
test for those.

Put this code in the Format event of the section where the Page Break is
required.

Larry Linson
Microsoft Access MVP
 
Back
Top