[AccessD] Num Lock Key in 2007

Any use of the MS "SendKeys" function can randomly change the keyboard state. "mySendKeys" takes the trouble to preserve the keyboard state before calling the native Sendkeys, and then restores the prior keyboard state.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software
Sent: Thursday, January 08, 2009 2:53 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Num Lock Key in 2007

Lambert:

Well I recently added this:

' if this is Access 2007 then minimize ribbon
    If Int(Version) = 12 Then SendKeys "^{F1}"

And there are a few of these:         SendKeys "{ESC}" but they've been in
there for a long time.

Got one of these:         SendKeys "+{TAB}"

but it only gets run if the password on the opening form is incorrect and I want to place the focus on the previous control.

Any of them look like the culprit?

TIA


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Thursday, January 08, 2009 11:40 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Num Lock Key in 2007

Are you using "SendKeys", if so switch to mySendKeys...
http://www.mvps.org/access/api/api0046.htm

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software
Sent: Thursday, January 08, 2009 2:03 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Num Lock Key in 2007

Dear List:

Has anyone had a problem with the num lock key turning itself off in A2K7?
Just started happening to a client and then I noticed it on my 2007 box.

TIA



Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/>

www.bchacc.com <http://www.bchacc.com/>






--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com