Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: suppress SHIFT key

Geek News

suppress SHIFT key
tracktraining 11/13/2008 5:38:14 PM
Hi All,

Can anyone tell me how to suppress the SHIFT key bypass?

Thanks,
Tracktraining
--
Learning
Re: suppress SHIFT key
"Klatuu" <david.hargis[ at ]realpage.com> 11/13/2008 5:48:27 PM
Define suppress.
What is it you want to do?

"tracktraining" <tracktraining[ at ]discussions.microsoft.com> wrote in message
news:EBACE2D5-D743-438D-9E8A-7B12F399A3C0[ at ]microsoft.com...
[Quoted Text]
> Hi All,
>
> Can anyone tell me how to suppress the SHIFT key bypass?
>
> Thanks,
> Tracktraining
> --
> Learning


Re: suppress SHIFT key
tracktraining 11/13/2008 6:27:01 PM
I don't want the user to be able to press SHIFT key and open the db and thus
bypassing the start-up setting.

--
Learning


"Klatuu" wrote:

[Quoted Text]
> Define suppress.
> What is it you want to do?
>
> "tracktraining" <tracktraining[ at ]discussions.microsoft.com> wrote in message
> news:EBACE2D5-D743-438D-9E8A-7B12F399A3C0[ at ]microsoft.com...
> > Hi All,
> >
> > Can anyone tell me how to suppress the SHIFT key bypass?
> >
> > Thanks,
> > Tracktraining
> > --
> > Learning
>
>
>
Re: suppress SHIFT key
"Klatuu" <david.hargis[ at ]realpage.com> 11/13/2008 7:09:43 PM
Try this utility. It really works pretty well

http://www.jamiessoftware.tk/propeditor/pe_jump.html

"tracktraining" <tracktraining[ at ]discussions.microsoft.com> wrote in message
news:46BAEB9B-0F7A-4581-9BF4-78F4FF827E6E[ at ]microsoft.com...
[Quoted Text]
>I don't want the user to be able to press SHIFT key and open the db and
>thus
> bypassing the start-up setting.
>
> --
> Learning
>
>
> "Klatuu" wrote:
>
>> Define suppress.
>> What is it you want to do?
>>
>> "tracktraining" <tracktraining[ at ]discussions.microsoft.com> wrote in
>> message
>> news:EBACE2D5-D743-438D-9E8A-7B12F399A3C0[ at ]microsoft.com...
>> > Hi All,
>> >
>> > Can anyone tell me how to suppress the SHIFT key bypass?
>> >
>> > Thanks,
>> > Tracktraining
>> > --
>> > Learning
>>
>>
>>


RE: suppress SHIFT key
MikeJohnB 11/13/2008 7:31:18 PM
you can also suppress the shift key bypass in the >>tools/startup<< options,
untick allow access special keys. Be careful, not even you will be able to
shift bypass the opening database though and you should retain a master copy
on which the option is not set. This option is best used on front end back
split databases where the front end issued to the users has this option
unticked, your copy doesn't.

For Access 2007, this option can be found from clicking the windows globe,
top left of the open database screen, select Access Options at the bottom of
the popup menu, select current database and set or unset the options you want
to allow the users to be able to access on the form you use as the startup
form. The startup form is also nominated in this area.

However, if you have disallowed menus, I would have thought you would have
been using this area so perhaps I'm barking up the wrong tree as some say????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"tracktraining" wrote:

[Quoted Text]
> Hi All,
>
> Can anyone tell me how to suppress the SHIFT key bypass?
>
> Thanks,
> Tracktraining
> --
> Learning
Re: suppress SHIFT key
"Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 11/14/2008 12:38:36 PM
I don't believe that's correct, Mike.

