(Msg. 9) Posted: Tue Jul 22, 2008 12:59 pm
Post subject: Re: Help with drawing horizontal line in Access subreport 2003 Add to elertz [Login to view extended thread Info.] Archived from groups: microsoft>public>access>reports (more info?)
Hi Marshall,
I tried this code but it just draws the horizontal line for the last
detail for the subreport rather than the last detail on each page of
the subreport. Is there a way around this? I tried putting the
=count(*) in the page header but it just comes up with #ERROR.
(Msg. 10) Posted: Wed Jul 23, 2008 12:31 am
Post subject: Re: Help with drawing horizontal line in Access subreport 2003 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
jeremy.wy.chong RemoveThis @gmail.com wrote:
>I tried this code but it just draws the horizontal line for the last
>detail for the subreport rather than the last detail on each page of
>the subreport. Is there a way around this? I tried putting the
>=count(*) in the page header but it just comes up with #ERROR.
Sorry, I thought that what's you wanted.
The last detail on each page can be a problem when the
detail can grow because you can not tell if the next detail
will fit on the same page.
If this were in the main report, you could save the bottom
of each detail section in a module level variable or a
hidden text box. Then the Page event could draw the line at
the saved position. Maybe(?) there's some way for the
subreport to trigger the main report to take care of it??
If the detail were not allowed to grow. You could then use
code something like this:
If pageheight - bottommargin - Me.Top < 2 * Me.Height Then
(Msg. 11) Posted: Wed Jul 23, 2008 2:01 am
Post subject: Re: Help with drawing horizontal line in Access subreport 2003 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Marsh,
Thanks for your input but unfortunately I really need the textboxes to
be able to grow! See I have absolutely no problems doing this if it
was the main report but the real problem is that I need this as a
subreport! Do you have any more ideas?
(Msg. 12) Posted: Wed Jul 23, 2008 12:23 pm
Post subject: Re: Help with drawing horizontal line in Access subreport 2003 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Marsh,
I will give it a go with the main report drawing the line in the page
event. I assume I can check with code which subform is showing and
therefore draw the line only when that subform is showing. I'll give
it a go and let you know how I go, thanks
(Msg. 13) Posted: Wed Jul 23, 2008 1:45 pm
Post subject: Re: Help with drawing horizontal line in Access subreport 2003 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
jeremy.wy.chong RemoveThis @gmail.com wrote:
>Thanks for your input but unfortunately I really need the textboxes to
>be able to grow! See I have absolutely no problems doing this if it
>was the main report but the real problem is that I need this as a
>subreport! Do you have any more ideas?
>
Have you tried getting the main report's Page event to draw
the line?
If you don't have any idea how to go about that, please post
all the details about the line: start position; end
position or length; and vertical position within the detail
section. With that info, I'll see what, if anything I can
figure out.
(Msg. 14) Posted: Wed Jul 23, 2008 4:03 pm
Post subject: Re: Help with drawing horizontal line in Access subreport 2003 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I gave it a go but I have no idea what sort of syntax to use to check
if that subreport is showing on the current page of the main
report..... it also makes it very tricky that the subreport I am
checking is actually a subreport in a subreport of the main report...
doh!
(Msg. 15) Posted: Thu Jul 24, 2008 5:37 pm
Post subject: Re: Help with drawing horizontal line in Access subreport 2003 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
jeremy.wy.chong.TakeThisOut@gmail.com wrote:
>I gave it a go but I have no idea what sort of syntax to use to check
>if that subreport is showing on the current page of the main
>report..... it also makes it very tricky that the subreport I am
>checking is actually a subreport in a subreport of the main report...
Hoo Boy, that does make it complicated indeed. Give me a
day or two to find time to investigate all this.
(Msg. 16) Posted: Sun Jul 27, 2008 1:21 pm
Post subject: Re: Help with drawing horizontal line in Access subreport 2003 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks heaps for your help Marshall, it is much appreciated.
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2, 3
Page 2 of 3
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other