Question on filling out a report

I kindof thought that was the appropriate action but I was having difficulty
figuring out how add the value in. I will research it more.

"Duane Hookom" wrote:

You should be able to adjust the intTopMargin value. You might have to
include the heights of the Report Header and possibly group headers or other
sections.
--
Duane Hookom
MS Access MVP

Modify
Private Sub Report_Page()
Dim intNumLines As Integer
Dim intLineNumber As Integer
Dim intTopMargin As Integer
Dim ctl As Control
Dim intLineHeight As Integer

intNumLines = 15
'height of page header (3) and report header (1)
intTopMargin = Me.Section(3).Height + Me.Section(1).Height
--
Duane Hookom
MS Access MVP


"default105" wrote in message
...
I kindof thought that was the appropriate action but I was having
difficulty
figuring out how add the value in. I will research it more.

"Duane Hookom" wrote:

You should be able to adjust the intTopMargin value. You might have to
include the heights of the Report Header and possibly group headers or
other
sections.
--
Duane Hookom
MS Access MVP

That works, in fact I was making it harder by using a absolute number for the
height.

Last question for you as I hope you do not mind. It displays the boxes now
in the detail section, however it boxes over the report footer layout (ie. if
i have 2 records, it showed the 2 records then immediately the report footer
with the boxes over it). Can it be setup that the report footer will always
be at the bottom of the last row of boxes be determining the detail section
height times 15 and set it to start there?

I have been looking for the numbers of the sections on a report. ie detail
= 0, where can I find that information at.

Thanks for all your help

"Duane Hookom" wrote:

Modify
Private Sub Report_Page()
Dim intNumLines As Integer
Dim intLineNumber As Integer
Dim intTopMargin As Integer
Dim ctl As Control
Dim intLineHeight As Integer

intNumLines = 15
'height of page header (3) and report header (1)
intTopMargin = Me.Section(3).Height + Me.Section(1).Height
--
Duane Hookom
MS Access MVP

There is a KB article on printing a group footer at a specific location that
might help http://support.microsoft.com/kb/208979/en-us.

Regarding the report sections:
Detail 0
Report Header 1
Report Footer 2
Page header 3
Page Footer 4
Level1 Header 5
Level1 Footer 6
....

--
Duane Hookom
MS Access MVP

"default105" wrote in message
...
That works, in fact I was making it harder by using a absolute number for
the
height.

Last question for you as I hope you do not mind. It displays the boxes
now
in the detail section, however it boxes over the report footer layout (ie.
if
i have 2 records, it showed the 2 records then immediately the report
footer
with the boxes over it). Can it be setup that the report footer will
always
be at the bottom of the last row of boxes be determining the detail
section
height times 15 and set it to start there?

I have been looking for the numbers of the sections on a report. ie
detail
= 0, where can I find that information at.

Thanks for all your help

"Duane Hookom" wrote:

Modify
Private Sub Report_Page()
Dim intNumLines As Integer
Dim intLineNumber As Integer
Dim intTopMargin As Integer
Dim ctl As Control
Dim intLineHeight As Integer

intNumLines = 15
'height of page header (3) and report header (1)
intTopMargin = Me.Section(3).Height + Me.Section(1).Height
--
Duane Hookom
MS Access MVP

default105 wrote:
That works, in fact I was making it harder by using a absolute number for the
height.

What units were you using for the height? Needs to be in Twips. Not
sure of the conversion from inches, but Cm*567. So if you put in a
small number, it would count as a very small distance!

--
Steve Schapel, Microsoft Access MVP

Well I figured from trial and error that it had to be a large number. I was
looking for a conversion to convert to twips. Was just looking at the post
from you yesterday and was reading the link you referred. Thanks for
everything, you guys are great, it is great to meet someone how likes to help
others learn. Says a lot about all you MVP's.

"Steve Schapel" wrote:

default105 wrote:
That works, in fact I was making it harder by using a absolute number for the
height.

What units were you using for the height? Needs to be in Twips. Not
sure of the conversion from inches, but Cm*567. So if you put in a
small number, it would count as a very small distance!

--
Steve Schapel, Microsoft Access MVP

It was a query problem, I was using union but found it needed to be union all.

Thanks for everything

"Steve Schapel" wrote:

You will need to enter some records into the Test table. I think you
will need 19. Did you do that already? You will need to enter data in
at least one of the fields, in order to create the records, so I suppose
that will be in a field that is not shown on the report.

Then, test out the queries by running them directly, to see how many
records are returned. The Union Query should return x+19 records, where
x is the number of records returned by your original query.

Let us know how you get on with that.

--
Steve Schapel, Microsoft Access MVP

I just want to say that Duane Hookom is the best and I hope to be half as
good as him one day. Thanks Duane, you have help me so much.