Num Lock Key goes off

[Jamey]

I have created a database with many forms and macros. I
have properties set up in the macros to
close/restore/send keys, etc amongst the navigation of
the menus to open and close the forms. Upon opening and
closing some of the forms, the num lock key goes off on
the keyboard. Which property causes this so I can correct
it? it is driving us crazy!

 

[Nikos Yannacopoulos]

Jamey,

Just guessing here, but I suspect it's the SendKeys action that does it.
Generally speaking, SendKeys is known to produce unexpected results very
often, and is therefore to be avoided (almost?) at any cost. Whatever you
are trying to do with it can be done more efficiently and more reliably with
a bit of code, so I urge you to investigate that option. If you're not very
handy with VBA, then I would suggest you post to the formscoding NG with as
much detail as possible, and you'll stand a good chance of getting specific
help.

HTH,
Nikos

 

[Jamey]

Thanks Nikos,

I am not surprised that sendkeys is the culprit. I did
just change the macro and the num lock key is no longer
going off. Email me please at (e-mail address removed).

Thanks!