Favorite Access Keyboard Shortcuts


	Back to Captain's Log Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Favorite Access Keyboard Shortcuts

Richard Rost

4 months ago

In Access, you don't have to type today's date or the current time. Press Ctrl - ; to instantly insert today's date, and Ctrl - Shift - ; to insert the current time. This works in tables, queries, and even subdatasheets. It's one of those tiny keyboard shortcuts that feels trivial until you start using it fifty times a day, then you wonder how you ever lived without it.

Another handy Datasheet shortcut: press Ctrl - ' (apostrophe) to copy the value from the same field in the record directly above the current one. It's perfect when you're entering a bunch of similar records and don't feel like retyping the same customer, date, or category over and over again. Tiny shortcut, big quality-of-life improvement.

What's one of your favorite keyboard shortcuts?

LLAP
RR

	Richard Rost OP @Reply 4 months ago

	Kevin Robertson @Reply 4 months ago
I use these all the time. Great time saver.

	Donald Blackwell @Reply 4 months ago
Ctrl - , (comma) and Ctrl - . (period) come in handy too when switching views (when I remember them) and Ctrl - + (plus) is handy especially if you're at the top of a long continuous form to go to a new record, especially if navigation buttons at the bottom are turned off.

	Matt Hall @Reply 4 months ago
Many of our databases are glorified spreadsheets, aka "not normalized". I bought one of these to combine the shortcuts with field navigation. I can echo & move right or paste & move down out of a single key stroke.

	Richard Rost OP @Reply 4 months ago
Matt Nice! I love my Stream Deck. I've got all kinds of customized buttons for things like turning my voice rec on/off, start/stop recording, etc. Beats having to remember all these keyboard shortcuts! LOL

	Matt Hall @Reply 4 months ago
I would love a stream deck. To date, I have been too cheap to get one. I keep eyeballing them though so... :)

	Richard Rost OP @Reply 4 months ago
Matt You know, Alex tried for years to talk me into getting one and I finally did. Can't live without it now.

	Alex Hedley @Reply 4 months ago
Have you seen https://www.corsair.com/uk/en/p/keyboards/ch-912a31i-uk/galleon-100-sd-stream-deck-integrated-mechanical-keyboard-uk-ch-912a31i-uk

	Joe Holland @Reply 4 months ago
F11 to display navigation pane and Alt+F11 to open vba window

	Michael Olgren @Reply 4 months ago
Shift-F2 to open the zoom window and F4 to toggle properties dialog.

	Sam Domino @Reply 4 months ago
Sounds like this should be its own section on the ALZ desk mat!

	Richard Rost OP @Reply 4 months ago
Alex that is glorious, but I use a laptop. :( Plus I've always liked separate devices - that way, if one breaks, you don't have to replace the whole giant thing. It's kinda like remember those TV VCR combos back in the day? Well, if the VCR stopped working, now you just got an expensive TV.

	Alex Hedley @Reply 4 months ago
You can plug a keyboard into a laptop :p Just get a https://www.elgato.com/uk/en/p/stream-deck-plus

	Richard Rost OP @Reply 4 months ago
Yeah, you can plug a keyboard into the laptop, but then you got to push the laptop back further on your desk, and you can't use the little laptop screen.

	A Glenn Yesner @Reply 4 months ago
F7 for spell check.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Captain's Log.

Next Unseen

New Feature: Comment Live View