Num Lock turned off when using SendKeys - microsoft.public.access.modulesdaovba

On Sun, 3 Jan 2010 19:03:01 -0800, ThomasAJ <ThomasAJ@discussions.microsoft.com> wrote: >Code is: > >AppActivate "MYOB Accounting", True >Call DelaySeconds(0.5) >SendKeys "{TAB}", True > >It's definately the SendKeys that turns the Num Lock off. Yep. This is one of many, many reasons to avoid SendKeys if at all possible. I don't know if MYOB supports automation, but if it does, use it. Note that A2007 has, if I understand aright, removed SendKeys altogether. -- John W. Vinson [MVP]

And as far as my testing goes my Vista machine disables it and I'm sure it will be that way for Windows 7. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message news:jtm2k5dqm02hi1v71oamtsr5v2611caapp@4ax.com... > On Sun, 3 Jan 2010 19:03:01 -0800, ThomasAJ > <ThomasAJ@discussions.microsoft.com> wrote: > >>Code is: >> >>AppActivate "MYOB Accounting", True >>Call DelaySeconds(0.5) >>SendKeys "{TAB}", True >> >>It's definately the SendKeys that turns the Num Lock off. > > Yep. This is one of many, many reasons to avoid SendKeys if at all > possible. > > I don't know if MYOB supports automation, but if it does, use it. > > Note that A2007 has, if I understand aright, removed SendKeys altogether. > > -- > > John W. Vinson [MVP]

What a shame Sendkeys has such problems - is it asking MS too much to fix the problem rather than just can it? It is invaluable to me: eg I have to pay someone for work done for company. I need to update 3 different apps. 1 Mine, 2 Banking payment (actual payment), 3 MYOB. Without Sendkeys I need to very very carefully make sure I enter the correct info into all 3. With send keys I have do not have any such worry. It's ACCURATE and FAST and SIMPLE TO PROGRAM I LOVE SENDKEYS -- Regards Tom "Gina Whipp" wrote: > And as far as my testing goes my Vista machine disables it and I'm sure it > will be that way for Windows 7. > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message > news:jtm2k5dqm02hi1v71oamtsr5v2611caapp@4ax.com... > > On Sun, 3 Jan 2010 19:03:01 -0800, ThomasAJ > > <ThomasAJ@discussions.microsoft.com> wrote: > > > >>Code is: > >> > >>AppActivate "MYOB Accounting", True > >>Call DelaySeconds(0.5) > >>SendKeys "{TAB}", True > >> > >>It's definately the SendKeys that turns the Num Lock off. > > > > Yep. This is one of many, many reasons to avoid SendKeys if at all > > possible. > > > > I don't know if MYOB supports automation, but if it does, use it. > > > > Note that A2007 has, if I understand aright, removed SendKeys altogether. > > > > -- > > > > John W. Vinson [MVP] > > > . >

If I understand the issue correctly, SendKeys literally just sends keystrokes to the active window. Access cannot determine if the application in the active window is in a state to receive the keystrokes - like typing keystrokes on your keyboard, but with the monitor off. Its not a scenario that MS has control over as every software company out there would have to build into their application code that confirms the application state. I would suggest that you're love of SendKeys is only because you're in the very small minority of persons that's never had adverse problems with it. In short, you've gotten lucky, but statistically you're headed for a train wreck. MS, and many other application developers, do provide a viable means for working with an application from within another - Automation. It is simply the ability to access the Object Model of one application from within another. You've most likely seen posts and code wherein one Office application uses another to perform an action - such as Access automating Outlook to generate an email or Outlook reaching out to Access to get information from a .mdb file for use in an email. "ThomasAJ" <ThomasAJ@discussions.microsoft.com> wrote in message news:754E50ED-9B0D-4D1E-9C47-FBEE537207B2@microsoft.com... > What a shame Sendkeys has such problems - is it asking MS too much to fix > the > problem rather than just can it? > > It is invaluable to me: > > eg I have to pay someone for work done for company. > I need to update 3 different apps. > 1 Mine, 2 Banking payment (actual payment), 3 MYOB. > > Without Sendkeys I need to very very carefully make sure I enter the > correct > info into all 3. With send keys I have do not have any such worry. > > It's ACCURATE and FAST and SIMPLE TO PROGRAM > > I LOVE SENDKEYS > > -- > Regards > Tom > > > "Gina Whipp" wrote: > >> And as far as my testing goes my Vista machine disables it and I'm sure >> it >> will be that way for Windows 7. >> >> -- >> Gina Whipp >> 2010 Microsoft MVP (Access) >> >> "I feel I have been denied critical, need to know, information!" - >> Tremors >> II >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message >> news:jtm2k5dqm02hi1v71oamtsr5v2611caapp@4ax.com... >> > On Sun, 3 Jan 2010 19:03:01 -0800, ThomasAJ >> > <ThomasAJ@discussions.microsoft.com> wrote: >> > >> >>Code is: >> >> >> >>AppActivate "MYOB Accounting", True >> >>Call DelaySeconds(0.5) >> >>SendKeys "{TAB}", True >> >> >> >>It's definately the SendKeys that turns the Num Lock off. >> > >> > Yep. This is one of many, many reasons to avoid SendKeys if at all >> > possible. >> > >> > I don't know if MYOB supports automation, but if it does, use it. >> > >> > Note that A2007 has, if I understand aright, removed SendKeys >> > altogether. >> > >> > -- >> > >> > John W. Vinson [MVP] >> >> >> . >>

