Printing Blank Records to Complete a Report

I don't know what you mean by "borders are not uniform and consistant (over
the entire report)". What are you reffering to with the term "borders". Do
you actually mean section heights? Can you be more specific?

There are a couple lines in the code that set the top margin. This allows
you to accommodate Report and Page Header heights.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


"pu5 via AccessMonster.com" wrote:

Ok, thanks for your help. The problem is that the report borders are not
uniform and consistant (over the entire report). The borders on the Detail
section are consistent but not on the Header.

Duane Hookom wrote:
I'm not sure you are understanding that if the draw lines are expected to
start on the page where the actual records leave off, I am not aware of how
to do this. That is why my code is designed to start creating lines exactly
where the first record on the report appears.

Generally, removing all borders from controls and applying consistent
lines/rectangles over printed records and extra spaces works.

No the grid that it printed was fine; however, I need it to start at the end
of the subform records and not overlay the entire report (Header). The
[quoted text clipped - 9 lines]

Can anyone provide help for this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200711/1

Is there a way I can email (attach) the form to you so that you see what I am
describing?

Duane Hookom wrote:
I don't know what you mean by "borders are not uniform and consistant (over
the entire report)". What are you reffering to with the term "borders". Do
you actually mean section heights? Can you be more specific?

There are a couple lines in the code that set the top margin. This allows
you to accommodate Report and Page Header heights.

Ok, thanks for your help. The problem is that the report borders are not
uniform and consistant (over the entire report). The borders on the Detail
[quoted text clipped - 13 lines]

Can anyone provide help for this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200711/1

I'm not sure why you can't describe your report sections, heights, and where
the draw lines begin printing on the page.

You have mentioned "form" more than once. Can we assume you are printing a
report and not a form? Is the a subreport in your report?

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


"pu5 via AccessMonster.com" wrote:

Is there a way I can email (attach) the form to you so that you see what I am
describing?

Duane Hookom wrote:
I don't know what you mean by "borders are not uniform and consistant (over
the entire report)". What are you reffering to with the term "borders". Do
you actually mean section heights? Can you be more specific?

There are a couple lines in the code that set the top margin. This allows
you to accommodate Report and Page Header heights.

Ok, thanks for your help. The problem is that the report borders are not
uniform and consistant (over the entire report). The borders on the Detail
[quoted text clipped - 13 lines]

Can anyone provide help for this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200711/1

This report prints similar to a form/subform (in my opinion). There are the
following sections...
PageHeaderSection = 0.333"
GroupHeader0 = 4.2083"
Detail = 0.4167"
PageFooterSection = 0.3333"

The GroupHeader0 and Detail sections obviously have significanlty different
layouts (based on the size). The GroupHeader0 contains "non-uniform" lines
and borders. The Detail section contains (4) fields (Tasks, Responsibility,
CompletionTiming & Comments) displayed in a spreadsheet type format.
Originally I had borders print around each of these fields. To match a
"Company" form, I need the detail section to print (12) rows regardless of
the number of Tasks. There may only be (2) actual rows of Detail data; so, I
need (10) additional rows of blank spreadsheet/boxes to fill the page. If
there were (5) actual rows of Detail data I would then need (5) additional
rows of blank spreadsheet/boxes to fill the page.

Hope this is clearer.


Duane Hookom wrote:
I'm not sure why you can't describe your report sections, heights, and where
the draw lines begin printing on the page.

You have mentioned "form" more than once. Can we assume you are printing a
report and not a form? Is the a subreport in your report?

Is there a way I can email (attach) the form to you so that you see what I am
describing?
[quoted text clipped - 11 lines]

Can anyone provide help for this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200711/1

Have you attempted to adjust the intTopMargin to account for your Group
Header? Do you only have one group header per page?

What is your final code? We can't see the lines that are being printed so
you have to tell us if they are too high or low or what.

Can you please understand that I am not smart enough to write code that
-determines how many records will print on the page
-calculate where the records (details) will stop on the page
-subtract the number of records from 12
-finish the page by drawing 12-recordcount extra blanks

I can only tell you how to print 12 sets of lines on your page beginning at
the same place on each page. The place the lines/boxes begin is set in the
code.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


