Num Lock + Caps Lock react strangly

  • Thread starter Thread starter Norbert Jaeger
  • Start date Start date
N

Norbert Jaeger

Hi folks,

I "inherited" a complex MS Access database including a lot
of macros and even an interface to SAP R/3 where certain
data gets transferred from SAP to Access. I'm really not a
fundy on Access and therefor I'm looking for help.

While busy watching the girl entering data into the database
I could work out following phenomenon regarding the lights
of the Num Lock (NL) and the Caps Lock (CL).

Coming from a situation where the lights are both on:
- opening the database by double clicking the icon
for the database on the desktop.
result: NL on
CL on

- entering a quality name and pressing a button
which runs a macro asking SAP for
certain information on this quality. The macro
finishes with showing a entry form, where certain
fields have been filled in by the macro (with
values from SAP), others still to be filled in.
result: NL off
CL off


I don't want to go too deep with explaining my further
observations, otherwise this post gets too long, but maybe
somebody can tell me, what is triggering the NL and the CL
key?
(We actually want the lights to be always on, for NL and CL,
while we are working with the database.)

Where must I look for changing this behaviour. I know how to
change a macro which is startet by a command button, but I
don't know what to insert.

Any help is very much appreciated.

Regards,
Norbert
 
Most likely, the original developer used either the SendKeys action in
Macros or the SendKeys Method in VBA code. Unfortunately, there is a bug
with SendKeys and it affect A97 and possibly A2K.

Fortunately, we don't really need the SendKeys as you can almost always have
a proper command to execute whatever SendKeys is trying to execute. Most
professional Access database programmers don't use SendKeys.

The problem for you will be to find the appropriate commands to replace your
SendKeys.
 
Hi Dinh,

thank you very much for that fast reaction. That's
incredible!

Could you just give me an example for what exactely I have
to look for since I don't know what you mean with "SendKeys"
and maybe you could give me an example for an appropriate
command I have to replace that certain SendKey with.

I think that will help me a lot.

Thank you very much.

Regards,
Norbert
 
The equivalent command *depends* on what keystrokes the SendKeys is trying
to send. For example, the SendKeys:

Application.SendKeys "%EA"

is equivalent to:

DoCmd.RunCommand acCmdSelectAllRecords

Since you don't know about SendKeys action or SendKeys Method, I assume that
you are not familiar with Access and I think it time for professional help
rather than you try and bugger up the whole database.
 
I must admit. It seems to be really better to get
professional help.

Thank you anyway!!

At least now I know that I can't fix it, but I will still
give it a try with a copy of the database.

Regards,
Norbert
 
Back
Top