Security Issue

[Carl]

Due to very stringent security requirement, I need to disable the
[Shift]+[Tab] keystroke in a form used by certain employees to enter new
data. My major requirement is to prevent them from moving backward through
the records, in a form. I have already created a macro in the form to open
the form blank to create a new record, have hidden the record navigation
buttons, and have put the form in StartUp, hiding all feature but the form
inself.
Any thougts on disabling [Shift]+[Tab] will be greatly appreciated. I
recognize this to be a rather strange setup, but it is required under US
Government regulations to protect the privacy of the data in the database.
Thank you.
Carl

 

[Keith Wilby]

Due to very stringent security requirement, I need to disable the
[Shift]+[Tab] keystroke in a form used by certain employees to enter new
data. My major requirement is to prevent them from moving backward
through
the records, in a form. I have already created a macro in the form to
open
the form blank to create a new record, have hidden the record navigation
buttons, and have put the form in StartUp, hiding all feature but the form
inself.
Any thougts on disabling [Shift]+[Tab] will be greatly appreciated. I
recognize this to be a rather strange setup, but it is required under US
Government regulations to protect the privacy of the data in the database.
Thank you.
Carl

In that case I would suggest up-sizing to something like Oracle because
Access, even when fully secured, can be easily broken into by those in the
know.

Keith.
www.keithwilby.co.uk

 

[Pepper]

I have a similar problem and do not have the resources to spend the money on
Oracle.
Am I to assume that you can not disable Shift-Tab in Access forms?

Due to very stringent security requirement, I need to disable the
[Shift]+[Tab] keystroke in a form used by certain employees to enter new
data. My major requirement is to prevent them from moving backward
through
the records, in a form. I have already created a macro in the form to
open
the form blank to create a new record, have hidden the record navigation
buttons, and have put the form in StartUp, hiding all feature but the form
inself.
Any thougts on disabling [Shift]+[Tab] will be greatly appreciated. I
recognize this to be a rather strange setup, but it is required under US
Government regulations to protect the privacy of the data in the database.
Thank you.
Carl

In that case I would suggest up-sizing to something like Oracle because
Access, even when fully secured, can be easily broken into by those in the
know.

Keith.
www.keithwilby.co.uk

 

[Keith Wilby]

I have a similar problem and do not have the resources to spend the money
on
Oracle.
Am I to assume that you can not disable Shift-Tab in Access forms?

As far as I'm aware you can't but there are almost certainly other methods
of securing your data within the limitations of user-level security without
having to do so. For example, you can present certain users with a sub-set
of the data such that they can't see the records you don't want them to edit
.... or ... you could use a Boolean field and a bit of code to lock certain
records for certain users if you want them to be able to "look but not
touch".

Keith.
www.keithwilby.co.uk

 

[Dirk Goldgar]

Due to very stringent security requirement, I need to disable the
[Shift]+[Tab] keystroke in a form used by certain employees to enter new
data. My major requirement is to prevent them from moving backward
through
the records, in a form. I have already created a macro in the form to
open
the form blank to create a new record, have hidden the record navigation
buttons, and have put the form in StartUp, hiding all feature but the form
inself.
Any thougts on disabling [Shift]+[Tab] will be greatly appreciated. I
recognize this to be a rather strange setup, but it is required under US
Government regulations to protect the privacy of the data in the database.

Are you opening the form in Data Entry mode? You can set that as a property
of the form at design time, or you can explicitly specify it when you use
code or a macro to open the form. In Data Entry mode, the form opens to a
blank record, and users can only see records that they themselves entered in
the current session.

If you don't want users even to be able to see the records they've entered
in the current session -- which seems strange -- you can open the form in
Data Entry mode and use code in the form's AfterInsert event to requery the
form. That will prevent the user from ever seeing any record but the one
they are currently entering.

 

[Carl]

Thank you Keith and Dirk,

Setting the Data Entry was what was required by me.

Due to very stringent security requirement, I need to disable the
[Shift]+[Tab] keystroke in a form used by certain employees to enter new
data. My major requirement is to prevent them from moving backward
through
the records, in a form. I have already created a macro in the form to
open
the form blank to create a new record, have hidden the record navigation
buttons, and have put the form in StartUp, hiding all feature but the form
inself.
Any thougts on disabling [Shift]+[Tab] will be greatly appreciated. I
recognize this to be a rather strange setup, but it is required under US
Government regulations to protect the privacy of the data in the database.

Are you opening the form in Data Entry mode? You can set that as a property
of the form at design time, or you can explicitly specify it when you use
code or a macro to open the form. In Data Entry mode, the form opens to a
blank record, and users can only see records that they themselves entered in
the current session.

If you don't want users even to be able to see the records they've entered
in the current session -- which seems strange -- you can open the form in
Data Entry mode and use code in the form's AfterInsert event to requery the
form. That will prevent the user from ever seeing any record but the one
they are currently entering.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Pepper]

Very cool, thank you

Due to very stringent security requirement, I need to disable the
[Shift]+[Tab] keystroke in a form used by certain employees to enter new
data. My major requirement is to prevent them from moving backward
through
the records, in a form. I have already created a macro in the form to
open
the form blank to create a new record, have hidden the record navigation
buttons, and have put the form in StartUp, hiding all feature but the form
inself.
Any thougts on disabling [Shift]+[Tab] will be greatly appreciated. I
recognize this to be a rather strange setup, but it is required under US
Government regulations to protect the privacy of the data in the database.

Are you opening the form in Data Entry mode? You can set that as a property
of the form at design time, or you can explicitly specify it when you use
code or a macro to open the form. In Data Entry mode, the form opens to a
blank record, and users can only see records that they themselves entered in
the current session.

If you don't want users even to be able to see the records they've entered
in the current session -- which seems strange -- you can open the form in
Data Entry mode and use code in the form's AfterInsert event to requery the
form. That will prevent the user from ever seeing any record but the one
they are currently entering.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)