Re: Closing a form - problem
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Sat, 16 Apr 2005 23:48:50 +0800
Paul, I agree with your frustration.
This has to be one of the worst bugs in Access, where is SILENTLY loses your
entry if you close the form when the record cannot be saved (e.g. required
field missing.) For a program that is supposed to save by default, just
losing people's data is totally unacceptable IHMO, but I cannot get MS to
fix this data-loss bug.
Once you know about the bug, it is easy enough to work around it: you must
explicitly save the record whenever you use the Close action/method on a
bound form. But this is crazy that 13 years after Access was first released,
it still has the same bug, unfixed.
More info:
http://allenbrowne.com/bug-01.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Paul Doree" <paul_doree@xxxxxxxxxxx> wrote in message
news:eNWMtppQFHA.2252@xxxxxxxxxxxxxxxxxxxxxxx
> Can anyone tell me why, if I close a form using the X box at the top right
> hand corner, the database table validation kicks in with warnings because
> I haven't filled in some required fields However, if I close the same
> form under the same circumstances via a close button (using docmd.close),
> no warnings appear and the record is not saved - not good practice for end
> users!
>
> Yours (frustrated)
>
> Paul
.
- References:
- Closing a form - problem
- From: Paul Doree
- Closing a form - problem
- Prev by Date: Closing a form - problem
- Next by Date: Re: Print then open new record
- Previous by thread: Closing a form - problem
- Next by thread: Using a Filter on a datasheet view
- Index(es):
Relevant Pages
|
