A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to print mainform and subform together?



 
 
Thread Tools Display Modes
  #1  
Old August 29th, 2008, 04:37 AM posted to microsoft.public.access.forms
jck
external usenet poster
 
Posts: 5
Default How to print mainform and subform together?

I designed a form with a main form on top and a subform at the bottom. The
main form is automatically populated by data from a query whereas the subform
is linked to a blank table for data entry. When I printed the form, only the
main form showed up in the printout. The subform didn't. I tried various
property options but nothing worked. Could someone tell me what was wrong?

I read some answers here that said we're not supposed to print from forms.
But I have been printing out forms for ages. Although I haven't worked with a
mainform/subform situation. I'm designing this form for multiple users and I
want to keep the steps as simple as possible. I want the users to be able to
print out a hard copy after filling out the form. Also, is there a way to
insert page break so one record will print on one page?

I'm not a programer so I don't know code designs. I'm using Access 2003.
I'll really appreciate it if someone can help me with these.

JCK
  #2  
Old August 29th, 2008, 06:58 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default How to print mainform and subform together?

On Thu, 28 Aug 2008 20:37:00 -0700, jck wrote:

I designed a form with a main form on top and a subform at the bottom. The
main form is automatically populated by data from a query whereas the subform
is linked to a blank table for data entry. When I printed the form, only the
main form showed up in the printout. The subform didn't. I tried various
property options but nothing worked. Could someone tell me what was wrong?

I read some answers here that said we're not supposed to print from forms.
But I have been printing out forms for ages. Although I haven't worked with a
mainform/subform situation. I'm designing this form for multiple users and I
want to keep the steps as simple as possible. I want the users to be able to
print out a hard copy after filling out the form. Also, is there a way to
insert page break so one record will print on one page?

I'm not a programer so I don't know code designs. I'm using Access 2003.
I'll really appreciate it if someone can help me with these.

JCK


Forms are designed for onscreen use; Reports are designed for printing.
Neither does the other's job at all well.

You can open a Form in design view and choose File... Sava As and save it as a
Report. However, a Report and Subreport may not get you the ideal appearance,
especially if you have multiple child records on the subform. Instead you can
use a Report's Sorting and Grouping to display the mainform data on a section
header, and the subform data in the detail section. This will not be a
challenge for the user since - with a bit of help from the form wizard - you
can put a command button on the form to print the form's data on the saved
report.
--

John W. Vinson [MVP]
  #3  
Old August 29th, 2008, 11:45 AM posted to microsoft.public.access.forms
Rick Brandt
external usenet poster
 
Posts: 4,354
Default How to print mainform and subform together?

John W. Vinson wrote:
Forms are designed for onscreen use; Reports are designed for
printing. Neither does the other's job at all well.

You can open a Form in design view and choose File... Sava As and
save it as a Report. However, a Report and Subreport...[snip]


Just wanted to point out that when you have a form with a subform and "Save
as" a report. You end up with ONE new report based on the main form and
that main report will have within it a reference to your original subfFORM,
not to a new subreport. You have to separately "Save As" a report all of
the subforms, and then you have to change the main report to reference those
instead of the subforms.

I got burned by that long ago when I opened the report in design view and
started making changes to what I thought was a new subreport only to
discover I was actually messing with my subform object.

John is absolutely correct that most cases of data edited via form/subform
do not need to be printed with report/subreport, but rather with grouping
levels in a single report.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


  #4  
Old August 29th, 2008, 10:23 PM posted to microsoft.public.access.forms
jck
external usenet poster
 
Posts: 5
Default How to print mainform and subform together?

Thanks for your help! I tried the Save as in the form yesterday and only
mainform was printed in report. I'm not quite sure how to work with the
Sorting and Grouping function in report as John suggested. I'll see whether I
can figure it out and report back.

Thanks very much for the answers! This is the first time I asked a question
here and I love the support!

JCK

"Rick Brandt" wrote:

John W. Vinson wrote:
Forms are designed for onscreen use; Reports are designed for
printing. Neither does the other's job at all well.

