Printing Forms with multiple tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a form to enter survey data, it is nine pages long. When I try
to print the form, it only prints the first page of each record. How can I
print out all nine pages for each record as it is completed?
 
I've created a form to enter survey data, it is nine pages long. When I try
to print the form, it only prints the first page of each record. How can I
print out all nine pages for each record as it is completed?
Click to expand...

Forms are for data entry and onscreen viewing. Reports are for
printing.

Create a Report to print your data, and put a command button on the
form to open the report.

You can use the report's Sorting and Grouping if you base the report
on a Query joining your tables.

If you have made the very common mistake in designing surveys of using
one field per question - a "wide-flat" table design - consider instead
using a normalized structure, such as Duane Hookum's excellent "At
Your Survey" database:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'


John W. Vinson[MVP]
 
Thanks John,

Appreciate your pointing me towards reports vs. forms. I have since created
a report and the command button to open the report. However, I am still at
the source of my initial question. I would like to print out the results of
my form.

At this point I'll substitute 'report' for 'form' and the initial question
remains essentially the same. For each new record, I enter data on nine
different tabs. When the report is generated, it is currently only for the
tab highlighted, and that particular tab for every record (there are
presently 8 records, when I print out tab#1, the tab#1 for all 8 records
print.

How can I enable Access to print tabs 1 through 9 for the record currently
selected?

Bill
 
Thanks John,

Appreciate your pointing me towards reports vs. forms. I have since created
a report and the command button to open the report. However, I am still at
the source of my initial question. I would like to print out the results of
my form.

At this point I'll substitute 'report' for 'form' and the initial question
remains essentially the same. For each new record, I enter data on nine
different tabs. When the report is generated, it is currently only for the
tab highlighted, and that particular tab for every record (there are
presently 8 records, when I print out tab#1, the tab#1 for all 8 records
print.

How can I enable Access to print tabs 1 through 9 for the record currently
selected?
Click to expand...

Base the Report on a query which selects the nine records - or nine
sets of fields, I have no idea how your table is structured - from the
Table (or tables). The Query can reference the name of the control on
the Form bound to the primary key field as a criterion - e.g.

=[Forms]![YourFormName]![SomeControlName]

Again: bear in mind that the data resides IN THE TABLES and only in
the tables. It's not "printing out tab#1" because there is nothing IN
tab#1; there is nothing in the Form. The record is stored in your
Table, using the Form and its tab control as a way to get it into the
table! You may need to explicitly save the record to disk in the
print-report command button code, using a line

DoCmd.RunCommand acCmdSaveRecord

before the OpenReport line.

John W. Vinson[MVP]
 
Back
Top