the Shift key

  • Thread starter Thread starter Joel_ricoy
  • Start date Start date
J

Joel_ricoy

Hello everyone out there,

Sorry for my stupid request but...

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.

Thank you for your help.
 
-----Original Message-----
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.
Click to expand...

I have visited the web site that you have indicated and
look at the code. My question is (and I know it is a very
dumb question) how do I set the property?
I have gone over the help screen in Access but I could
not find tha way to do it. How Access runs this code?
How access knows the code exists? Am I way over my head?
please, help.
Thanx.
--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Hello everyone out there,

Sorry for my stupid request but...

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.

Thank you for your help.
Click to expand...


.
Click to expand...
 
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)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



joel_ricoy said:
-----Original Message-----
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.
Click to expand...

I have visited the web site that you have indicated and
look at the code. My question is (and I know it is a very
dumb question) how do I set the property?
I have gone over the help screen in Access but I could
not find tha way to do it. How Access runs this code?
How access knows the code exists? Am I way over my head?
please, help.
Thanx.
--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Hello everyone out there,

Sorry for my stupid request but...

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.

Thank you for your help.
Click to expand...


.
Click to expand...
Click to expand...
 
I copied and pasted, set the references but...
The ChangeProperty line that you indicated, is it 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 code, after the code with no avail.
I apologize for my lack of understanding. I really
appreciate all your help.
-----Original Message-----
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)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



-----Original Message-----
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.
Click to expand...

I have visited the web site that you have indicated and
look at the code. My question is (and I know it is a very
dumb question) how do I set the property?
I have gone over the help screen in Access but I could
not find tha way to do it. How Access runs this code?
How access knows the code exists? Am I way over my head?
please, help.
Thanx.
--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



"Joel_ricoy" <[email protected]>
Click to expand...
wrote
in message
Hello everyone out there,

Sorry for my stupid request but...

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.

Thank you for your help.


.
Click to expand...
Click to expand...


.
Click to expand...
 
Using Access 2003. Just started looking today on how to bypass the idiotic
shift key. Magic found this nicely set out series of posts. Followed the
instructions. Copied pasted and save the code. Copied pasted the command for
the immediate window and ran the function in the immediate window. Closed the
database, opened it holding down the shift key bypassed the startup form?
Reran the code in the immediate window. Closed down Access. Held down the
shift key, double clicked the application Icon, bypassed the startup form.
Closed Access. Double clicked the Application Icon got my startup form???

I am I think in "sandbox" mode. Have set up a personal digital signature so
that I can get my application to start without the no, yes (or is that maybe)
open stuff.

Any Ideas. Anything else I can try that might work? Should I just forget it
and get on with the important things in life like developing the application?

[email protected] said:
I copied and pasted, set the references but...
The ChangeProperty line that you indicated, is it 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 code, after the code with no avail.
I apologize for my lack of understanding. I really
appreciate all your help.
-----Original Message-----
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)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



-----Original Message-----
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.

I have visited the web site that you have indicated and
look at the code. My question is (and I know it is a very
dumb question) how do I set the property?
I have gone over the help screen in Access but I could
not find tha way to do it. How Access runs this code?
How access knows the code exists? Am I way over my head?
please, help.
Thanx.
--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



in message
Hello everyone out there,

Sorry for my stupid request but...

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.

Thank you for your help.


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top