Solved

Can you print a tab page on a form in access

Posted on 2010-09-03
8
636 Views
Last Modified: 2013-11-28
Hi Experts,

Is it possible to print a single tab page on a form in access?
I tried saving the one tab page as a report but it appears it wants to use the whole form, not just one tab page.

Thanks
patentinv
0
Comment
Question by:patentinv
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 16

Accepted Solution

by:
Sheils earned 250 total points
Comment Utility
Just create a report with the parameter that you want to display. The you can open it and filter by the record on your form.
0
 
LVL 30

Assisted Solution

by:hnasr
hnasr earned 75 total points
Comment Utility
You can print a tab page in a report.
Copy the page from the form and paste in the report.
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 100 total points
Comment Utility
I'm with sb9 on this one.  Just create the report from scratch.  Then open your form, selec the tab control, copy it, and paste it into the report (delete any of the tab pages you don't need from the report).  Then copy the RecordSource from the Form and Paste it into the RecordSource of the report.

Then use the OpenReport method with a where clause to only open the report for the record that is currently displayed on your form.  To do this, add a command button to your form, name it cmdPrint.  Then create a Click event that looks like the following.  Make sure to change "reportName" for the name you use when you save your new report.  Also, the WHERE condition I've used is generic.  You will need to change [ID] to whatever you use as the unique field in your table, and me.txt_ID to whatever you have named the control on your form that is bound to that unique field.

Private Sub cmdPrint_Click

    docmd.OpenReport "reportName", acViewPreview, , "[ID] = " & me.txt_ID

End Sub

0
 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 75 total points
Comment Utility
I agree with sb9 and fyed.  It is rarely advisable to print a form.  Just create a report filtered the same as the tab, and print the report.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Closing Comment

by:patentinv
Comment Utility
Makes sense!! I'll copy and paste it.

Much appreciated!!

Thanks
patentinv
0
 

Author Comment

by:patentinv
Comment Utility
Thanks Experts!!
0
 
LVL 30

Expert Comment

by:hnasr
Comment Utility
Welcome!
0
 
LVL 16

Expert Comment

by:Sheils
Comment Utility
cheers
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now