It's actually even worse than v2007 not recognizing SendKeys, from a number of posts I've read! Apparently it sometimes ***does*** and sometimes ***doesn't*** recognize them! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/201001/1

Precisely, which is why I think that the original poster is in the very rare minority that hasn't had problems with it. "Linq Adams via AccessMonster.com" <u28780@uwe> wrote in message news:a19d2eafd9f13@uwe... > It's actually even worse than v2007 not recognizing SendKeys, from a > number > of posts I've read! Apparently it sometimes ***does*** and sometimes > ***doesn't*** recognize them! > > -- > There's ALWAYS more than one way to skin a cat! > > Answers/posts based on Access 2000/2003 > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/201001/1 >

As stated in some other responses, SendKeys is not really recommended, but if you can't find any other alternative here is a link to a replacement module for SendKeys which may at least help solve your NumLock problem. The other drawbacks to SendKeys still apply however. http://www.mvps.org/access/api/api0046.htm -- _________ Sean Bailey "ThomasAJ" wrote: > What a shame Sendkeys has such problems - is it asking MS too much to fix the > problem rather than just can it? > > It is invaluable to me: > > eg I have to pay someone for work done for company. > I need to update 3 different apps. > 1 Mine, 2 Banking payment (actual payment), 3 MYOB. > > Without Sendkeys I need to very very carefully make sure I enter the correct > info into all 3. With send keys I have do not have any such worry. > > It's ACCURATE and FAST and SIMPLE TO PROGRAM > > I LOVE SENDKEYS > > -- > Regards > Tom > > > "Gina Whipp" wrote: > > > And as far as my testing goes my Vista machine disables it and I'm sure it > > will be that way for Windows 7. > > > > -- > > Gina Whipp > > 2010 Microsoft MVP (Access) > > > > "I feel I have been denied critical, need to know, information!" - Tremors > > II > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message > > news:jtm2k5dqm02hi1v71oamtsr5v2611caapp@4ax.com... > > > On Sun, 3 Jan 2010 19:03:01 -0800, ThomasAJ > > > <ThomasAJ@discussions.microsoft.com> wrote: > > > > > >>Code is: > > >> > > >>AppActivate "MYOB Accounting", True > > >>Call DelaySeconds(0.5) > > >>SendKeys "{TAB}", True > > >> > > >>It's definately the SendKeys that turns the Num Lock off. > > > > > > Yep. This is one of many, many reasons to avoid SendKeys if at all > > > possible. > > > > > > I don't know if MYOB supports automation, but if it does, use it. > > > > > > Note that A2007 has, if I understand aright, removed SendKeys altogether. > > > > > > -- > > > > > > John W. Vinson [MVP] > > > > > > . > >