"pu5 via AccessMonster.com" wrote:

This report prints similar to a form/subform (in my opinion). There are the
following sections...
PageHeaderSection = 0.333"
GroupHeader0 = 4.2083"
Detail = 0.4167"
PageFooterSection = 0.3333"

The GroupHeader0 and Detail sections obviously have significanlty different
layouts (based on the size). The GroupHeader0 contains "non-uniform" lines
and borders. The Detail section contains (4) fields (Tasks, Responsibility,
CompletionTiming & Comments) displayed in a spreadsheet type format.
Originally I had borders print around each of these fields. To match a
"Company" form, I need the detail section to print (12) rows regardless of
the number of Tasks. There may only be (2) actual rows of Detail data; so, I
need (10) additional rows of blank spreadsheet/boxes to fill the page. If
there were (5) actual rows of Detail data I would then need (5) additional
rows of blank spreadsheet/boxes to fill the page.

Hope this is clearer.


Duane Hookom wrote:
I'm not sure why you can't describe your report sections, heights, and where
the draw lines begin printing on the page.

You have mentioned "form" more than once. Can we assume you are printing a
report and not a form? Is the a subreport in your report?

Is there a way I can email (attach) the form to you so that you see what I am
describing?
[quoted text clipped - 11 lines]

Can anyone provide help for this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200711/1

That's it. Adjusting the intTopMargin did it (with a little trial and error).
Thanks again for your help.


Duane Hookom wrote:
Have you attempted to adjust the intTopMargin to account for your Group
Header? Do you only have one group header per page?

What is your final code? We can't see the lines that are being printed so
you have to tell us if they are too high or low or what.

Can you please understand that I am not smart enough to write code that
-determines how many records will print on the page
-calculate where the records (details) will stop on the page
-subtract the number of records from 12
-finish the page by drawing 12-recordcount extra blanks

I can only tell you how to print 12 sets of lines on your page beginning at
the same place on each page. The place the lines/boxes begin is set in the
code.

This report prints similar to a form/subform (in my opinion). There are the
following sections...
[quoted text clipped - 27 lines]

Can anyone provide help for this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200711/1

Sorry...one other question. Is there a way to change Line thickness?

Duane Hookom wrote:
Have you attempted to adjust the intTopMargin to account for your Group
Header? Do you only have one group header per page?

What is your final code? We can't see the lines that are being printed so
you have to tell us if they are too high or low or what.

Can you please understand that I am not smart enough to write code that
-determines how many records will print on the page
-calculate where the records (details) will stop on the page
-subtract the number of records from 12
-finish the page by drawing 12-recordcount extra blanks

I can only tell you how to print 12 sets of lines on your page beginning at
the same place on each page. The place the lines/boxes begin is set in the
code.

This report prints similar to a form/subform (in my opinion). There are the
following sections...
[quoted text clipped - 27 lines]

Can anyone provide help for this?

--
Message posted via http://www.accessmonster.com

You can adjust the line width with code like:
Me.DrawWidth = 10
This must be coded prior to the line method.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


"pu5 via AccessMonster.com" wrote:

Sorry...one other question. Is there a way to change Line thickness?

Duane Hookom wrote:
Have you attempted to adjust the intTopMargin to account for your Group
Header? Do you only have one group header per page?

What is your final code? We can't see the lines that are being printed so
you have to tell us if they are too high or low or what.

Can you please understand that I am not smart enough to write code that
-determines how many records will print on the page
-calculate where the records (details) will stop on the page
-subtract the number of records from 12
-finish the page by drawing 12-recordcount extra blanks

I can only tell you how to print 12 sets of lines on your page beginning at
the same place on each page. The place the lines/boxes begin is set in the
code.

This report prints similar to a form/subform (in my opinion). There are the
following sections...
[quoted text clipped - 27 lines]

Can anyone provide help for this?

--
Message posted via http://www.accessmonster.com

That's great...all is working fine. Again, thanks for your help and patience.



Duane Hookom wrote:
You can adjust the line width with code like:
Me.DrawWidth = 10
This must be coded prior to the line method.
Sorry...one other question. Is there a way to change Line thickness?

[quoted text clipped - 19 lines]

Can anyone provide help for this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200711/1