Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-25-2019, 09:33 AM   #1
dcavaiani
Newly Registered User
 
Join Date: May 2014
Location: Appleton, WI
Posts: 336
Thanks: 238
Thanked 23 Times in 23 Posts
dcavaiani is on a distinguished road
A set location for the Report summary

[code] Private Sub DummyGroupFooter_Format(Cancel As Integer, FormatCount As Integer)
Dim footerPos As Long
' Dim countspace As Long
' countspace = countspace + 1
footerPos = 7.6 * 1440 'desired position of footer in inches * 1440 twips per inch)
If Me.Top < footerPos Then
Me.DummyGroupFooter.Height = footerPos - Me.Top

Else
Me.DummyGroupFooter.Height = footerPos
End If

End Sub[code]

The code above allows me to always print the Invoice Summary at a SET location toward the bottom of the page. The invoice can have a variable number of detail lines. The invoice has some vertical column/grid lines between columns of the detail. IS THERE ANY way to code the above so that the vertical lines can appear continuously down the page - all the way down to the start of the summary section ??

dcavaiani is offline   Reply With Quote
Old 11-25-2019, 09:44 AM   #2
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A set location for the Report summary

Hi. Which vertical lines were you referring to? Did you draw these lines on the report? Or, did you add these lines using code?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
dcavaiani (11-25-2019)
Old 11-25-2019, 09:46 AM   #3
dcavaiani
Newly Registered User
 
Join Date: May 2014
Location: Appleton, WI
Posts: 336
Thanks: 238
Thanked 23 Times in 23 Posts
dcavaiani is on a distinguished road
Re: A set location for the Report summary

Quote:
Originally Posted by theDBguy View Post
Hi. Which vertical lines were you referring to? Did you draw these lines on the report? Or, did you add these lines using code?
They are lines drawn on the detail report section ...

dcavaiani is offline   Reply With Quote
Old 11-25-2019, 09:54 AM   #4
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A set location for the Report summary

Quote:
Originally Posted by dcavaiani View Post
They are lines drawn on the detail report section ...
Okay, thanks. Have you tried modifying their height properties in the Format property of the Detail section? Just a thought...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
dcavaiani (11-25-2019)
Old 11-25-2019, 10:02 AM   #5
dcavaiani
Newly Registered User
 
Join Date: May 2014
Location: Appleton, WI
Posts: 336
Thanks: 238
Thanked 23 Times in 23 Posts
dcavaiani is on a distinguished road
Re: A set location for the Report summary

Quote:
Originally Posted by theDBguy View Post
Okay, thanks. Have you tried modifying their height properties in the Format property of the Detail section? Just a thought...
Just tried that and no good.
dcavaiani is offline   Reply With Quote
Old 11-25-2019, 10:18 AM   #6
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A set location for the Report summary

Quote:
Originally Posted by dcavaiani View Post
Just tried that and no good.
No good as in they don't change or something else?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
dcavaiani (11-25-2019)
Old 11-25-2019, 10:48 AM   #7
dcavaiani
Newly Registered User
 
Join Date: May 2014
Location: Appleton, WI
Posts: 336
Thanks: 238
Thanked 23 Times in 23 Posts
dcavaiani is on a distinguished road
Re: A set location for the Report summary

Quote:
Originally Posted by theDBguy View Post
No good as in they don't change or something else?
If I change the height of the Detail vertical lines, then the detail section just stretches way down the page for each detail line record. Some kind of modified code is needed in the Dummy Section.

dcavaiani is offline   Reply With Quote
Old 11-25-2019, 10:56 AM   #8
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,112
Thanks: 20
Thanked 405 Times in 396 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: A set location for the Report summary

You may need to calculate where the last detail line ends, then make the footer taller and have lines in the footer also. I haven't tried this before though.
Mark_ is offline   Reply With Quote
The Following User Says Thank You to Mark_ For This Useful Post:
dcavaiani (11-25-2019)
Old 11-25-2019, 10:56 AM   #9
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A set location for the Report summary

Quote:
Originally Posted by dcavaiani View Post
If I change the height of the Detail vertical lines, then the detail section just stretches way down the page for each detail line record. Some kind of modified code is needed in the Dummy Section.
Okay, I think I am starting to understand it now. Are you able to post a demo copy of your db, so we can play around with it?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
dcavaiani (11-25-2019)
Old 11-25-2019, 11:00 AM   #10
dcavaiani
Newly Registered User
 
Join Date: May 2014
Location: Appleton, WI
Posts: 336
Thanks: 238
Thanked 23 Times in 23 Posts
dcavaiani is on a distinguished road
Re: A set location for the Report summary

Quote:
Originally Posted by theDBguy View Post
Okay, I think I am starting to understand it now. Are you able to post a demo copy of your db, so we can play around with it?
How do I post the only the Table and the report ?
dcavaiani is offline   Reply With Quote
Old 11-25-2019, 11:03 AM   #11
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,112
Thanks: 20
Thanked 405 Times in 396 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: A set location for the Report summary

Quote:
Originally Posted by dcavaiani View Post
How do I post the only the Table and the report ?
Create a new DB.
Import ONLY the report and the table into the new DB.
Delete all records that you don't want others to see and add in some sample data.
Compact/Repair then upload.
Mark_ is offline   Reply With Quote
The Following User Says Thank You to Mark_ For This Useful Post:
dcavaiani (11-25-2019)
Old 11-25-2019, 11:05 AM   #12
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A set location for the Report summary

Please don't forget to zip it up. Thank you.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
dcavaiani (11-25-2019)
Old 11-25-2019, 11:06 AM   #13
dcavaiani
Newly Registered User
 
Join Date: May 2014
Location: Appleton, WI
Posts: 336
Thanks: 238
Thanked 23 Times in 23 Posts
dcavaiani is on a distinguished road
Re: A set location for the Report summary

Here it is
Attached Files
File Type: accdb forumPost.accdb (428.0 KB, 9 views)
dcavaiani is offline   Reply With Quote
Old 11-25-2019, 11:12 AM   #14
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A set location for the Report summary

Quote:
Originally Posted by dcavaiani View Post
Here it is
Hi. Would it be possible for you to zip it up? Thanks.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
dcavaiani (11-25-2019)
Old 11-25-2019, 11:33 AM   #15
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,814
Thanks: 457
Thanked 908 Times in 872 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: A set location for the Report summary

Zipped as as requested.
Attached Files
File Type: zip forumPost.zip (51.5 KB, 5 views)

__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
The Following 2 Users Say Thank You to Gasman For This Useful Post:
dcavaiani (11-25-2019), theDBguy (11-25-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
report summary jerry28ph Reports 3 01-10-2009 09:15 AM
Report Summary mithani Reports 5 08-16-2007 05:35 PM
Summary Report iazcac Reports 1 02-18-2005 11:34 AM
Report Summary paulreed Reports 1 03-02-2004 10:48 AM
REPORT SUMMARY linda sciallo Reports 2 08-23-2001 09:28 AM




All times are GMT -8. The time now is 11:35 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World