|
Home > Archive > MS Access database support > July 2005 > Help. How to enable the confirmation of save on changing table/query?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help. How to enable the confirmation of save on changing table/query?
|
|
| swingingming 2005-07-26, 1:24 pm |
| Hello, I don't know what I did in settings. Now any changes I made will
go saved. And sometimes I am just testing things out. Where can I
enable the confirmation?
Thanks,
ming
| |
| Larry Linson 2005-07-27, 8:25 pm |
| You didn't do anything wrong. Autosaving is just the way Access works --
save when you leave the main form to enter a subform, when you move to a
different record on the same form, or when you close the form. If you want
to intercept and require a confirmation, you write VBA code in the
BeforeUpdate event of the form in which you edit the record. If you are
editing a table or query directly in datasheet mode, you are out of luck.
Larry Linson
Microsoft Access MVP
"swingingming" <ming.mge@gmail.com> wrote in message
news:1122398142.774051.7490@g49g2000cwa.googlegroups.com...
> Hello, I don't know what I did in settings. Now any changes I made will
> go saved. And sometimes I am just testing things out. Where can I
> enable the confirmation?
> Thanks,
> ming
>
|
|
|
|
|