Possible SendKeys problem - Table of Contents in Microsoft Access


	Back to Table of Contents Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Possible SendKeys problem

John Valencic

2 years ago

I don't know if this is a problem with sendKeys, but when opening the report with the generated TOC, my NumLocks status keeps changing. When I initially open the report, everything on the report looks great, but the NumLock shows its status as off, when I close and open the report a second time the NumLock status shows on. I checked and re-checked my code and couldn't find anywhere this might happen. When I used SendKeys, I enclosed it in quotes and curly brackets "{END}". I am using Windows 10 and access 2007

	John Valencic OP @Reply 2 years ago
Forgot to mention, I followed Richard's "Table of Contents" series.

	Kevin Robertson @Reply 2 years ago
This has been a known problem with SendKeys for a while.

	Kevin Robertson @Reply 2 years ago
Sami Maybe add that to your list for the Access team.

	John Valencic OP @Reply 2 years ago
This isn't a big deal, as I can always turn the numlock back on manually. Maybe there's a way to turn numlock on when closing the Db

	Kevin Robertson @Reply 2 years ago
Determine which line of code turns off the Num Lock then turn it back on after that line executes. `SendKeys "{NUMLOCK}"` Or add it to the Close event of your Start Up form (for example: MainMenuF)

	Sami Shamma @Reply 2 years ago
@kevin Sure, give me the wording, I did not get what the bug is.

	Richard Rost @Reply 2 years ago
There's code in the Vault to check the status of all the keys, NumLock, CapsLock, etc., and toggle them. I'm on the road right now, but I'm sure you can find it with a search.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Table of Contents.

Next Unseen

New Feature: Comment Live View