many form pages to 1 report <--problem

[noe1818 via AccessMonster.com]

I was asked if I could take an agency's forms and put it on a database. Now
the agency has about 11 pages of forms, and they want to be able to print
them all off the database. I can't (that I know of) think of a way to print
11 pages on one report for a single client entry. They do not want summaries,
they want each record printed. I tried printing forms, but the tab control
makes items blend together. Any idea how I can print forms or get 11 pages of
forms onto 1 report?

Thanks

 

[Douglas J. Steele]

Well, forms definitely aren't intended to be printed, so a report is the
probable solution.

Without knowing what problems you're encountering using reports to do this,
it's pretty hard to offer concrete suggestions.

 

[Tom Lake]

I was asked if I could take an agency's forms and put it on a database. Now
the agency has about 11 pages of forms, and they want to be able to print
them all off the database. I can't (that I know of) think of a way to print
11 pages on one report for a single client entry. They do not want summaries,
they want each record printed. I tried printing forms, but the tab control
makes items blend together. Any idea how I can print forms or get 11 pages of
forms onto 1 report?

How about a eleven separate reports that are printed using a Macro?
The user would only have to click one button and all the reports would print.

Tom Lake

 

[Douglas J. Steele]

How about a eleven separate reports that are printed using a Macro?
The user would only have to click one button and all the reports would
print.

You could also have the eleven separate reports as subreports on a twelfth
report, so that only one print statement would have to be issued.

 

[noe1818 via AccessMonster.com]

[quoted text clipped - 12 lines]

The user would only have to click one button and all the reports would
print.

You could also have the eleven separate reports as subreports on a twelfth
report, so that only one print statement would have to be issued.

I like that idea...my reports would be about a page in length each, so I
don't know how I could fit them all on one report with a max length, while
using subreports. I am trying to use a series of macro OpenReports but I
can't get the where condition to work, because I need the report to only open
one record (the current one). The condition is based on 3 criteria: id,
assessment #, and date. I posted this question a couple of minutes of ago,
but feel free to answer it here.
Here is what I have so far... can you help with any mistakes?

"[id]=""" & [Forms]![print test main]![id] & """ And [ass#]=" & [Forms]!
[print test main]![ass#] & " And [Date]=" & [Forms]![print test main](Format(
[Date],"\#mm/dd/yyyy\#"))

-Noe

 

[Douglas J. Steele]

I was asked if I could take an agency's forms and put it on a database.
Now

[quoted text clipped - 12 lines]

The user would only have to click one button and all the reports would
print.

You could also have the eleven separate reports as subreports on a twelfth
report, so that only one print statement would have to be issued.

I like that idea...my reports would be about a page in length each, so I
don't know how I could fit them all on one report with a max length, while
using subreports. I am trying to use a series of macro OpenReports but I
can't get the where condition to work, because I need the report to only
open
one record (the current one). The condition is based on 3 criteria: id,
assessment #, and date. I posted this question a couple of minutes of ago,
but feel free to answer it here.
Here is what I have so far... can you help with any mistakes?

"[id]=""" & [Forms]![print test main]![id] & """ And [ass#]=" & [Forms]!
[print test main]![ass#] & " And [Date]=" & [Forms]![print test
main](Format(
[Date],"\#mm/dd/yyyy\#"))

What you've got assumes id is a text field and ass# is a numeric one. Is
that correct? Your Format function is incorrect. It needs to be

Format([Forms]![print test main]![Date],"\#mm/dd/yyyy\#")

However, you really rename the field (and control on the form) from Date:
that's a reserved word, and you should never use reserved words for your own
purposes. (At least you're putting square brackets around it). For a
comprehensive list of names to avoid, see what Allen Browne has at
http://www.allenbrowne.com/AppIssueBadWord.html