To suppress the shift key bypass, you need to create a database property
named AllowBypassKey and set it to False. The proper way to create the
property is shown in http://www.mvps.org/access/general/gen0040.htm at "The
Access Web".

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5[ at ]microsoft.com...
[Quoted Text]
> you can also suppress the shift key bypass in the >>tools/startup<<
> options,
> untick allow access special keys. Be careful, not even you will be able to
> shift bypass the opening database though and you should retain a master
> copy
> on which the option is not set. This option is best used on front end back
> split databases where the front end issued to the users has this option
> unticked, your copy doesn't.
>
> For Access 2007, this option can be found from clicking the windows globe,
> top left of the open database screen, select Access Options at the bottom
> of
> the popup menu, select current database and set or unset the options you
> want
> to allow the users to be able to access on the form you use as the startup
> form. The startup form is also nominated in this area.
>
> However, if you have disallowed menus, I would have thought you would have
> been using this area so perhaps I'm barking up the wrong tree as some
> say????
>
> Regards
> --
> Advice to Posters.
> Check your post for replies or request for more information.
> Consider providing some feed back to the response you have recieved.
> Kindest Regards Mike B
>
>
> "tracktraining" wrote:
>
>> Hi All,
>>
>> Can anyone tell me how to suppress the SHIFT key bypass?
>>
>> Thanks,
>> Tracktraining
>> --
>> Learning


Re: suppress SHIFT key
MikeJohnB 11/14/2008 2:11:01 PM
You know something Douglas, you are absolutely right, I tried it on a spare
database I have, I have thought that not allowing Special Keys prevented the
shift key option for some time. However, I normally test before posting so I
guess I ought to re-start that before replying. Confidence now in tatters.

Thanks for putting me right though.

Cheers, have one on me.

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Douglas J. Steele" wrote:

[Quoted Text]
> I don't believe that's correct, Mike.
>
> To suppress the shift key bypass, you need to create a database property
> named AllowBypassKey and set it to False. The proper way to create the
> property is shown in http://www.mvps.org/access/general/gen0040.htm at "The
> Access Web".
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
> news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5[ at ]microsoft.com...
> > you can also suppress the shift key bypass in the >>tools/startup<<
> > options,
> > untick allow access special keys. Be careful, not even you will be able to
> > shift bypass the opening database though and you should retain a master
> > copy
> > on which the option is not set. This option is best used on front end back
> > split databases where the front end issued to the users has this option
> > unticked, your copy doesn't.
> >
> > For Access 2007, this option can be found from clicking the windows globe,
> > top left of the open database screen, select Access Options at the bottom
> > of
> > the popup menu, select current database and set or unset the options you
> > want
> > to allow the users to be able to access on the form you use as the startup
> > form. The startup form is also nominated in this area.
> >
> > However, if you have disallowed menus, I would have thought you would have
> > been using this area so perhaps I'm barking up the wrong tree as some
> > say????
> >
> > Regards
> > --
> > Advice to Posters.
> > Check your post for replies or request for more information.
> > Consider providing some feed back to the response you have recieved.
> > Kindest Regards Mike B
> >
> >
> > "tracktraining" wrote:
> >
> >> Hi All,
> >>
> >> Can anyone tell me how to suppress the SHIFT key bypass?
> >>
> >> Thanks,
> >> Tracktraining
> >> --
> >> Learning
>
>
>
Re: suppress SHIFT key
"Klatuu" <david.hargis[ at ]realpage.com> 11/14/2008 3:41:42 PM
Actually, this should enhance your confidence.

I am confident that if I post something that is incorrect, Doug will
politely and correctly straighten me out. <g>

"MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
news:7E44F7EF-574C-4381-B630-0F8509618E87[ at ]microsoft.com...
[Quoted Text]
> You know something Douglas, you are absolutely right, I tried it on a
> spare
> database I have, I have thought that not allowing Special Keys prevented
> the
> shift key option for some time. However, I normally test before posting so
> I
> guess I ought to re-start that before replying. Confidence now in tatters.
>
> Thanks for putting me right though.
>
> Cheers, have one on me.
>
> Mike B
> --
> Advice to Posters.
> Check your post for replies or request for more information.
> Consider providing some feed back to the response you have recieved.
> Kindest Regards Mike B
>
>
> "Douglas J. Steele" wrote:
>
>> I don't believe that's correct, Mike.
>>
>> To suppress the shift key bypass, you need to create a database property
>> named AllowBypassKey and set it to False. The proper way to create the
>> property is shown in http://www.mvps.org/access/general/gen0040.htm at
>> "The
>> Access Web".
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
>> news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5[ at ]microsoft.com...
>> > you can also suppress the shift key bypass in the >>tools/startup<<
>> > options,
>> > untick allow access special keys. Be careful, not even you will be able
>> > to
>> > shift bypass the opening database though and you should retain a master
>> > copy
>> > on which the option is not set. This option is best used on front end
>> > back
>> > split databases where the front end issued to the users has this option
>> > unticked, your copy doesn't.
>> >
>> > For Access 2007, this option can be found from clicking the windows
>> > globe,
>> > top left of the open database screen, select Access Options at the
>> > bottom
>> > of
>> > the popup menu, select current database and set or unset the options
>> > you
>> > want
>> > to allow the users to be able to access on the form you use as the
>> > startup
>> > form. The startup form is also nominated in this area.
>> >
>> > However, if you have disallowed menus, I would have thought you would
>> > have
>> > been using this area so perhaps I'm barking up the wrong tree as some
>> > say????
>> >
>> > Regards
>> > --
>> > Advice to Posters.
>> > Check your post for replies or request for more information.
>> > Consider providing some feed back to the response you have recieved.
>> > Kindest Regards Mike B
>> >
>> >
>> > "tracktraining" wrote:
>> >
>> >> Hi All,
>> >>
>> >> Can anyone tell me how to suppress the SHIFT key bypass?
>> >>
>> >> Thanks,
>> >> Tracktraining
>> >> --
>> >> Learning
>>
>>
>>


Re: suppress SHIFT key
tracktraining 11/14/2008 5:40:09 PM
thanks Mike, Doug, and Klatuu for helping out. I will try that code.

--
Learning


"Douglas J. Steele" wrote:

[Quoted Text]
> I don't believe that's correct, Mike.
>
> To suppress the shift key bypass, you need to create a database property
> named AllowBypassKey and set it to False. The proper way to create the
> property is shown in http://www.mvps.org/access/general/gen0040.htm at "The
> Access Web".
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
> news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5[ at ]microsoft.com...
> > you can also suppress the shift key bypass in the >>tools/startup<<
> > options,
> > untick allow access special keys. Be careful, not even you will be able to
> > shift bypass the opening database though and you should retain a master
> > copy
> > on which the option is not set. This option is best used on front end back
> > split databases where the front end issued to the users has this option
> > unticked, your copy doesn't.
> >
> > For Access 2007, this option can be found from clicking the windows globe,
> > top left of the open database screen, select Access Options at the bottom
> > of
> > the popup menu, select current database and set or unset the options you
> > want
> > to allow the users to be able to access on the form you use as the startup
> > form. The startup form is also nominated in this area.
> >
> > However, if you have disallowed menus, I would have thought you would have
> > been using this area so perhaps I'm barking up the wrong tree as some
> > say????
> >
> > Regards
> > --
> > Advice to Posters.
> > Check your post for replies or request for more information.
> > Consider providing some feed back to the response you have recieved.
> > Kindest Regards Mike B
> >
> >
> > "tracktraining" wrote:
> >
> >> Hi All,
> >>
> >> Can anyone tell me how to suppress the SHIFT key bypass?
> >>
> >> Thanks,
> >> Tracktraining
> >> --
> >> Learning
>
>
>
Re: suppress SHIFT key
tracktraining 11/14/2008 5:45:01 PM
by the way, the suppress SHIFT code will only affect the db that I have the
code in correct? it will not affect MS Access?

-Tracktraining
--
Learning


"Klatuu" wrote:

