473,396 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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?

--

Nov 13 '05 #1
6 5035
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" <pl****@ask.ie> wrote in message
news:Iz*******************@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?

Nov 13 '05 #2
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" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
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" <pl****@ask.ie> wrote in message
news:Iz*******************@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?


Nov 13 '05 #3
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" <pl****@ask.ie> wrote in message
news:vO*******************@news.indigo.ie...
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" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
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" <pl****@ask.ie> wrote in message
news:Iz*******************@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?

Nov 13 '05 #4
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" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
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" <pl****@ask.ie> wrote in message
news:vO*******************@news.indigo.ie...
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" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
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" <pl****@ask.ie> wrote in message
news:Iz*******************@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?


Nov 13 '05 #5
Gerry Abbott wrote:
Issues like this one, do nothing to enhance the reputation of Access as a
good RDMS.


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
Nov 13 '05 #6
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" <TI****@antarctic.flowerpots> wrote in message
news:cp**********@coranto.ucs.mun.ca...
Gerry Abbott wrote:
Issues like this one, do nothing to enhance the reputation of Access as a
good RDMS.


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

Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: xixi | last post by:
can someone explain to me what is internal p lock, internal s lock, internal v lock? when i have IS lock or IX lock , i always have these internal locks together for the application handle ...
0
by: Bruce Pullen | last post by:
DB2 v7.2 (FP7 - DB2 v7.1.0.68) on AIX 5.2.0.0. We're seeing unexpected single row (then commit) insert locking behaviour. We're seeing Applications that already hold row-level W locks in...
7
by: Sunny | last post by:
Hi, I can not understend completely the lock statement. Actally what is locked: 1. the part of the code between {...} or 2. the object in lock() In the docs is written: for 1: The lock...
0
by: Nashat Wanly | last post by:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaskdr/html/askgui06032003.asp Don't Lock Type Objects! Why Lock(typeof(ClassName)) or SyncLock GetType(ClassName) Is Bad Rico...
3
by: Raj | last post by:
I created a refresh deferred MQT, and during full refresh there were 4 or 5 lock waits, all waiting on a 'S' lock on Internal Catalog Cache ? Can some one explain how to prevent this from happening?
2
by: shenanwei | last post by:
DB2 V8.2 on AIX, type II index is created. I see this from deadlock event monitor. 5) Deadlocked Connection ... Participant no.: 2 Lock wait start time: 09/18/2006 23:04:09.911774 .........
190
by: blangela | last post by:
If you had asked me 5 years ago about the future of C++, I would have told you that its future was assured for many years to come. Recently, I have been starting to wonder. I have been teaching...
2
by: vikas2923 | last post by:
Can any body tell me plz how to change color on deactivating a text box i had tried the code but every time it is giving an error message "object not defined" .Pleased provide me the cod of it or...
94
by: Samuel R. Neff | last post by:
When is it appropriate to use "volatile" keyword? The docs simply state: " The volatile modifier is usually used for a field that is accessed by multiple threads without using the lock...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.