G
Guest
Hello:
I'm writing a check printing system and is now generating the actual form
where the output will be printed on pre-printed check papers.
The check will be divided into 3 sections (from top to bottom)
1. Main Check section (has the check body, date, customer name, address, etc.)
2. Check stub 1 (lists one or more entries of references to be attached to
the main check section)
3. Check stub 2 (somewhat of a replica of stub 1, except this one we tear
off to keep for our own references).
The report itself is divided into 3 sections as well. The Header Section has
the main check form, the Detail Section list the reference entries, and there
is a Footer. The report data is pulled from an user query where the CheckID
is asked and inputed.
The references section was part of a subform that has entries like:
Invoice 1 - Detail 1 - Reference 1
Invoice 2 - Detail 2 - Reference 2
Invoice 3 - Detail 3 - Reference 3
and so on, depending on how many was originally inputed and associated with
this Check Number.
I cannot just copy the fields into the Detail section again as it will just
produce:
Invoice 1
Invoice 1
Invoice 2
Invoice 2
etc.
with too much space in between.
I can't just copy the fields into the footer section as it will only show
the last record of the transaction (e.g. Invoice 3) - would've worked ok if
there was only one transaction per Check, but that's not the case.
I've read that there were a few poster here that may have had similar
question like mine, I've attempted at some of the solutions they had, but
can't seem to get them to work (e.g. subform still only produced the last
record of the transaction).
The printing would've been no problem had there only been one stub. This is
about the only section I couldn't get working and I have been on this part
for the last 2 days.
Any help/suggestion is truly appreciated.
Thank you
I'm writing a check printing system and is now generating the actual form
where the output will be printed on pre-printed check papers.
The check will be divided into 3 sections (from top to bottom)
1. Main Check section (has the check body, date, customer name, address, etc.)
2. Check stub 1 (lists one or more entries of references to be attached to
the main check section)
3. Check stub 2 (somewhat of a replica of stub 1, except this one we tear
off to keep for our own references).
The report itself is divided into 3 sections as well. The Header Section has
the main check form, the Detail Section list the reference entries, and there
is a Footer. The report data is pulled from an user query where the CheckID
is asked and inputed.
The references section was part of a subform that has entries like:
Invoice 1 - Detail 1 - Reference 1
Invoice 2 - Detail 2 - Reference 2
Invoice 3 - Detail 3 - Reference 3
and so on, depending on how many was originally inputed and associated with
this Check Number.
I cannot just copy the fields into the Detail section again as it will just
produce:
Invoice 1
Invoice 1
Invoice 2
Invoice 2
etc.
with too much space in between.
I can't just copy the fields into the footer section as it will only show
the last record of the transaction (e.g. Invoice 3) - would've worked ok if
there was only one transaction per Check, but that's not the case.
I've read that there were a few poster here that may have had similar
question like mine, I've attempted at some of the solutions they had, but
can't seem to get them to work (e.g. subform still only produced the last
record of the transaction).
The printing would've been no problem had there only been one stub. This is
about the only section I couldn't get working and I have been on this part
for the last 2 days.
Any help/suggestion is truly appreciated.
Thank you