[Quoted Text]
> Actually, this should enhance your confidence.
>
> I am confident that if I post something that is incorrect, Doug will
> politely and correctly straighten me out. <g>
>
> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
> news:7E44F7EF-574C-4381-B630-0F8509618E87[ at ]microsoft.com...
> > You know something Douglas, you are absolutely right, I tried it on a
> > spare
> > database I have, I have thought that not allowing Special Keys prevented
> > the
> > shift key option for some time. However, I normally test before posting so
> > I
> > guess I ought to re-start that before replying. Confidence now in tatters.
> >
> > Thanks for putting me right though.
> >
> > Cheers, have one on me.
> >
> > Mike B
> > --
> > Advice to Posters.
> > Check your post for replies or request for more information.
> > Consider providing some feed back to the response you have recieved.
> > Kindest Regards Mike B
> >
> >
> > "Douglas J. Steele" wrote:
> >
> >> I don't believe that's correct, Mike.
> >>
> >> To suppress the shift key bypass, you need to create a database property
> >> named AllowBypassKey and set it to False. The proper way to create the
> >> property is shown in http://www.mvps.org/access/general/gen0040.htm at
> >> "The
> >> Access Web".
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
> >> news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5[ at ]microsoft.com...
> >> > you can also suppress the shift key bypass in the >>tools/startup<<
> >> > options,
> >> > untick allow access special keys. Be careful, not even you will be able
> >> > to
> >> > shift bypass the opening database though and you should retain a master
> >> > copy
> >> > on which the option is not set. This option is best used on front end
> >> > back
> >> > split databases where the front end issued to the users has this option
> >> > unticked, your copy doesn't.
> >> >
> >> > For Access 2007, this option can be found from clicking the windows
> >> > globe,
> >> > top left of the open database screen, select Access Options at the
> >> > bottom
> >> > of
> >> > the popup menu, select current database and set or unset the options
> >> > you
> >> > want
> >> > to allow the users to be able to access on the form you use as the
> >> > startup
> >> > form. The startup form is also nominated in this area.
> >> >
> >> > However, if you have disallowed menus, I would have thought you would
> >> > have
> >> > been using this area so perhaps I'm barking up the wrong tree as some
> >> > say????
> >> >
> >> > Regards
> >> > --
> >> > Advice to Posters.
> >> > Check your post for replies or request for more information.
> >> > Consider providing some feed back to the response you have recieved.
> >> > Kindest Regards Mike B
> >> >
> >> >
> >> > "tracktraining" wrote:
> >> >
> >> >> Hi All,
> >> >>
> >> >> Can anyone tell me how to suppress the SHIFT key bypass?
> >> >>
> >> >> Thanks,
> >> >> Tracktraining
> >> >> --
> >> >> Learning
> >>
> >>
> >>
>
>
>
Re: suppress SHIFT key
tracktraining 11/14/2008 6:46:01 PM
sorry for asking/making so many comments.... but I don't understand how to
call that function and where to call it in my db.

Any help please?

-Thanks!
--
Learning


"Douglas J. Steele" wrote:

[Quoted Text]
> I don't believe that's correct, Mike.
>
> To suppress the shift key bypass, you need to create a database property
> named AllowBypassKey and set it to False. The proper way to create the
> property is shown in http://www.mvps.org/access/general/gen0040.htm at "The
> Access Web".
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
> news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5[ at ]microsoft.com...
> > you can also suppress the shift key bypass in the >>tools/startup<<
> > options,
> > untick allow access special keys. Be careful, not even you will be able to
> > shift bypass the opening database though and you should retain a master
> > copy
> > on which the option is not set. This option is best used on front end back
> > split databases where the front end issued to the users has this option
> > unticked, your copy doesn't.
> >
> > For Access 2007, this option can be found from clicking the windows globe,
> > top left of the open database screen, select Access Options at the bottom
> > of
> > the popup menu, select current database and set or unset the options you
> > want
> > to allow the users to be able to access on the form you use as the startup
> > form. The startup form is also nominated in this area.
> >
> > However, if you have disallowed menus, I would have thought you would have
> > been using this area so perhaps I'm barking up the wrong tree as some
> > say????
> >
> > Regards
> > --
> > Advice to Posters.
> > Check your post for replies or request for more information.
> > Consider providing some feed back to the response you have recieved.
> > Kindest Regards Mike B
> >
> >
> > "tracktraining" wrote:
> >
> >> Hi All,
> >>
> >> Can anyone tell me how to suppress the SHIFT key bypass?
> >>
> >> Thanks,
> >> Tracktraining
> >> --
> >> Learning
>
>
>
Re: suppress SHIFT key
"Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 11/14/2008 6:54:47 PM
That function doesn't actually have to be included in your application: it's
a one-time action you need to do.

