Can you control when the data is saved?

J

JHC

I created a form that allowes add and update. There are several combo box
controls. After a number of the records were added, users bring up the form
and for some reason fiddle/play with the combo box controls. This results in
the data being changed. And they don't seem to realize this is happening.

Is there a way to have Access avoid changing the record unless the user
overtly selects save (or say presses a button to save)?

Thanks.
 
T

Tom van Stiphout

On Wed, 5 Dec 2007 19:20:02 -0800, JHC <[email protected]>
wrote:

Yes.
One way is a trusted one, with very little recidivism: tar and
feathers. Really: users who "fiddle" with company data deserve as
much.

Other options include:
* In the Form_BeforeUpdate you could pop a messagebox "Are you sure
you want to save ...", vbYesNo, and upon No, set Cancel=True, or
perhaps even Me.Undo. As a well-behaving power user I would get tired
of that prompt real soon.
* Your form can have a button "I Feel Like Editing This Record", upon
which you set the Locked property of all controls to False. In the
Form_Current (fires when user scrolls to another record) you set them
back to Locked.
Note you can do this by looping over the Controls collection rather
than naming each control individually.

-Tom.
 
B

Bob J

Prevent More Than One User from Editing a Form Record>

1. Open the form in Design view.
2. Double click the form selector.
3. Click Data
4. Click Record Locks.
5. Click the down arrow that appears.
6. Click Edited Record.
(Careful - Clicking the Records Locks down arrow and then clicking All
Records will prevent all users including yourself from making data changes to
the forms data.)

To Lock Records in a Form>

1. Open the form in Design view.
2. Double click the form selector.
3. Click data.
4. Follow the steps for the Allow Additions, Allow Deletions, and Allow Edit
Properties.
* Click the property name.
* Click the down arrow that appears.
* Click - No.
--
Regards
Bob J
If advise given from anyone, solves problem or not, or if solved from
another source,post back & let us know.
Then we all benefit.
 
J

JHC

Bob J,

None of the responses were vary useful. I think people want to explore the
options and in doing so, update the data. This was done by a variety of
people. I was hoping for a solution that would prevent update of the DB
until the user overtlty indicated that the data should be saved (function
key, save button, something) rather than closing the dialog/form or scrolling
to another record.
 
Ð

Селезнева ÐаталиÑ

JHC said:
Bob J,

None of the responses were vary useful. I think people want to explore
the
options and in doing so, update the data. This was done by a variety of
people. I was hoping for a solution that would prevent update of the DB
until the user overtlty indicated that the data should be saved (function
key, save button, something) rather than closing the dialog/form or
scrolling
to another record.
Click to expand...
 
Top