Printing Help!

[Guest]

I'm writing an application for a city that will be used for Animal License
issuing and tracking. I have a form that has the animal information on it and
a subform that is ussed to enter license and release records for the
animal...there can be multiple occurences of these. A command button on the
subform will print the actual license. On the license it is possible to have
both a license fee and a release fee and that's where my problem arises.
Everything works fine, except whatever record is the current record on the
subform is what prints on the license. If the current record is license fee
that's what prints; if the current record is release fee, that's what prints.
If there is a license fee and a release fee, I can't get them both to print.
I tried to base the license report on a query, but I'm not sure how to set it
up because of the variances that could occur. There could be a license fee
for several years and more than one release fee. I'm not sure how to
differentiate between the current ones that I need to print on the license
and the ones I don't need. Is it going to be possible to somehow print the
license fee and the release fee at the same time from the subform? If anyone
has any suggestions, I'm all ears and full of gratitude.
Thanks,
RandyM

 

[Guest]

My understanding is that you have multiple records for each animal and they
can be either license or release. Each record in subform is one of these. If
your main form shows data for one particular animal and subform shows licence
and release records, you may want to control the printiing from the main
form. Create a button cmdPrintAll. The button would open a recordset (same
records as on the subform) and loop thru the recordset. for each record in
the recordset, a document would be printed.

If you do not want to print all the documents, consider a list box of
related documents instead of subform. From list box, you can multi-select
just the documents you want to print. Then you loop thru the selected items
on the list and print appropriate reports. Access Help provides nice example
of working with multi-select list boxes.

 

[Guest]

Thanks Dejan, I'll look into both your suggestions. I'm relatively new to
using Access having come from a Cobol Programming environment and I think
sometimes I tend to overthink things in Access, at least that's what an
Access expert said. I'm coming to realize Access will do a great deal for you
so that you don't have to use VBA coding. I'm getting there, but it's slowly.
Thanks again for your suggestions.

RandyM