Test your Word keyboard shortcut knowledge in this week's challenge and learn the solution to last week's puzzler on documenting library references in Access.
This Queen of Keyboard Shortcuts recently suffered humiliating defeat during a keyboard showdown with a colleague. I tuned in and my hot little fingers were smoking, and then... it happened: I was stumped.
"No!" I cried in disbelief. "There's no such shortcut!"
What shortcut solution cost me my title? Name the keyboard shortcuts for increasing and decreasing the font size of the current word or selected text in a Word document. The true shame is that had I really been focused, I could have figured it out. That's your clue. Using the Font Size control on the Formatting toolbar is so quick and easy that I've never bothered to look for a keyboard shortcut, but there is one. Do you know it?
Calling all challengers: Got a little known keyboard shortcut you think will stump everyone? Post your shortcut challenge below!
Last week we asked…
How can you get a list of referenced libraries for an Access database? Libraries provide additional functionality to Office applications. Access, by default depends on the VBA and Access application library, but there are many others. For instance, a lot of developers still depend heavily on DAO (Data Access Objects), even though ADO (ActiveX Data Objects) has been the default object library for a long time.
Knowing what libraries a database references is important to the developer and something you'll probably want to document using the following function:
Public Sub ListLibraryReferences()
'Print all library references to Immediate window.
Dim ref As Access.Reference
For Each ref In Access.References
Debug.Print "Name: " & ref.Name
Set ref = Nothing
This function cycles through the Reference collection and prints the name of each reference library in the Immediate window. You can also add the following line to print the path to each file:
Debug.Print "Path: " & ref.FullPath
Thanks to ESchlangen for meeting this challenge by providing similar code.