I liked the disclaimer that SendKeys could result in your hard drive being reformated. The greater the number of variables in a system, the higher the probablity of catastrophic failure. "Beetle" <Beetle@discussions.microsoft.com> wrote in message news:F207290E-F584-4AF6-BE4A-052A55B48BF3@microsoft.com... > As stated in some other responses, SendKeys is not really > recommended, but if you can't find any other alternative > here is a link to a replacement module for SendKeys which may at > least help solve your NumLock problem. The other drawbacks > to SendKeys still apply however. > > http://www.mvps.org/access/api/api0046.htm > -- > _________ > > Sean Bailey > > > "ThomasAJ" wrote: > >> What a shame Sendkeys has such problems - is it asking MS too much to fix >> the >> problem rather than just can it? >> >> It is invaluable to me: >> >> eg I have to pay someone for work done for company. >> I need to update 3 different apps. >> 1 Mine, 2 Banking payment (actual payment), 3 MYOB. >> >> Without Sendkeys I need to very very carefully make sure I enter the >> correct >> info into all 3. With send keys I have do not have any such worry. >> >> It's ACCURATE and FAST and SIMPLE TO PROGRAM >> >> I LOVE SENDKEYS >> >> -- >> Regards >> Tom >> >> >> "Gina Whipp" wrote: >> >> > And as far as my testing goes my Vista machine disables it and I'm sure >> > it >> > will be that way for Windows 7. >> > >> > -- >> > Gina Whipp >> > 2010 Microsoft MVP (Access) >> > >> > "I feel I have been denied critical, need to know, information!" - >> > Tremors >> > II >> > >> > http://www.regina-whipp.com/index_files/TipList.htm >> > >> > "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message >> > news:jtm2k5dqm02hi1v71oamtsr5v2611caapp@4ax.com... >> > > On Sun, 3 Jan 2010 19:03:01 -0800, ThomasAJ >> > > <ThomasAJ@discussions.microsoft.com> wrote: >> > > >> > >>Code is: >> > >> >> > >>AppActivate "MYOB Accounting", True >> > >>Call DelaySeconds(0.5) >> > >>SendKeys "{TAB}", True >> > >> >> > >>It's definately the SendKeys that turns the Num Lock off. >> > > >> > > Yep. This is one of many, many reasons to avoid SendKeys if at all >> > > possible. >> > > >> > > I don't know if MYOB supports automation, but if it does, use it. >> > > >> > > Note that A2007 has, if I understand aright, removed SendKeys >> > > altogether. >> > > >> > > -- >> > > >> > > John W. Vinson [MVP] >> > >> > >> > . >> >

I have used it for 5 years now. At the beginning of each lot of sendkeys (say banking - yes banking - and of couse I check the $s etc - not once has it been wrong) a message pops of reminding to put the focus on a particular field - when done I press OK. Sendkeys fills out the form. I have used it many 1000s of times and no problem. I put a delay of about half a sec between sends and no problem. I use automation for emails in Outlook - cannot be done for other apps like say banking. -- Regards Tom "ThomasAJ" wrote: > Code is: > > AppActivate "MYOB Accounting", True > Call DelaySeconds(0.5) > SendKeys "{TAB}", True > > It's definately the SendKeys that turns the Num Lock off. > -- > Regards > Tom

oh I forgot - would I let one of my staff use it the way I do - probably not - maybe 1. There that'll make you happy :) -- Regards Tom "ThomasAJ" wrote: > I have used it for 5 years now. > > At the beginning of each lot of sendkeys (say banking - yes banking - and of > couse I check the $s etc - not once has it been wrong) a message pops of > reminding to put the focus on a particular field - when done I press OK. > Sendkeys fills out the form. > > I have used it many 1000s of times and no problem. I put a delay of about > half a sec between sends and no problem. > > I use automation for emails in Outlook - cannot be done for other apps like > say banking. > > -- > Regards > Tom > > > "ThomasAJ" wrote: > > > Code is: > > > > AppActivate "MYOB Accounting", True > > Call DelaySeconds(0.5) > > SendKeys "{TAB}", True > > > > It's definately the SendKeys that turns the Num Lock off. > > -- > > Regards > > Tom

