Hi,
I know that there are work arounds for getting a confirmation request before
updating records... however, this only works in a form with VBA code.
There is an option under Tools > Options > Edit/Find > Confirm Record Changes.
I saw many different versions of explanations of what it might do, but no
one seems to know what it does do. The tool tip text suggests that it would
pop-up a message box before updating a record. But it doesn't do that.
I have tried various things with this option checked/un-checked and can't
see any difference whatsoever.
Can anyone tell me (i.e., a MS developer that has access to the code) what
this does? or is it just a place holder for a function that was never
implemented?
In any case, the help text should be updated to reflect reality, there are
so many posts with people asking about this feature...
Thanks,
dgionet
Alex Dybenko - 26 Oct 2005 21:59 GMT
Hi,
this is response from other MVP - Karl Donaubauer:
The name of the option may be a bit misleading.
It refers to the messages that you get when you delete one or more
records or insert multiple records from the clipboard into a table,
query or form. "Do you really want to...delete/insert..." etc.
If the box is unchecked there are no such messages instead
the actions are executed silently.
HTH

Signature
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
> Hi,
> I know that there are work arounds for getting a confirmation request
[quoted text clipped - 21 lines]
> Thanks,
> dgionet
DGionet - 27 Oct 2005 13:54 GMT
Thanks. Microsoft should really consider updating the tool tip help text.
> Hi,
> this is response from other MVP - Karl Donaubauer:
[quoted text clipped - 32 lines]
> > Thanks,
> > dgionet