Can you print a tab page on a form in access

Posted on 2010-09-03
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.

Question by:patentinv
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
LVL 16

Accepted Solution

Sheils earned 250 total points
ID: 33602218
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.
LVL 30

Assisted Solution

hnasr earned 75 total points
ID: 33602778
You can print a tab page in a report.
Copy the page from the form and paste in the report.
LVL 48

Assisted Solution

by:Dale Fye
Dale Fye earned 100 total points
ID: 33603039
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

LVL 31

Assisted Solution

by:Helen Feddema
Helen Feddema earned 75 total points
ID: 33603255
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.

Author Closing Comment

ID: 33604846
Makes sense!! I'll copy and paste it.

Much appreciated!!


Author Comment

ID: 33604847
Thanks Experts!!
LVL 30

Expert Comment

ID: 33605040
LVL 16

Expert Comment

ID: 33605331

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

624 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