Thanks -- Regards Tom "Beetle" wrote: > As stated in some other responses, SendKeys is not really > recommended, but if you can't find any other alternative > here is a link to a replacement module for SendKeys which may at > least help solve your NumLock problem. The other drawbacks > to SendKeys still apply however. > > http://www.mvps.org/access/api/api0046.htm > -- > _________ > > Sean Bailey > > > "ThomasAJ" wrote: > > > What a shame Sendkeys has such problems - is it asking MS too much to fix the > > problem rather than just can it? > > > > It is invaluable to me: > > > > eg I have to pay someone for work done for company. > > I need to update 3 different apps. > > 1 Mine, 2 Banking payment (actual payment), 3 MYOB. > > > > Without Sendkeys I need to very very carefully make sure I enter the correct > > info into all 3. With send keys I have do not have any such worry. > > > > It's ACCURATE and FAST and SIMPLE TO PROGRAM > > > > I LOVE SENDKEYS > > > > -- > > Regards > > Tom > > > > > > "Gina Whipp" wrote: > > > > > And as far as my testing goes my Vista machine disables it and I'm sure it > > > will be that way for Windows 7. > > > > > > -- > > > Gina Whipp > > > 2010 Microsoft MVP (Access) > > > > > > "I feel I have been denied critical, need to know, information!" - Tremors > > > II > > > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message > > > news:jtm2k5dqm02hi1v71oamtsr5v2611caapp@4ax.com... > > > > On Sun, 3 Jan 2010 19:03:01 -0800, ThomasAJ > > > > <ThomasAJ@discussions.microsoft.com> wrote: > > > > > > > >>Code is: > > > >> > > > >>AppActivate "MYOB Accounting", True > > > >>Call DelaySeconds(0.5) > > > >>SendKeys "{TAB}", True > > > >> > > > >>It's definately the SendKeys that turns the Num Lock off. > > > > > > > > Yep. This is one of many, many reasons to avoid SendKeys if at all > > > > possible. > > > > > > > > I don't know if MYOB supports automation, but if it does, use it. > > > > > > > > Note that A2007 has, if I understand aright, removed SendKeys altogether. > > > > > > > > -- > > > > > > > > John W. Vinson [MVP] > > > > > > > > > . > > >

=?Utf-8?B?VGhvbWFzQUo=?= <ThomasAJ@discussions.microsoft.com> wrote in news:1E460957-3669-4099-9263-B52662C92D8E@microsoft.com: > Code is: > > AppActivate "MYOB Accounting", True > Call DelaySeconds(0.5) > SendKeys "{TAB}", True > > It's definately the SendKeys that turns the Num Lock off. MYOB provides read/write ODBC drivers, so why not get those (they are free to registered users of MYOB) and then you won't need SendKeys at all. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/

Similiar Articles:

Num Lock turned off when using SendKeys - microsoft.public.access ...
Code is: AppActivate "MYOB Accounting", True Call DelaySeconds(0.5) SendKeys "{TAB}", True It's definately the SendKeys that turns the Num Lock off.

Num Lock Key Toggles Off - microsoft.public.access.formscoding ...
Num Lock turned off when using SendKeys - microsoft.public.access ... BUG: Multiple SendKeys Statement Turns Off NumLock Key Then, turn off the NumLock before using ...

Excel 2007 is turning off numlock - microsoft.public.excel.misc ...
Num Lock turned off when using SendKeys - microsoft.public.access ... Excel 2007 is turning off numlock - microsoft.public.excel.misc ... Num Lock turned off when using ...

NumLock Off - microsoft.public.access
Num Lock turned off when using SendKeys - microsoft.public.access ... Code is: AppActivate ... do I disable / enable the Num Lock key at startup? 0 = Num Lock is turned OFF ...

Windows 7 Sendkeys - microsoft.public.access.forms
Num Lock turned off when using SendKeys - microsoft.public.access ... Num Lock turned off when using SendKeys - microsoft.public.access ... Windows 7 Sendkeys - microsoft ...

The Find button in my db is turning off the NumLock. Solution ...
Num Lock turned off when using SendKeys - microsoft.public.access ... The Find button in my db is turning off the NumLock. Solution ... Num Lock turned off when using ...

>> SendKeys - microsoft.public.access.formscoding ...
Num Lock turned off when using SendKeys - microsoft.public.access ... Code is: AppActivate ... I have a database that uses SendKeys for a number of functions. They have ...

SendKeys & Windows 7 Problem - microsoft.public.access.forms ...
Num Lock turned off when using SendKeys - microsoft.public.access ... Num Lock turned off when using SendKeys - microsoft.public.access ..... it >> > will be that way for ...

how do i turn off the scroll lock. - microsoft.public.excel.misc ...
Num Lock turned off when using SendKeys - microsoft.public.access ... How do I turn off accent keys? - microsoft.public.word ... How do I turn off the caps lock on ...

caps lock - microsoft.public.outlook.general
Num Lock turned off when using SendKeys - microsoft.public.access ... How do I add caps lock notification to my Status bar? Help ... Num Lock turned off when using ...

