?
Solved

Access 2010 Print command on report

Posted on 2013-06-12
2
Medium Priority
?
614 Views
Last Modified: 2013-06-13
I have an application in 2010 and I have around 10 users and hide all the ribbons.  I would like to have a command button in the header of a report that will open the print dialog button.  

I tried "DoCmd.RunCommand acCmdPrint"  and it opens the dialog but if I select print, the box closes but nothing prints.  If I right click and say print, the dialog comes up and everything works fine.

I want to do this as opposed to a custom ribbon as my understanding is I would then have to add the custom ribbon to each machine.  My thought was that my idea would be much easier to do.

Any thoughts on if there is a better way to do this are appreciated as well.
0
Comment
Question by:vmccune
[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
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39241727
0
 
LVL 21
ID: 39242285
I want to do this as opposed to a custom ribbon as my understanding is I would then have to add the custom ribbon to each machine.
You're in luck because you can storing Ribbon Extensibility XML in a Table!

See: MSDN How to: Apply a Custom Ribbon When Starting Access

FWIW:
Many years ago I also used to hide the menu bars. One day I decided to tu a custom menu bar. My users loved it.  I have used a custom menus for many years now. I even make custom right-click /shortcut menus.  While it is harder for me as a developer, it is better for the users. So I keep doing it. The same is true with the Ribbon. I believe they user should come first over what is easier for the developer. The Developer does it once. The Users will use it over and over. For me that makes learning to program the Ribbon a "no brainer". My 2 cents.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

770 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