Forcing the CAPSLOCK to be ON starting Access or Form

[Screaming Eagles 101]

Dearest,

starting Access , or at the opening of a FORM
I would like to have the CAPSLOCK always ON,
have tried this with SENDKEYS "{CAPSLOCK}" but this doesn't do anything.

Can anyone help ?

Phil

 

[John Vinson]

Dearest,

starting Access , or at the opening of a FORM
I would like to have the CAPSLOCK always ON,
have tried this with SENDKEYS "{CAPSLOCK}" but this doesn't do anything.

Can anyone help ?

Phil

Well... don't do it that way. I'd be REALLY peeved at any computer
application that messed with my keyboard settings; I do use programs
other than Access and would not want to have them stART TYPING IN ALL
CAPS.

Instead, put code in the AfterUpdate event of every field which you
want in all caps:

Private Sub controlname_AfterUpdate()
Me!controlname = Ucase(Me!Controlname)
End Sub

Do note that all caps is HARD TO READ and should only be used
sparingly, for those fields which need it. People's names (just as an
example) should generally be entered in mixed case. Obviously some
fields (part numbers, perhaps) should be uppercase, but to do so for
all fields in your database would be unusual at best.

John W. Vinson[MVP]

 

[Robert Morley]

I agree that you should generally never turn on the Caps Lock
programmatically, but if for some reason you absolutely MUST do it this way,
here's an article that explains what's happening, and the "References"
section refers you to another article that will tell you how to change the
state in VB/VBA.

http://support.microsoft.com/kb/192273/en-us



Rob

 

[Screaming Eagles 101]

I agree that you should generally never turn on the Caps Lock
programmatically, but if for some reason you absolutely MUST do it this
way, here's an article that explains what's happening, and the "References"
section refers you to another article that will tell you how to change the
state in VB/VBA.

http://support.microsoft.com/kb/192273/en-us



Rob

Thanks for the article.
I have to do this because with the keyboards in Belgium you need the
capslock on to type a digit instead of a &,é,",',(,§, ... (etc...)
As long as you use the numeric pad, no problem, but using a barcode scanner,
whoosh, trouble starts, because the scanner
uses the digits from your alfanumeric keyboard.
So, the whole world uses a Qwerty with the digits beneath, Belgium has to do
its own way with Azerty keyboard and
the digits above (grrrrhh). So, a function uppercase is not helping, the
Upper("&") is not 1 ....
I can only help myself by setting the Capslock on while scanning...
Phil

 

[Rick Brandt]

Thanks for the article.
I have to do this because with the keyboards in Belgium you need the
capslock on to type a digit instead of a &,é,",',(,§, ... (etc...)
As long as you use the numeric pad, no problem, but using a barcode scanner,
whoosh, trouble starts, because the scanner
uses the digits from your alfanumeric keyboard.
So, the whole world uses a Qwerty with the digits beneath, Belgium has to do
its own way with Azerty keyboard and
the digits above (grrrrhh). So, a function uppercase is not helping, the
Upper("&") is not 1 ....
I can only help myself by setting the Capslock on while scanning...
Phil

I don't understand this. Surely the scanner is sending the value for the
character, not the key on the keyboard. If what you are saying is correct then
every non-Belgian who uses a scanner would have to make sure the caps lock key
was in the "Off" state for the characters to come out right.

 

[Screaming Eagles 101]

I don't understand this. Surely the scanner is sending the value for the
character, not the key on the keyboard. If what you are saying is correct then
every non-Belgian who uses a scanner would have to make sure the caps lock key
was in the "Off" state for the characters to come out right.

I'm pretty sure this is the case.
Our scanners work that way....
While scanning => if the capsLock is on we get 123456....,
if it's off we get &é"'(§.....

 

[Screaming Eagles 101]

Well I have several apps that would definitely generate errors because the value
scanned has to match a value in an existing table and have never had anyone
report a scanning error. I find it hard to believe that the caps lock key was
never on because most of our users also use 5250 emulators and many leave the
caps lock key on when using the emulater.

Perhaps this is a setup parameter in the scanner's software that you need to
change?

You will not believe me => why didn't I think of that.... ?
Well, first things first, this is the pc and barcode reader of close friend
who owes a shop, uh ....yes, a computershop
So, I assumed he already did that.... but now I'm starting to think, maybe
you're right...
Maybe he didn't check the settings, even if he sells computers...

So, I'm seeing him on Wednesday evening, first thing before I start building
code to help him
is check the control panel to see if something can be set overthere....
Sometimes solutions can be simple... OK, fingers crossed it's nothing more
than that.
And if it is : thanks a lot to help these 2 dumbo's.... :-|

Phil

 

[John Vinson]

Maybe he didn't check the settings, even if he sells computers...

LOL! Like the old sayings:

"The shoemaker's children always go barefoot"

and

"The dentist's children see their dentist after every meal and brush
their teeth twice a year"...

John W. Vinson[MVP]