Solved

Access 2010 Print command on report

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
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.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

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