You can open a Form in design view and choose File... Sava As and
save it as a Report. However, a Report and Subreport...[snip]


Just wanted to point out that when you have a form with a subform and "Save
as" a report. You end up with ONE new report based on the main form and
that main report will have within it a reference to your original subfFORM,
not to a new subreport. You have to separately "Save As" a report all of
the subforms, and then you have to change the main report to reference those
instead of the subforms.

I got burned by that long ago when I opened the report in design view and
started making changes to what I thought was a new subreport only to
discover I was actually messing with my subform object.

John is absolutely correct that most cases of data edited via form/subform
do not need to be printed with report/subreport, but rather with grouping
levels in a single report.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



  #5  
Old August 30th, 2008, 01:26 AM posted to microsoft.public.access.forms
jck
external usenet poster
 
Posts: 5
Default How to print mainform and subform together?

Okay, I tried the Save as in the form. The report still comes out with only
main form showing. I tried to put the subform into detail section and it
didn't work because the report still linked to the query that populated the
main form, not the subform. I tried to use Save as for the separate subform
and I couldn't. Access wouldn't let me to save it as a report. I also tried
the Sorting and Grouping function. It only shows fields from the main form so
I wasn't sure how I could use it to pull those fields from the subform in.
What did I miss?

I'm using Access 2003. I'm not sure whether that makes a difference.

I'm back to where I was: I can print the mainform without any problem in
either Form or Report but not the subform. Any tips will be appreciated.

JCK

"John W. Vinson" wrote:

On Thu, 28 Aug 2008 20:37:00 -0700, jck wrote:

I designed a form with a main form on top and a subform at the bottom. The
main form is automatically populated by data from a query whereas the subform
is linked to a blank table for data entry. When I printed the form, only the
main form showed up in the printout. The subform didn't. I tried various
property options but nothing worked. Could someone tell me what was wrong?

I read some answers here that said we're not supposed to print from forms.
But I have been printing out forms for ages. Although I haven't worked with a
mainform/subform situation. I'm designing this form for multiple users and I
want to keep the steps as simple as possible. I want the users to be able to
print out a hard copy after filling out the form. Also, is there a way to
insert page break so one record will print on one page?

I'm not a programer so I don't know code designs. I'm using Access 2003.
I'll really appreciate it if someone can help me with these.

JCK


Forms are designed for onscreen use; Reports are designed for printing.
Neither does the other's job at all well.

You can open a Form in design view and choose File... Sava As and save it as a
Report. However, a Report and Subreport may not get you the ideal appearance,
especially if you have multiple child records on the subform. Instead you can
use a Report's Sorting and Grouping to display the mainform data on a section
header, and the subform data in the detail section. This will not be a
challenge for the user since - with a bit of help from the form wizard - you
can put a command button on the form to print the form's data on the saved
report.
--

John W. Vinson [MVP]

  #6  
Old August 30th, 2008, 01:40 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default How to print mainform and subform together?

On Fri, 29 Aug 2008 17:26:54 -0700, jck wrote:

Okay, I tried the Save as in the form. The report still comes out with only
main form showing. I tried to put the subform into detail section and it
didn't work because the report still linked to the query that populated the
main form, not the subform. I tried to use Save as for the separate subform
and I couldn't. Access wouldn't let me to save it as a report. I also tried
the Sorting and Grouping function. It only shows fields from the main form so
I wasn't sure how I could use it to pull those fields from the subform in.
What did I miss?


Create a Query joining the *tables* (not the forms) upon which the main and
subform are based. Use this query as the basis of the report. Use a criterion
like

=Forms!yourmainform!controlname

to display just the results related to the form's primary key.

Use the Report's sorting and grouping feature to group by the primary key of
the parent table; make the header and/or footer visible. Put the mainform
fields in the header, and the subform fields in the detail section.

Launch this report from the form; put a line

DoCmd.RunCommand acCmdSaveRecord

prior to launching the report in order to save the current form's data to
disk.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.