Solved

Access 2010 Print command on report

Posted on 2013-06-12
2
568 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 500 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

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…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

697 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