Disable the shift key

  • Thread starter Thread starter joel_ricoy
  • Start date Start date
J

joel_ricoy

Question.
I have alrady posted the following in the [Security]
newsgroup:
I know that setting a password on the front database is
not the best way to protect your file but the users at
work are the most neophite computer users you can find.
What i want to know is the easiest way to disable the
[Shift] key in case it is pressed by accident when the
user types his/her password.

I have had the following response:

You create a database property AllowBypassKey, and set
its value to False.

See http://www.mvps.org/access/general/gen0040.htm
at "The Access Web" for the correct way to do this.

Copy what's between Code Start and Code End and paste it
into a new module.
If you're using Access 2000 or 2002, make sure you set a
reference to DAO
(Tools | References when you're in the VB Editor, scroll
through the list
until you find Microsoft DAO 3.6 Object Library and put a
check beside it).

Open the Debug window, and type

ChangePropertyDdl "AllowBypassKey", dbBoolean, False

then hit Enter.

That's it. You're done! (It's not even necessary to save
the module you
copied-and-pasted the code into, nor to keep the reference
to DAO if you're
not using it otherwise)

My new (dumb) question is:
I copied and pasted, set the references but...
The ChangeProperty line that you indicated, is it typed in
the same screen as the code that I pasted? If it is so, is
it the first line above the function code?
I have typed the ChangeProperty line as a new module,
before the pasted code, after the pasted code with no
avail.
I apologize for my lack of understanding. I really
appreciate all your help.
 
As I said in the original post, the line

ChangePropertyDdl "AllowBypassKey", dbBoolean, False

is typed into the Debug window. It does not get keyed into the module.

Use Ctrl-G to open the Debug window. Type that expression, then hit Enter.
 
OOPs! thank you very much, I finally got it!!!
Sorry about it!
Thank you very much for your help!
-----Original Message-----
As I said in the original post, the line

ChangePropertyDdl "AllowBypassKey", dbBoolean, False

is typed into the Debug window. It does not get keyed into the module.

Use Ctrl-G to open the Debug window. Type that expression, then hit Enter.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Question.
I have alrady posted the following in the [Security]
newsgroup:
I know that setting a password on the front database is
not the best way to protect your file but the users at
work are the most neophite computer users you can find.
What i want to know is the easiest way to disable the
[Shift] key in case it is pressed by accident when the
user types his/her password.

I have had the following response:

You create a database property AllowBypassKey, and set
its value to False.

See http://www.mvps.org/access/general/gen0040.htm
at "The Access Web" for the correct way to do this.

Copy what's between Code Start and Code End and paste it
into a new module.
If you're using Access 2000 or 2002, make sure you set a
reference to DAO
(Tools | References when you're in the VB Editor, scroll
through the list
until you find Microsoft DAO 3.6 Object Library and put a
check beside it).

Open the Debug window, and type

ChangePropertyDdl "AllowBypassKey", dbBoolean, False

then hit Enter.

That's it. You're done! (It's not even necessary to save
the module you
copied-and-pasted the code into, nor to keep the reference
to DAO if you're
not using it otherwise)

My new (dumb) question is:
I copied and pasted, set the references but...
The ChangeProperty line that you indicated, is it typed in
the same screen as the code that I pasted? If it is so, is
it the first line above the function code?
I have typed the ChangeProperty line as a new module,
before the pasted code, after the pasted code with no
avail.
I apologize for my lack of understanding. I really
appreciate all your help.
Click to expand...


.
Click to expand...
 
Back
Top