Enabling right-click in Access Runtime? (1 Viewer)

NewShoes · Mar 14, 2010

Hi all,

As per title really. I have a database that takes a while to open on some peoples computers. I had the idea of opening it in Access Runtime to see if it speeds things up. I just tried and it is a lot quicker however, rightclick is disabled.

The key things I require are...

1) Being able to right click and copy/paste in fields (on forms). I know you can use ctrl c and v but some users will not know this.

2) Is there a way to set a button on a report to go straight to print preview? And similarly, a button that will let me export to PDF?

I'm using Access 2007.

Any help would be great!

-NS

vbaInet · Mar 14, 2010

It's best to ask one thing first and move on to the next

NewShoes said:
1) Being able to right click and copy/paste in fields (on forms). I know you can use ctrl c and v but some users will not know this.

On the ribbon there is a copy and paste button on the CLIPBOARD tab.

NewShoes said:
2) Is there a way to set a button on a report to go straight to print preview?

Investigate this approach, here's the code:

Code:

Docmd.openreport "Name_Of_Report", acViewPreview

NewShoes said:
... And similarly, a button that will let me export to PDF?

Here's how:

Code:

DoCmd.OutputTo acOutputReport, "Name_Of_Report", acFormatPDF, "Full_Path_To_File"

To learn more about this search the help files (hit the F1 key) for the term "OutputTo"

NewShoes · Mar 14, 2010

vbaInet said:
On the ribbon there is a copy and paste button on the CLIPBOARD tab.

Thanks for your reply vbaInet! I'm not sure I'm looking in the right place but there are no ribbons/tabs in Access Runtime?

Thanks,
-NS

vbaInet · Mar 14, 2010

Hmm... it may be hidden. Right-click at the top and untick the Minimize the Ribbon menu.

Have a look at the attached image.

NewShoes · Mar 14, 2010

vbaInet said:
Hmm... it may be hidden. Right-click at the top and untick the Minimize the Ribbon menu.

Have a look at the attached image.

Very strange, I right clicked as suggested and I could see the menu but it was greyed out, I cant select anything.

-NS

vbaInet · Mar 14, 2010

In the accdb version of your database, what are the Access Options set as. (Access Options under the Office button, then click CURRENT DATABSE).

In particular the options in the attached image.

NewShoes · Mar 14, 2010

Just checked and it's the same as your screenshot.

vbaInet · Mar 14, 2010

I'm not entirely sure but I think with the runtime version of Access 2007 you must create a ribbon and include it in your db. From that screenshot you set the default ribbon to the ribbon you created. Since you're using the built-in buttons all you do is include the right mso's in the ribbon xml file. Here are some good links on how to create the ribbon:

http://msdn.microsoft.com/en-us/library/aa338202.aspx
http://www.accessribbon.de/en/index.php?Welcome

If you're having difficulty just post back.

NewShoes · Mar 14, 2010

Many thanks, i will try this tomorrow.

vbaInet · Mar 14, 2010

You're welcome.

Enabling right-click in Access Runtime? (1 Viewer)

NewShoes

Registered User.

vbaInet

AWF VIP

NewShoes

Registered User.

vbaInet

AWF VIP

Attachments

NewShoes

Registered User.

vbaInet

AWF VIP

Attachments

NewShoes

Registered User.

vbaInet

AWF VIP

NewShoes

Registered User.

vbaInet

AWF VIP

Similar threads

Users who are viewing this thread