Two questions:
1) I have a scheduling application (Access 2002) that allows multiple
staff members to edit notes on their meetings and appointments from
their offices. A receptionist views a limited dataset of all of their
appointments and changes the status of an appointment to "Show" as
clients come in the door. She keeps a form open all day that lists that
day's appointments for all staff in chronological order.
Once in a while, while a staff person is editing a record of an
appointment, the receptionist changes the appointment status (using a
button on the form, which runs some code to modify the field). When the
staff person tries to save their notes, Access warns them that someone
else has changed the record. Most of the time, they click the wrong
button and lose their notes...
Is there a way to prevent the receptionist from changing the
appointment record if it is currently being edited by one of the staff?
in Advanced options:
"Default record locking" is 'no locks'
"Open database using record level locking" is checked
2) When I run the built in Access spell checker on a form it runs
through to the next record in the dataset for the form. Is there a way
to keep the spell checker from jumping to the next record?
Thanks in advance!
Jim