|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 16th, 2005, 11:37 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Adding / Removing Page Breaks
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 ** 
|
|
#2
November 17th, 2005, 12:38 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Adding / Removing Page Breaks
Michelle
Any chance the circumstances could be handled by group, page or report header/footer section-level events? Regards Jeff Boyce Office/Access MVP "Michelle M" wrote in message ... 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 **
|
|
#3
November 18th, 2005, 01:49 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Adding / Removing Page Breaks
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 "Jeff Boyce" wrote in message ... Michelle Any chance the circumstances could be handled by group, page or report header/footer section-level events? Regards Jeff Boyce Office/Access MVP "Michelle M" wrote in message ... 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 **
|
|
#4
November 18th, 2005, 07:51 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Adding / Removing Page Breaks
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 "Michelle M" wrote in message ... 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 "Jeff Boyce" wrote in message ... Michelle Any chance the circumstances could be handled by group, page or report header/footer section-level events? Regards Jeff Boyce Office/Access MVP "Michelle M" wrote in message ... 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 **
|
|
#5
November 19th, 2005, 03:16 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Adding / Removing Page Breaks
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 "Jeff Boyce" wrote in message ... 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 "Michelle M" wrote in message ... 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 "Jeff Boyce" wrote in message ... Michelle Any chance the circumstances could be handled by group, page or report header/footer section-level events? Regards Jeff Boyce Office/Access MVP "Michelle M" wrote in message ... 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 **
|
|
#6
November 19th, 2005, 05:54 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Adding / Removing Page Breaks
Thanks Larry for your feedback
I'll give that a go. Regards Michelle "Larry Linson" wrote in message ... 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 "Jeff Boyce" wrote in message ... 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 "Michelle M" wrote in message ... 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 "Jeff Boyce" wrote in message ... Michelle Any chance the circumstances could be handled by group, page or report header/footer section-level events? Regards Jeff Boyce Office/Access MVP "Michelle M" wrote in message ... 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 **
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Inserting page breaks is a pull down menu - removing is not cover | Dave Stroman | General Discussion | 2 | May 23rd, 2005 08:28 PM |
| Inserting page breaks is a pull down menu - removing is not cover | Treesy | General Discussion | 0 | May 13th, 2005 12:03 AM |
| Page number difficulties | Tjodrik | General Discussion | 3 | May 9th, 2005 02:54 PM |
| FIrst page footers | Noel S Pamfree | General Discussion | 7 | December 6th, 2004 08:49 PM |
| Insert objects at page breaks | DRS - Jonathan | General Discussion | 4 | November 29th, 2004 07:16 PM |
Linear Mode