You might find it easier to download Albert Kallal's By Pass Shift Key Code,
about half-way down the page at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"tracktraining" <tracktraining[ at ]discussions.microsoft.com> wrote in message
news:6184A07C-56C2-4241-A59E-C46DFCFDFB3D[ at ]microsoft.com...
[Quoted Text]
> sorry for asking/making so many comments.... but I don't understand how to
> call that function and where to call it in my db.
>
> Any help please?
>
> -Thanks!
> --
> Learning
>
>
> "Douglas J. Steele" wrote:
>
>> I don't believe that's correct, Mike.
>>
>> To suppress the shift key bypass, you need to create a database property
>> named AllowBypassKey and set it to False. The proper way to create the
>> property is shown in http://www.mvps.org/access/general/gen0040.htm at
>> "The
>> Access Web".
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
>> news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5[ at ]microsoft.com...
>> > you can also suppress the shift key bypass in the >>tools/startup<<
>> > options,
>> > untick allow access special keys. Be careful, not even you will be able
>> > to
>> > shift bypass the opening database though and you should retain a master
>> > copy
>> > on which the option is not set. This option is best used on front end
>> > back
>> > split databases where the front end issued to the users has this option
>> > unticked, your copy doesn't.
>> >
>> > For Access 2007, this option can be found from clicking the windows
>> > globe,
>> > top left of the open database screen, select Access Options at the
>> > bottom
>> > of
>> > the popup menu, select current database and set or unset the options
>> > you
>> > want
>> > to allow the users to be able to access on the form you use as the
>> > startup
>> > form. The startup form is also nominated in this area.
>> >
>> > However, if you have disallowed menus, I would have thought you would
>> > have
>> > been using this area so perhaps I'm barking up the wrong tree as some
>> > say????
>> >
>> > Regards
>> > --
>> > Advice to Posters.
>> > Check your post for replies or request for more information.
>> > Consider providing some feed back to the response you have recieved.
>> > Kindest Regards Mike B
>> >
>> >
>> > "tracktraining" wrote:
>> >
>> >> Hi All,
>> >>
>> >> Can anyone tell me how to suppress the SHIFT key bypass?
>> >>
>> >> Thanks,
>> >> Tracktraining
>> >> --
>> >> Learning
>>
>>
>>


Re: suppress SHIFT key
tracktraining 11/14/2008 7:50:04 PM
THANKS! it works!
--
Learning


"Douglas J. Steele" wrote:

[Quoted Text]
> That function doesn't actually have to be included in your application: it's
> a one-time action you need to do.
>
> You might find it easier to download Albert Kallal's By Pass Shift Key Code,
> about half-way down the page at
> http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "tracktraining" <tracktraining[ at ]discussions.microsoft.com> wrote in message
> news:6184A07C-56C2-4241-A59E-C46DFCFDFB3D[ at ]microsoft.com...
> > sorry for asking/making so many comments.... but I don't understand how to
> > call that function and where to call it in my db.
> >
> > Any help please?
> >
> > -Thanks!
> > --
> > Learning
> >
> >
> > "Douglas J. Steele" wrote:
> >
> >> I don't believe that's correct, Mike.
> >>
> >> To suppress the shift key bypass, you need to create a database property
> >> named AllowBypassKey and set it to False. The proper way to create the
> >> property is shown in http://www.mvps.org/access/general/gen0040.htm at
> >> "The
> >> Access Web".
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
> >> news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5[ at ]microsoft.com...
> >> > you can also suppress the shift key bypass in the >>tools/startup<<
> >> > options,
> >> > untick allow access special keys. Be careful, not even you will be able
> >> > to
> >> > shift bypass the opening database though and you should retain a master
> >> > copy
> >> > on which the option is not set. This option is best used on front end
> >> > back
> >> > split databases where the front end issued to the users has this option
> >> > unticked, your copy doesn't.
> >> >
> >> > For Access 2007, this option can be found from clicking the windows
> >> > globe,
> >> > top left of the open database screen, select Access Options at the
> >> > bottom
> >> > of
> >> > the popup menu, select current database and set or unset the options
> >> > you
> >> > want
> >> > to allow the users to be able to access on the form you use as the
> >> > startup
> >> > form. The startup form is also nominated in this area.
> >> >
> >> > However, if you have disallowed menus, I would have thought you would
> >> > have
> >> > been using this area so perhaps I'm barking up the wrong tree as some
> >> > say????
> >> >
> >> > Regards
> >> > --
> >> > Advice to Posters.
> >> > Check your post for replies or request for more information.
> >> > Consider providing some feed back to the response you have recieved.
> >> > Kindest Regards Mike B
> >> >
> >> >
> >> > "tracktraining" wrote:
> >> >
> >> >> Hi All,
> >> >>
> >> >> Can anyone tell me how to suppress the SHIFT key bypass?
> >> >>
> >> >> Thanks,
> >> >> Tracktraining
> >> >> --
> >> >> Learning
> >>
> >>
> >>
>
>
>
Re: suppress SHIFT key
"Klatuu" <david.hargis[ at ]realpage.com> 11/14/2008 8:57:35 PM
Correct

