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
|
|||
|
|||
Problem with a watermark section
I want to add a watermark to my report, so I created a report section by
defining a new Group with the expression '=1' and Group Header = Yes. I put my watermark fields in the section header, and I put the line Me.MoveLayout = False in the section Format event. This works for the first page of my report, but I want to print the watermark on all pages. My problem is, when I set the Repeat Section property to Yes, my report locks up -- in fact, Access itself is completely locked up and I have to kill the process (which is using all of the CPU). I put a breakpoint on the MoveLayout statement, and it appears that there is some kind of endless loop that is constantly calling the watermark section Format event. My report is based on a single record from the database and contains no other Sorting or Grouping sections. The report also contains several embedded subreports. Does anyone have any ideas about what the problem might be? Thanks for any information, Carl Rapson |
#2
|
|||
|
|||
Could you create the watermark by just setting the Picture property of the
report? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carl Rapson" wrote in message ... I want to add a watermark to my report, so I created a report section by defining a new Group with the expression '=1' and Group Header = Yes. I put my watermark fields in the section header, and I put the line Me.MoveLayout = False in the section Format event. This works for the first page of my report, but I want to print the watermark on all pages. My problem is, when I set the Repeat Section property to Yes, my report locks up -- in fact, Access itself is completely locked up and I have to kill the process (which is using all of the CPU). I put a breakpoint on the MoveLayout statement, and it appears that there is some kind of endless loop that is constantly calling the watermark section Format event. My report is based on a single record from the database and contains no other Sorting or Grouping sections. The report also contains several embedded subreports. Does anyone have any ideas about what the problem might be? Thanks for any information, Carl Rapson |
#3
|
|||
|
|||
Yes, that works, thanks. I guess I'll go with that method.
I was trying the 'report section' method because some posts I've seen recommended that over the Picture method. Plus, it should work, and I'm wondering why it doesn't. Is there any difference between the two methods, from a resource or performance standpoint? Carl Rapson "Allen Browne" wrote in message ... Could you create the watermark by just setting the Picture property of the report? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carl Rapson" wrote in message ... I want to add a watermark to my report, so I created a report section by defining a new Group with the expression '=1' and Group Header = Yes. I put my watermark fields in the section header, and I put the line Me.MoveLayout = False in the section Format event. This works for the first page of my report, but I want to print the watermark on all pages. My problem is, when I set the Repeat Section property to Yes, my report locks up -- in fact, Access itself is completely locked up and I have to kill the process (which is using all of the CPU). I put a breakpoint on the MoveLayout statement, and it appears that there is some kind of endless loop that is constantly calling the watermark section Format event. My report is based on a single record from the database and contains no other Sorting or Grouping sections. The report also contains several embedded subreports. Does anyone have any ideas about what the problem might be? Thanks for any information, Carl Rapson |
#4
|
|||
|
|||
Are you using any [Page] or [Pages] in your report?
-- Duane Hookom MS Access MVP "Carl Rapson" wrote in message ... Yes, that works, thanks. I guess I'll go with that method. I was trying the 'report section' method because some posts I've seen recommended that over the Picture method. Plus, it should work, and I'm wondering why it doesn't. Is there any difference between the two methods, from a resource or performance standpoint? Carl Rapson "Allen Browne" wrote in message ... Could you create the watermark by just setting the Picture property of the report? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carl Rapson" wrote in message ... I want to add a watermark to my report, so I created a report section by defining a new Group with the expression '=1' and Group Header = Yes. I put my watermark fields in the section header, and I put the line Me.MoveLayout = False in the section Format event. This works for the first page of my report, but I want to print the watermark on all pages. My problem is, when I set the Repeat Section property to Yes, my report locks up -- in fact, Access itself is completely locked up and I have to kill the process (which is using all of the CPU). I put a breakpoint on the MoveLayout statement, and it appears that there is some kind of endless loop that is constantly calling the watermark section Format event. My report is based on a single record from the database and contains no other Sorting or Grouping sections. The report also contains several embedded subreports. Does anyone have any ideas about what the problem might be? Thanks for any information, Carl Rapson |
#5
|
|||
|
|||
The advantage of the Picture is that it makes it dead easy to have the
sections print on top of the graphic, positioning the graphic absolutely on the page, while still growing/shrinking sections as needed. I do have a dim recollection regarding a memory leak in earlier versions of Access where you used the Picture property of a form or report: perhaps that is what you are asking about? I've no idea whether this has been fixed, but it should not be an issue unless you are opening the report hundreds of times in a session. It's certainly the normal approach I use for showing company logo/letterheads on reports. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carl Rapson" wrote in message ... Yes, that works, thanks. I guess I'll go with that method. I was trying the 'report section' method because some posts I've seen recommended that over the Picture method. Plus, it should work, and I'm wondering why it doesn't. Is there any difference between the two methods, from a resource or performance standpoint? Carl Rapson "Allen Browne" wrote in message ... Could you create the watermark by just setting the Picture property of the report? "Carl Rapson" wrote in message ... I want to add a watermark to my report, so I created a report section by defining a new Group with the expression '=1' and Group Header = Yes. I put my watermark fields in the section header, and I put the line Me.MoveLayout = False in the section Format event. This works for the first page of my report, but I want to print the watermark on all pages. My problem is, when I set the Repeat Section property to Yes, my report locks up -- in fact, Access itself is completely locked up and I have to kill the process (which is using all of the CPU). I put a breakpoint on the MoveLayout statement, and it appears that there is some kind of endless loop that is constantly calling the watermark section Format event. My report is based on a single record from the database and contains no other Sorting or Grouping sections. The report also contains several embedded subreports. Does anyone have any ideas about what the problem might be? Thanks for any information, Carl Rapson |
#6
|
|||
|
|||
Sorry it took me so long to respond, I "lost" this thread.
Yes, I'm using both [Page] and [Pages] in the PageHeader section. I have a text box with the Control Source set to: ="Page " & [Page] & " of " & [Pages] Carl Rapson "Duane Hookom" wrote: Are you using any [Page] or [Pages] in your report? -- Duane Hookom MS Access MVP "Carl Rapson" wrote in message ... Yes, that works, thanks. I guess I'll go with that method. I was trying the 'report section' method because some posts I've seen recommended that over the Picture method. Plus, it should work, and I'm wondering why it doesn't. Is there any difference between the two methods, from a resource or performance standpoint? Carl Rapson "Allen Browne" wrote in message ... Could you create the watermark by just setting the Picture property of the report? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carl Rapson" wrote in message ... I want to add a watermark to my report, so I created a report section by defining a new Group with the expression '=1' and Group Header = Yes. I put my watermark fields in the section header, and I put the line Me.MoveLayout = False in the section Format event. This works for the first page of my report, but I want to print the watermark on all pages. My problem is, when I set the Repeat Section property to Yes, my report locks up -- in fact, Access itself is completely locked up and I have to kill the process (which is using all of the CPU). I put a breakpoint on the MoveLayout statement, and it appears that there is some kind of endless loop that is constantly calling the watermark section Format event. My report is based on a single record from the database and contains no other Sorting or Grouping sections. The report also contains several embedded subreports. Does anyone have any ideas about what the problem might be? Thanks for any information, Carl Rapson |
#7
|
|||
|
|||
What happens if you remove either both or at least [Pages]?
-- Duane Hookom MS Access MVP "Carl Rapson" wrote in message ... Sorry it took me so long to respond, I "lost" this thread. Yes, I'm using both [Page] and [Pages] in the PageHeader section. I have a text box with the Control Source set to: ="Page " & [Page] & " of " & [Pages] Carl Rapson "Duane Hookom" wrote: Are you using any [Page] or [Pages] in your report? -- Duane Hookom MS Access MVP "Carl Rapson" wrote in message ... Yes, that works, thanks. I guess I'll go with that method. I was trying the 'report section' method because some posts I've seen recommended that over the Picture method. Plus, it should work, and I'm wondering why it doesn't. Is there any difference between the two methods, from a resource or performance standpoint? Carl Rapson "Allen Browne" wrote in message ... Could you create the watermark by just setting the Picture property of the report? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carl Rapson" wrote in message ... I want to add a watermark to my report, so I created a report section by defining a new Group with the expression '=1' and Group Header = Yes. I put my watermark fields in the section header, and I put the line Me.MoveLayout = False in the section Format event. This works for the first page of my report, but I want to print the watermark on all pages. My problem is, when I set the Repeat Section property to Yes, my report locks up -- in fact, Access itself is completely locked up and I have to kill the process (which is using all of the CPU). I put a breakpoint on the MoveLayout statement, and it appears that there is some kind of endless loop that is constantly calling the watermark section Format event. My report is based on a single record from the database and contains no other Sorting or Grouping sections. The report also contains several embedded subreports. Does anyone have any ideas about what the problem might be? Thanks for any information, Carl Rapson |
#8
|
|||
|
|||
When I removed [Page] and [Pages] from my Page header section, things did
change a bit. After about 15 seconds the forms flashed (as if they were refreshing) and I was able to continue working. But I never did see the report; the report icon appeared briefly in the task bar at the bottom of the screen, but the report window never opened. It looks like the report was cancelling itself for some reason. Carl Rapson "Duane Hookom" wrote in message ... What happens if you remove either both or at least [Pages]? -- Duane Hookom MS Access MVP |
#9
|
|||
|
|||
I have no further suggestions other than what I would do:
-play with it or -live with it or -replace it -- Duane Hookom MS Access MVP "Carl Rapson" wrote in message ... When I removed [Page] and [Pages] from my Page header section, things did change a bit. After about 15 seconds the forms flashed (as if they were refreshing) and I was able to continue working. But I never did see the report; the report icon appeared briefly in the task bar at the bottom of the screen, but the report window never opened. It looks like the report was cancelling itself for some reason. Carl Rapson "Duane Hookom" wrote in message ... What happens if you remove either both or at least [Pages]? -- Duane Hookom MS Access MVP |
#10
|
|||
|
|||
Thanks, I'll probably do a combination of (1) and (3)
Carl "Duane Hookom" wrote in message ... I have no further suggestions other than what I would do: -play with it or -live with it or -replace it -- Duane Hookom MS Access MVP "Carl Rapson" wrote in message ... When I removed [Page] and [Pages] from my Page header section, things did change a bit. After about 15 seconds the forms flashed (as if they were refreshing) and I was able to continue working. But I never did see the report; the report icon appeared briefly in the task bar at the bottom of the screen, but the report window never opened. It looks like the report was cancelling itself for some reason. Carl Rapson "Duane Hookom" wrote in message ... What happens if you remove either both or at least [Pages]? -- Duane Hookom MS Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Having problem with section headers | Henry Stock | Formatting Long Documents | 2 | September 24th, 2004 05:26 PM |
Reinstalling OE... | KAR | Outlook Express | 24 | August 21st, 2004 06:52 PM |
Setting up a header with chapter numbers and page numbers | Phil Stripling | New Users | 23 | August 16th, 2004 07:41 PM |
odd page section breaks | Bill Mitchell | Formatting Long Documents | 6 | June 17th, 2004 02:20 PM |
Bug in Access 2002 Reports | notbitmonk | Setting Up & Running Reports | 10 | May 22nd, 2004 05:47 PM |