How do I turn off accent keys? - microsoft.public.word ...
Num Lock turned off when using SendKeys - microsoft.public.access ... Num Lock turned off when using SendKeys - microsoft.public.access ... How do I turn off accent keys ...

My keyboard is writing caps but the cap lock's off - microsoft ...
Num Lock turned off when using SendKeys - microsoft.public.access ... My keyboard is writing caps but the cap lock's off - microsoft ... Num Lock turned off when using ...

SendKeys command for Ctrl-Shift-v? - microsoft.public.word.vba ...
Num Lock turned off when using SendKeys - microsoft.public.access ... SendKeys command for Ctrl-Shift-v? - microsoft.public.word.vba ... Num Lock turned off when using ...

SendKeys Action doesn't work - microsoft.public.access ...
Num Lock turned off when using SendKeys - microsoft.public.access ..... application uses another to perform an action - such ... to me: >> >> eg I have to pay someone ...

How to set Num Lock by default on a Hyper V - microsoft.public ...
turn on toggle keys will not work in windows 7 - microsoft.public ... Num Lock turned off when using SendKeys - microsoft ... insert" key no longer work when using Word ...

How do I turn off the caps lock on a form? - microsoft.public ...
Num Lock turned off when using SendKeys - microsoft.public.access ... How do I turn off the caps lock on a form? - microsoft.public ... Num Lock turned off when using ...

Re: How do I turn off. Accent marks in an Access Database ...
how do i turn off the scroll lock. - microsoft.public.excel.misc ... Num Lock turned off when using SendKeys - microsoft.public.access ... How do I turn off the caps ...

Screensaver will not turn off - microsoft.public.windowsxp.general ...
Num Lock turned off when using SendKeys - microsoft.public.access ... Screensaver will not turn off - microsoft.public.windowsxp.general ... Num Lock turned off when using ...

"Read-Only Recommended" check box won't turn off ...
Num Lock turned off when using SendKeys - microsoft.public.access ... "Read-Only Recommended" check box won't turn off ... Num Lock turned off when using SendKeys ...

Turning off One Note - microsoft.public.office.setup
Num Lock turned off when using SendKeys - microsoft.public.access ... Num Lock turned off when using SendKeys - microsoft.public.access ... how do I turn off highlighter ...

Num Lock turned off when using SendKeys DataBase
Code is: AppActivate MYOB Accounting, True Call DelaySeconds(0.5) SendKeys {TAB}, True it is definately the SendKeys that turns the Num Lock off. -- Reg

Num Lock turned off when using SendKeys
Code is: AppActivate "MYOB Accounting", True Call DelaySeconds(0.5) SendKeys "{TAB}", True It's definately the SendKeys that turns the Num Lock off.

Bug#641196: the screen is sometimes turned off when starting ...
Hi, Just the other day i noticed when the Num Lock LED is off i can type with the keypad numeral's. But when the LED is on it is dead. Any ideas?

Re: Num Lock turned off when using SendKeys
Re: Num Lock turned off when using SendKeys Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Num Lock turned off when using SendKeys - PC Review - Computer ...
Code is: AppActivate "MYOB Accounting", True Call DelaySeconds(0.5) SendKeys "{TAB}", True It's definately the SendKeys that turns the Num Lock off.

BUG: Multiple SendKeys Statement Turns Off NumLock Key
Then, turn off the NumLock before using SendKeys. After using SendKeys, reset the ... HOWTO: Toggle the NUM LOCK, CAPS LOCK, and SCROLL LOCK Keys

Visual Basic :: SendKeys Causes NumLock To Turn Off
SendKeys Causes NumLock To Turn Off When using SendKeys to turn an Enter keystroke into a Tab keystroke (SendKeys "{TAB}"), NumLock will briefly turn off.

SendKeys causes NumLock to turn off - VBForums
SendKeys causes NumLock to turn off Visual Basic 6 and Earlier ... as PageUp, PageDown, or whatever the number key ... '\\ "Press" scroll lock if it has changed

Turn On Num Lock DataBase - DataBase Discussion List Wednesday ...
How can I turn on the Num Lock key with VBA, XP Thank you ... That has been known to turn off NumLock ... Null End If End With No more sendkeys! No more num lock ...

7/19/2012 3:55:12 PM