"tracktraining" <tracktraining[ at ]discussions.microsoft.com> wrote in message
news:743E694A-77F1-4B94-A010-BF0AA607EACE[ at ]microsoft.com...
[Quoted Text]
> by the way, the suppress SHIFT code will only affect the db that I have
> the
> code in correct? it will not affect MS Access?
>
> -Tracktraining
> --
> Learning
>
>
> "Klatuu" wrote:
>
>> Actually, this should enhance your confidence.
>>
>> I am confident that if I post something that is incorrect, Doug will
>> politely and correctly straighten me out. <g>
>>
>> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
>> news:7E44F7EF-574C-4381-B630-0F8509618E87[ at ]microsoft.com...
>> > You know something Douglas, you are absolutely right, I tried it on a
>> > spare
>> > database I have, I have thought that not allowing Special Keys
>> > prevented
>> > the
>> > shift key option for some time. However, I normally test before posting
>> > so
>> > I
>> > guess I ought to re-start that before replying. Confidence now in
>> > tatters.
>> >
>> > Thanks for putting me right though.
>> >
>> > Cheers, have one on me.
>> >
>> > Mike B
>> > --
>> > Advice to Posters.
>> > Check your post for replies or request for more information.
>> > Consider providing some feed back to the response you have recieved.
>> > Kindest Regards Mike B
>> >
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> >> I don't believe that's correct, Mike.
>> >>
>> >> To suppress the shift key bypass, you need to create a database
>> >> property
>> >> named AllowBypassKey and set it to False. The proper way to create the
>> >> property is shown in http://www.mvps.org/access/general/gen0040.htm at
>> >> "The
>> >> Access Web".
>> >>
>> >> --
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no e-mails, please!)
>> >>
>> >>
>> >> "MikeJohnB" <MikeJohnB[ at ]discussions.microsoft.com> wrote in message
>> >> news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5[ at ]microsoft.com...
>> >> > you can also suppress the shift key bypass in the >>tools/startup<<
>> >> > options,
>> >> > untick allow access special keys. Be careful, not even you will be
>> >> > able
>> >> > to
>> >> > shift bypass the opening database though and you should retain a
>> >> > master
>> >> > copy
>> >> > on which the option is not set. This option is best used on front
>> >> > end
>> >> > back
>> >> > split databases where the front end issued to the users has this
>> >> > option
>> >> > unticked, your copy doesn't.
>> >> >
>> >> > For Access 2007, this option can be found from clicking the windows
>> >> > globe,
>> >> > top left of the open database screen, select Access Options at the
>> >> > bottom
>> >> > of
>> >> > the popup menu, select current database and set or unset the options
>> >> > you
>> >> > want
>> >> > to allow the users to be able to access on the form you use as the
>> >> > startup
>> >> > form. The startup form is also nominated in this area.
>> >> >
>> >> > However, if you have disallowed menus, I would have thought you
>> >> > would
>> >> > have
>> >> > been using this area so perhaps I'm barking up the wrong tree as
>> >> > some
>> >> > say????
>> >> >
>> >> > Regards
>> >> > --
>> >> > Advice to Posters.
>> >> > Check your post for replies or request for more information.
>> >> > Consider providing some feed back to the response you have
>> >> > recieved.
>> >> > Kindest Regards Mike B
>> >> >
>> >> >
>> >> > "tracktraining" wrote:
>> >> >
>> >> >> Hi All,
>> >> >>
>> >> >> Can anyone tell me how to suppress the SHIFT key bypass?
>> >> >>
>> >> >> Thanks,
>> >> >> Tracktraining
>> >> >> --
>> >> >> Learning
>> >>
>> >>
>> >>
>>
>>
>>


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net