Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 645
  • Last Modified:

Can you print a tab page on a form in access

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
patentinv
Asked:
patentinv
  • 2
  • 2
  • 2
  • +2
4 Solutions
 
SheilsCommented:
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
 
hnasrCommented:
You can print a tab page in a report.
Copy the page from the form and paste in the report.
0
 
Dale FyeCommented:
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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
Helen FeddemaCommented:
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
 
patentinvAuthor Commented:
Makes sense!! I'll copy and paste it.

Much appreciated!!

Thanks
patentinv
0
 
patentinvAuthor Commented:
Thanks Experts!!
0
 
hnasrCommented:
Welcome!
0
 
SheilsCommented:
cheers
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now