Art-
Sure. You can put custom commands on the QAT (Quick Access Toolbar) - it's
the little toolbar above the Ribbon next to the "Office" button in 2012 or
the "Open" button in 2010. First, create and save a macro that runs your
query. Then click the little down arrow next to the QAT and select More
Commands... That should take you to the Access Options dialog and the
Customize the Quick Access Toolbar window. In the Choose Commands From
drop-down, select Macros, then select your new custom macro in the list and
click the Add >> button to put it on the QAT. Click OK, and your macro
should appear as a button next to the default Save, Undo, and Redo buttons.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
P.S. Folks on the list - don't ask me how I manage to remember obscure stuff
like this. I have no clue!
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
Sent: Wednesday, June 19, 2013 10:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Fast Query Access
Is there a way that I can run a query from the office ribbon? Instead have
to go to the Navigation pane all the time?
Thanks,
Art Lorenzini
Sioux Falls, SD
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar