Fom deactivating NUM LOCK

Hi all,
Im having a strange problem with one form in a database.
It is deactivating the numLock button on startup?

Ive tried building a new file, by importing all the objects into a fresh
database, but its still giving the same problem.
It sounds like there's some kind of corruption in the code, but all the
visible code looks and behaves sensibly.

Any ideas?



--

There is a bug with SendKeys that messes up the NumLock status.

It has been there for at least 9 years, and remains unfixed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gerry Abbott" <please@ask.ie> wrote in message
news:IzDvd.43919$Z14.20129@news.indigo.ie...[color=blue]
> Hi all,
> Im having a strange problem with one form in a database.
> It is deactivating the numLock button on startup?
>
> Ive tried building a new file, by importing all the objects into a fresh
> database, but its still giving the same problem.
> It sounds like there's some kind of corruption in the code, but all the
> visible code looks and behaves sensibly.
>
> Any ideas?[/color]

Thanks,
Yes there was a sendkeys command in one of the subforms.

OOP's
Ive used the sendkeys in other applications, unaware of its consequences.
I'm gonna have to review where, and when.


Im using this code for a zoom text box :
SendKeys "+{F2}{f2}"
Is there an alternative to the sendkeys?

Gerry Abbott



"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:41bf113d$0$21726$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=blue]
> There is a bug with SendKeys that messes up the NumLock status.
>
> It has been there for at least 9 years, and remains unfixed.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Gerry Abbott" <please@ask.ie> wrote in message
> news:IzDvd.43919$Z14.20129@news.indigo.ie...[color=green]
>> Hi all,
>> Im having a strange problem with one form in a database.
>> It is deactivating the numLock button on startup?
>>
>> Ive tried building a new file, by importing all the objects into a fresh
>> database, but its still giving the same problem.
>> It sounds like there's some kind of corruption in the code, but all the
>> visible code looks and behaves sensibly.
>>
>> Any ideas?[/color]
>
>[/color]

Fortunately there is an alernative for most of the SendKeys needs.

For this example, try:
RunCommand acCmdZoomBox

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gerry Abbott" <please@ask.ie> wrote in message
news:vOEvd.43921$Z14.20166@news.indigo.ie...[color=blue]
> Thanks,
> Yes there was a sendkeys command in one of the subforms.
>
> OOP's
> Ive used the sendkeys in other applications, unaware of its consequences.
> I'm gonna have to review where, and when.
>
>
> Im using this code for a zoom text box :
> SendKeys "+{F2}{f2}"
> Is there an alternative to the sendkeys?
>
> Gerry Abbott
>
>
>
> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
> news:41bf113d$0$21726$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=green]
>> There is a bug with SendKeys that messes up the NumLock status.
>>
>> It has been there for at least 9 years, and remains unfixed.
>>
>>
>> "Gerry Abbott" <please@ask.ie> wrote in message
>> news:IzDvd.43919$Z14.20129@news.indigo.ie...[color=darkred]
>>> Hi all,
>>> Im having a strange problem with one form in a database.
>>> It is deactivating the numLock button on startup?
>>>
>>> Ive tried building a new file, by importing all the objects into a fresh
>>> database, but its still giving the same problem.
>>> It sounds like there's some kind of corruption in the code, but all the
>>> visible code looks and behaves sensibly.
>>>
>>> Any ideas?[/color][/color][/color]

Once again thanks, and for the prompt reply.
I am fortunate to have written a txtZoom function. So I only have to change
this once in each application!
Otherwise i have not used the sendkeys function.

Issues like this one, do nothing to enhance the reputation of Access as a
good RDMS.

Gerry Abbott


"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:41bf1ab3$0$21746$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=blue]
> Fortunately there is an alernative for most of the SendKeys needs.
>
> For this example, try:
> RunCommand acCmdZoomBox
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Gerry Abbott" <please@ask.ie> wrote in message
> news:vOEvd.43921$Z14.20166@news.indigo.ie...[color=green]
>> Thanks,
>> Yes there was a sendkeys command in one of the subforms.
>>
>> OOP's
>> Ive used the sendkeys in other applications, unaware of its consequences.
>> I'm gonna have to review where, and when.
>>
>>
>> Im using this code for a zoom text box :
>> SendKeys "+{F2}{f2}"
>> Is there an alternative to the sendkeys?
>>
>> Gerry Abbott
>>
>>
>>
>> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
>> news:41bf113d$0$21726$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=darkred]
>>> There is a bug with SendKeys that messes up the NumLock status.
>>>
>>> It has been there for at least 9 years, and remains unfixed.
>>>
>>>
>>> "Gerry Abbott" <please@ask.ie> wrote in message
>>> news:IzDvd.43919$Z14.20129@news.indigo.ie...
>>>> Hi all,
>>>> Im having a strange problem with one form in a database.
>>>> It is deactivating the numLock button on startup?
>>>>
>>>> Ive tried building a new file, by importing all the objects into a
>>>> fresh database, but its still giving the same problem.
>>>> It sounds like there's some kind of corruption in the code, but all the
>>>> visible code looks and behaves sensibly.
>>>>
>>>> Any ideas?[/color][/color]
>
>[/color]

Gerry Abbott wrote:
[color=blue]
> Issues like this one, do nothing to enhance the reputation of Access as a
> good RDMS.[/color]

What, pray, do form and screen controls of any application, including
"Access" (you of course meant to say "Jet") have to do with the concept
of RDBMS (presumeably this is what you meant)?

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

I believe that they have everything to do with Access, since the development
tools to create these screen controls and forms come in the same box, for
which I paid my hard earned cash, and on which i make my living. And yes I
accept that Access out of the box does not represent a relational database
management system, but has to potential to create one/s.

The key point remains, that un-addressed software bugs, in any software
application, have the potential to sway users or would be users of the
software away from the product, and towards alternative solutions or
competitor software. The point is a trivial one.

Gerry Abbott,



"Tim Marshall" <TIMMY!@antarctic.flowerpots> wrote in message
news:cpn767$ruf$1@coranto.ucs.mun.ca...[color=blue]
> Gerry Abbott wrote:
>[color=green]
>> Issues like this one, do nothing to enhance the reputation of Access as a
>> good RDMS.[/color]
>
> What, pray, do form and screen controls of any application, including
> "Access" (you of course meant to say "Jet") have to do with the concept of
> RDBMS (presumeably this is what you meant)?
>
> --
> Tim http://www.ucs.mun.ca/~tmarshal/
> ^o<
> /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
> /^^ "What's UP, Dittoooooo?" - Ditto[/color]