Is there a simple way to assign a keyboard shortcut to a macro in Access 2007? I understand that macros behave differently in Access than they do in Excel (which I'm more familiar with). I have written a sub called "ImportAll" in Module1. I'd like it to run when I push Ctrl+I. How would I go about achieving this?
posted by Proginoskes on May 10, 2013 - 4 answers

I have read that John Walkenbach's books are the de-facto standard for learning to use VBA in Microsoft Excel. I'd like to know what books are recommended to learn to use vba in other Office products - primarily Access, but also Word and Powerpoint. I'm more interested in books than in websites.
posted by Proginoskes on Apr 6, 2013 - 3 answers

Best way to implement a two-part unique identifier in Access? [more inside]
posted by jsturgill on May 9, 2011 - 14 answers

Access 2007: Need code to grab the value _displayed_ in a combo box (as opposed to its actual value). Big, detailed explanation inside. [more inside]
posted by Ys on Feb 20, 2010 - 5 answers

Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

I am developing an access app for a UMPC, and because of the lack of a keyboard, I want to make a keypad number entry popup. [more inside]
posted by JonnyRotten on Oct 31, 2006 - 5 answers