Access Form with multiple pages

[Pat B]

I've designed a form that has three control tabs for pages 1, 2 and 3. The
main info for the individual is on the first page (tab 1), and pages 2 and 3
contain text boxes for other information. So each individual will have three
pages of data filling a letterhead page. When I try to print pages 1-3 on
just one person, it gives me three-first pages of different individuals
instead of pages 1, 2 and 3 on the one individual. It is pulling in the
correct info from the underlying table, but I can't figure out how to get
data on just one person. Is it necessary to have a master page that isn't
assigned a tab, and the subsequent pages are tabbed?

 

[Gina Whipp]

Pat,

Actually it's doing exactly what you asked it to do just not the way you
want it to do it. It will only print the current form and all associated
records not three form from three different tab pages. To get what you want
use a report with subreports. You can base your report off of the below
mentioned query.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Pat B]

Gina, I'm having a problem finding the query you reference in your reply.
Can you clarify for me?

 

[Gina Whipp]

Pat,

I was refering to the query you mentioned in your original post... but I
just noticed you said table not query.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Pat B]

I've added two subforms to the main form, but don't want them to appear on
the first page when it is printed out or opened up, unless there's a way of
just showing it as a button. I want the subreports to each open on separate
pages for data entry and then have te three pages print out separately. Any
way to do this?

 

[Gina Whipp]

Pat,

You are switching between subreports and subforms which one are you trying
to print? Also, you say "...data entry..." but that would be on a subform
not a subreport. You can't enter data on a report which leads me to believe
you are still trying to print the forms and have not created a report.

To answer your question... to have subreports print up on seperate pages use
the page break control. Place it between the subreports to seperate them on
to seperate pages.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

I've added two subforms to the main form, but don't want them to appear on
the first page when it is printed out or opened up, unless there's a way of
just showing it as a button. I want the subreports to each open on separate
pages for data entry and then have te three pages print out separately. Any
way to do this?

I think you're mixing up two different things. Forms are used for entering and
editing data. Reports are used for printing. A Form is not a Report, and a
Report is not a Form!

It's possible to print forms but doing so has many disadvantages and lacks a
lot of the flexibility and control of a Report.

Store your data in Tables; edit your data with Forms; print your data with
Reports - it'll be a lot simpler.

 

[Pat B]

This is the first time I've tried to do a three page form and just want the
simplest way to do it. If I can combine my three forms into one continuous
form, and then build a report based on that--it could work. However, when
scrolling down on the form it won't let me go past 22" and the properties
won't allow me to change it. The first page of my form has data fields from
a table, along with text boxes to fill in, and pages 2 and 3 are just text
boxes. Therefore if I can make one long continuous form (instead of one with
two subforms), then break it into pages in the report, that could work. I'm
building this for a group of employees to be able to open the form and just
fill it in--as simple as possible. I don't want them to have to navigate
anywhere. Just save, and print report. Any other suggestions on a really
easy way to do this??

 

[Gina Whipp]

Pat,

The limit to forms and reports is 22" in length, nothing you or I do will
change that. As you want to break this "report" into several pages using
the subreports will accomplish this.

You say you want to make it simple for everyone to use by using the form
but I'm not sure I get what you are doing. Your users won't have to
navigate anywhere to print the report, just put a button on the form. They
can open the form, fill it in and then press the print/preview button that
you have placed on the form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Pat B]

When I say I want to make it simple to use, I want the ability to open the
form in its entirety, and have users tab from field to field to fill in the
data till they reach the end (by which I mean combining three forms into
one). The subforms would be too confusing for the users that don't use
access or any other kind of forms software--I was trying to make it as
similar to a WORD document that I could, just for entering the data. The
printed report I can then design to print on separate pages--it's the form
that I'm trying to simplify.

 

[Gina Whipp]

Pat,

Okay, now I see but still nothing to do about the length of a form. Are you
shure your Users won't understand pressing a tab on a tab control? If so, I
see no way around putting everything on one form unless you put the fields
RALLY close together but then it might be confusing for them to enter data.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

When I say I want to make it simple to use, I want the ability to open the
form in its entirety, and have users tab from field to field to fill in
the
data till they reach the end (by which I mean combining three forms into
one). The subforms would be too confusing for the users that don't use
access or any other kind of forms software--I was trying to make it as
similar to a WORD document that I could, just for entering the data. The
printed report I can then design to print on separate pages--it's the form
that I'm trying to simplify.

 

[Pat B]

So if I'm limited to 22 " even in a report design, there will be no way to
get a three page report to print out evenly spaced to the end of the 3rd
page. I think I will have to wind up doing this form in WORD! Do you know
of any other site that might have a demo on tab controls and/or subforms? I
haven't used them in the past as I usually am able to use access with queries
and reports with no problems, and this is the first time I've been attempting
a three page report with so many memo fields that vary in size depending on
the information entered. Thanks for your help!

 

[Gina Whipp]

Pat,

Hence the use of subreports... which can be placed on the page and set Can
Grow = Yes; with page breaks in between the subreports they will print on
seperate pages (See below). You might be trying to open the entire
subreport which is not neccessary. I have reports with as many as 5
subreports on them however, the subreports are not 'fully' extended. I am
going to hope this can be accomplished the way you are doing it, as I have
never tried to print forms I cannot say for certain.

Main Report
Subreport - 1/2" in height set Can Grow = Yes
Subreport - 1/2" in height set Can Grow = Yes

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm