Solved

Add a shortcut key to the quick access toolbar in Access 2010

Posted on 2013-02-06
2
496 Views
Last Modified: 2013-02-07
I'd like to add a shortcut on the quick access toolbar to the key combination CTRL-ENTER. I can make a macro that uses SENDKEYS to sent CTRL-ENTER and then add that macro to the quick access toolbar. The problem with that is that it only works for the current database. As soon as I start a new database, I have to copy the macro into it.

Is there a way to have a macro automatically added to any new database? Or is there a better approach?
0
Comment
Question by:jrmcanada2
[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 26

Expert Comment

by:jerryb30
ID: 38862506
One approach is to create an otherwise empty database with the features you want, not related to tables, queries, etc. Including any macros, modules.
Then, instead of creating a new database each time, you simply copy and rename a master database.
Analogous to editing the SQL Server Master database.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 200 total points
ID: 38863322
You can modify the "blank" template, which is the default one used when creating new, blank databases:

http://office.microsoft.com/en-us/access-help/create-a-new-database-HA010037837.aspx#BMblanktemplate

That article is for 2007 but would apply to 2010 as well.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

730 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