Fixed Position for Groupings

[Guest]

I am trying to create a cheque through reports that has details showing the
invoices being paid and a cheque body at the bottom.

I got the query to run so that the details shows twice (once for my records
and the other for the supplier) but I am having problems fixing the position
of the second part.

As an example:
----------------------------------------------------
[Details 1]
Supplier ABC

Invoice 1 $xxxxx
Invoice 2 $xxxxx
Invoice 3 $xxxxx
Invoice 4 $xxxxx
Total $XXXX

[Details 2]
Supplier ABC

Invoice 1 $xxxxx
Invoice 2 $xxxxx
Invoice 3 $xxxxx
Invoice 4 $xxxxx
Total $XXXX

[Cheque]

-------------------------------------

the problem is that I am running these cheques on preprinted forms and need
Details 2 to start a particular point. is there a way to make it static OR
should I make it so that my query for the cheque details is filled with blank
rows? if the latter is better, how could I do this?

 

[Guest]

I think that I can format the footer section for each detail section so that
it becomes static. I think that the code should be something like:


Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
Dim t As Single

t = Me.Detail.Height + Me.GroupHeader0.Height

Me.GroupFooter0.Height = 2.5 * 1440 - t
End Sub

but it doesn't seem to be working.

 

[Duane Hookom]

Consider removing your details from the main report and placing them in a
subreport or two.

 

[Guest]

thanks Duane. Should have thought about a simpler solution.

Consider removing your details from the main report and placing them in a
subreport or two.

--
Duane Hookom
MS Access MVP
--

I am trying to create a cheque through reports that has details showing the
invoices being paid and a cheque body at the bottom.

I got the query to run so that the details shows twice (once for my
records
and the other for the supplier) but I am having problems fixing the
position
of the second part.

As an example:
----------------------------------------------------
[Details 1]
Supplier ABC

Invoice 1 $xxxxx
Invoice 2 $xxxxx
Invoice 3 $xxxxx
Invoice 4 $xxxxx
Total $XXXX

[Details 2]
Supplier ABC

Invoice 1 $xxxxx
Invoice 2 $xxxxx
Invoice 3 $xxxxx
Invoice 4 $xxxxx
Total $XXXX

[Cheque]

-------------------------------------

the problem is that I am running these cheques on preprinted forms and
need
Details 2 to start a particular point. is there a way to make it static
OR
should I make it so that my query for the cheque details is filled with
blank
rows? if the latter is better, how could I do this?