Urgent Help - Need to print bank checks using Access

[nickspace]

Hi everyone,
I have a wierd report to build and very little time to do it. Here's the situation:
The data for the report is drawn from two tables: Checks and CheckLines. Checks table has Checknumber, CheckDate and CheckAmount. Check lines has Checknumber, Linenumber, OrderNumber, OrderDate and OrderAmount. The sum of OrderAmount in the CheckLines table is equal to the Check amount in the checks table.
Here's the kicker: Each page on the report has three equal sections. The check needs to print on the bottom-most section. The top and the middle portion need to be identical and need to print the check lines. The question is: How can I make the same check lines print twice on the same page. An example of this is:

-------------------------------------------------------
Section 1:
Line1 OrderNum1 OrderDate1
Line2 OrderNum2 OrderDate2
Line3 OrderNum3 OrderDate3


--------------------------------------------------------
Section 2:
Line1 OrderNum1 OrderDate1
Line2 OrderNum2 OrderDate2
Line3 OrderNum3 OrderDate3


---------------------------------------------------------
Section 3:
Printed Check with Check number and amount




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

Once again, Section 1 and 2 need to print the same thing and both need to print on the same page.
Please help!!!!

Thanks,
Nick

 

[dhookom]

I think you can use subreports for section1 and section2.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[nickspace]

Thanks for the suggestion Duane. There is only one catch (I apologize for leaving this out): both sections can only be 3.5 inches high (because it is printed on perforated paper) and if there are more line-items than what can be covered by this height, the line items should carry over the next page on the same section. Do you know if this is do-able using sub-reports? Is there a custom 3rd party report package that can help me do this?

Once again, thanks for your reply.

 

[dhookom]

I am not sure if the records will carry over. Why don't you just create the subreports as 3.5" high and see what happens.

I am not aware of another reporting application that is even close to the functionality of Access reports. There is a ton of functionality using automation with other Office applications and/or code in Access.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[nickspace]

Hi Duane,
Thnx for your suggestion. I used the subreports, have marked the section properties (Can grow = false, repeat section = true) and the sub-report properties are set to can grow = true. However, the subreport is getting cut off. If there are more than 12 line items, they dont show. Any ideas?

Thnx in advance.

 

[dhookom]

You could add a column in your subreport's record source that would return a 1 for the first 12 records and a 2 for the next 12 records. Use this value to somehow create a subreport linked to the 1s and another linked to the 2s. This could be the same subreport (different subreport control).

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[nickspace]

Hmmm... not sure if this will work, sometimes there can be more than 50 line items... I guess I'll have to see if I can get the specs changed. Do you know of any company or site where I can find programers who might be interested in building such a custom report?