Solved

Can you print a tab page on a form in access

Posted on 2010-09-03
8
638 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
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.
0
 
LVL 30

Assisted Solution

by:hnasr
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.
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) 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

0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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.
0
 

Author Closing Comment

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

Much appreciated!!

Thanks
patentinv
0
 

Author Comment

by:patentinv
ID: 33604847
Thanks Experts!!
0
 
LVL 30

Expert Comment

by:hnasr
ID: 33605040
Welcome!
0
 
LVL 16

Expert Comment

by:Sheils
ID: 33605331
cheers
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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