A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Reports - sub-report same height



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2006, 07:37 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Access Reports - sub-report same height

Hello,

i have been working on an invoicing system in Access 2k for a while now. we
have successfully got vertical lines working in the sub-report thanks to
help from here. however we are having a nightmare trying to keep the
subreport which contains the invoice lines the same height with vertical
lines in place.

any ideas on how to keep the same height of a sub report , no matter how
many records there are, while always having vertical lines going down (we
are using me.line method to generate the vertical lines), but also allow for
a new page if the number of records are too much for one page ?????

please help
Thanks



  #2  
Old March 19th, 2006, 09:32 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Access Reports - sub-report same height

The calendar report at http://www.invisibleinc.com/divFiles.cfm?divDivID=4
has a layout with the same subreport 5 times across the detail section of
the main report. There is code that draws the appropriate lines in the main
report based on the sizes of the subreports.

--
Duane Hookom
MS Access MVP
--

"a" wrote in message
...
Hello,

i have been working on an invoicing system in Access 2k for a while now.
we have successfully got vertical lines working in the sub-report thanks
to help from here. however we are having a nightmare trying to keep the
subreport which contains the invoice lines the same height with vertical
lines in place.

any ideas on how to keep the same height of a sub report , no matter how
many records there are, while always having vertical lines going down (we
are using me.line method to generate the vertical lines), but also allow
for a new page if the number of records are too much for one page ?????

please help
Thanks





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create dbase and Form to add Client & report access Larry Daugherty New Users 2 February 24th, 2006 06:04 PM
Printing Reports Access 2002 Pleas Advise Dermot Database Design 12 October 5th, 2005 11:23 AM
Ambiguous Name Error pm Using Forms 10 June 5th, 2005 09:19 PM
2002 vs 2003 Patrick Stubbin General Discussion 2 May 17th, 2005 07:27 AM
Save Report With CreateReport Coding Issue Jeff Conrad Setting Up & Running Reports 8 July 12th, 2004 08:39 AM


All times are GMT +1. The time now is 05:02 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.