Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.
Course Of The Month
7 days, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Screenprint a form in Access using VBA
Posted on 2013-01-03
Hey Everyone,
This does not seem like a big deal but for some reason I cannot figure it out. I have a very busy screen (lots of fields and data) and I want to have a button that will do a printscreen. Right now I have the user do an ALt+PrintScreen, paste the result into Paint, and then print from there.
Is there an easier way to do it via VBA? I have tried this code:
DoCmd.SelectObject acForm, Screen.ActiveForm.Name, False
DoCmd.PrintOut
and it crashes Access. I have attached a jpg of the screen
screen.jpg
This does not seem like a big deal but for some reason I cannot figure it out. I have a very busy screen (lots of fields and data) and I want to have a button that will do a printscreen. Right now I have the user do an ALt+PrintScreen, paste the result into Paint, and then print from there.
Is there an easier way to do it via VBA? I have tried this code:
DoCmd.SelectObject acForm, Screen.ActiveForm.Name, False
DoCmd.PrintOut
and it crashes Access. I have attached a jpg of the screen
screen.jpg
[X]
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
-
4
3
2- +1
11 Comments
Active today
This MSFT article explains how to do it:
http://support.microsoft.com/?kbid=240653
that's for Visual Basic, but it should work for VBA also.
http://support.microsoft.com/?kbid=240653
that's for Visual Basic, but it should work for VBA also.
Well, CTRL-P will bring up the print dialog box and you can print directly from there instead of pasting your screenshot into another program; however, I don't recommend printing straight from a form, especially one such as yours since you end up wasting a lot of ink/toner due to the printing of unnecessary items such as the background color and form buttons. It's really best to create a report from the form and use that for printing.
I tried the ctrl+p but it did what happened before, crashed access. I completely agree with you that printing the form is a waste of toner but they are very set in their ways and they want to print the entire form. Believe me I tried selling them on creating a report but they did not want to hear it.
The whole idea is to give them a report that looks like the form but without the background color and the buttons cluttering up their report. Why would they be opposed to this if you give them a button on the form that prints exactly what they see without the clutter?
You can use LSM's code to copy the screen to the clipboard...
But if your ultimate goal is to also paste the image into paint, ...then print it out (meaning all three of these steps to be done via VBA automation), ...then this is another story.
You can also do as IrogSinta suggests...
(Print the Form, or create a Report for printing)
So it seems that your ultimate goal here is unclear.
Do you actually want just a screenshot of the form (perhaps as a training tool?)
...Or do you just need a printout of the form to see the data?
JeffCoachman
But if your ultimate goal is to also paste the image into paint, ...then print it out (meaning all three of these steps to be done via VBA automation), ...then this is another story.
You can also do as IrogSinta suggests...
(Print the Form, or create a Report for printing)
So it seems that your ultimate goal here is unclear.
Do you actually want just a screenshot of the form (perhaps as a training tool?)
...Or do you just need a printout of the form to see the data?
JeffCoachman
I wish I knew. Maybe they cannot picture it. I may have to go forward and create it and show it to them, but I don't feel like wasting all that time just to have them say no.
Hello JeffCoachman,
WHen they explain it to me it sounds like they just need the data (I have no clue why anyone would need to see a button etc) but when I said I would create a report that looked like the screen they freaked out and said that they cannot have it that way for their files. They need to have a printout of the screen EXACTLY as it shows on the screen with the buttons, data and everything. I am thinking I might have to use a macro recorder and record the steps for a screen print and just do that (not incorporate it into the access program)
WHen they explain it to me it sounds like they just need the data (I have no clue why anyone would need to see a button etc) but when I said I would create a report that looked like the screen they freaked out and said that they cannot have it that way for their files. They need to have a printout of the screen EXACTLY as it shows on the screen with the buttons, data and everything. I am thinking I might have to use a macro recorder and record the steps for a screen print and just do that (not incorporate it into the access program)
Show them this and see what they say about a report looking like it.
untitled3.jpg
untitled3.jpg
Active today
The code at the sample I linked does just that - it prints the screen. What would be the point of a macro recorder?
Featured Post
How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.
Flipping Coins in Excel: Enter =RAND() into cell A2:
Recalculate the random variable…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 20 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.