Prohibit record navigation

[John]

Hi

I need to block user from moving away from a record using any of
First/Last/Prev/Next/New Record or any other way IF the record has not been
saved, and displaying a message to the effect "Please finish editing". If
however the user has explicitly saved the record using save from the access
menu then allow to move from record. How do I achieve this via code?

Thanks

Regards

[pietlinden]

One way is to set the Required property of all the fields in the
underlying table to True. Then the user won't be able to leave the
record without filling out all the fields.

[Bob Quintal]

"John" <Jo**@nospam.infovis.co.uk> wrote in
news:Pq********************@pipex.net:

Hi

I need to block user from moving away from a record using any
of First/Last/Prev/Next/New Record or any other way IF the
record has not been saved, and displaying a message to the
effect "Please finish editing". If however the user has
explicitly saved the record using save from the access menu
then allow to move from record. How do I achieve this via
code?

Thanks

Regards

First, let me suggest a better way. In the BeforeUpdate of your
form, you need to put validation statements for each control
that is required. If it fails the test, cancel the update, and
give your error message.

example:
if isnull(me.lastname) then
cancel = true
msgbox "Last Name is a required Field." & vbnewline _
& "You must enter a last name!, vbOkOnly
end if

To do what you want, you must do exactly the same things, and
also remove the built-in navigation controls from the form,
replacing them with your own. You would also need to enable and
disable these controls based on the status of whether the record
was dirty (had unsaved edits) or not.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[John]

Problem is not so much to fill all fields but to discourage moving to
another record by mistake by pressing one of the navigation buttons and then
not being able to find the original record or worst overwrite over an
exiting record. We get a lot of temp staff who need to enter their own info
and they tend to make a lot of mistakes hence the need to restrict. However
if the record has been explicitly saved buy the user then it is an
indication that user knows that he/she has finished. In which case they are
allowed to navigate.

Thanks

"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:Xn**********************@66.150.105.47...

"John" <Jo**@nospam.infovis.co.uk> wrote in
news:Pq********************@pipex.net:

Hi

I need to block user from moving away from a record using any
of First/Last/Prev/Next/New Record or any other way IF the
record has not been saved, and displaying a message to the
effect "Please finish editing". If however the user has
explicitly saved the record using save from the access menu
then allow to move from record. How do I achieve this via
code?

Thanks

Regards

First, let me suggest a better way. In the BeforeUpdate of your
form, you need to put validation statements for each control
that is required. If it fails the test, cancel the update, and
give your error message.

example:
if isnull(me.lastname) then
cancel = true
msgbox "Last Name is a required Field." & vbnewline _
& "You must enter a last name!, vbOkOnly
end if

To do what you want, you must do exactly the same things, and
also remove the built-in navigation controls from the form,
replacing them with your own. You would also need to enable and
disable these controls based on the status of whether the record
was dirty (had unsaved edits) or not.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[pietlinden]

In that case, you could put a messagebox in your code in the
BeforeUpdate <?> or the last event that fires in the form before going
to the next record or closes the form. If you don't want to
move/close, set Cancel=True and pop up a messagebox alerting the user.

[rkc]

John wrote:

Problem is not so much to fill all fields but to discourage moving to
another record by mistake by pressing one of the navigation buttons and then
not being able to find the original record or worst overwrite over an
exiting record.

The safest way is to not allow edit/entry in the same form
that is used to browse records. Enter/edit records in another
form bound to a single record or opened for new entry only.

[Bob Quintal]

"John" <Jo**@nospam.infovis.co.uk> wrote in
news:xO******************************@pipex.net:

Problem is not so much to fill all fields but to discourage
moving to another record by mistake by pressing one of the
navigation buttons and then not being able to find the
original record or worst overwrite over an exiting record. We
get a lot of temp staff who need to enter their own info and
they tend to make a lot of mistakes hence the need to
restrict. However if the record has been explicitly saved buy
the user then it is an indication that user knows that he/she
has finished. In which case they are allowed to navigate.

Thanks
My usual design for the user interface involves a continuous
form that's read only, showing the major details of each record.
The form has two buttons, "Add new" and "Edit This". Clicking on
these buttons open single record forms with no navigation
controls. Each has a "Save and Exit" button, and a "Cancel and
Exit" one. Even your average LUSER can figure out operation
easily, and it overcomes the problem you have. I never let the
user edit a record in a continuous form (*), and I do not ever
let them create a new record in a continuous form.

(*)except in very special circumstances, like a form with
checkboxes to select records for further processing.

"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:Xn**********************@66.150.105.47...

"John" <Jo**@nospam.infovis.co.uk> wrote in
news:Pq********************@pipex.net:

Hi

I need to block user from moving away from a record using
any of First/Last/Prev/Next/New Record or any other way IF
the record has not been saved, and displaying a message to
the effect "Please finish editing". If however the user has
explicitly saved the record using save from the access menu
then allow to move from record. How do I achieve this via
code?

Thanks

Regards

First, let me suggest a better way. In the BeforeUpdate of
your form, you need to put validation statements for each
control that is required. If it fails the test, cancel the
update, and give your error message.

example:
if isnull(me.lastname) then
cancel = true
msgbox "Last Name is a required Field." & vbnewline _
& "You must enter a last name!, vbOkOnly
end if

To do what you want, you must do exactly the same things, and
also remove the built-in navigation controls from the form,
replacing them with your own. You would also need to enable
and disable these controls based on the status of whether the
record was dirty (had unsaved edits) or not.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com