Thanks Graham,
---In MS_Access_Professionals@yahoogroups.com, <graham@...> wrote :
Hi Sarah
It sounds like somewhere in your database code, one of the following commands is being executed:
DoCmd.SetWarnings False
or Application.SetOption "Confirm Record Changes", 0
You can set the option the way you want it by executing this command when the database opens:
Application.SetOption "Confirm Record Changes", 1
However, you should really track down where the warnings/confirmation is being turned off, and make sure that the same code that turns it off turns it on again when it exits.
Best wishes,
Graham Mandeno [Access MVP since 1996]
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 29 October 2015 15:45
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Confirm Record Changes
I have set 'Confirm Record Changes' in my database options. But everytime I close the database, I loose the setting.
I need this setting, because I want to warn users when they are deleting records and without this setting, the 'BeforeDelConfirm' event does not execute.
What am I doing wrong?.
Sarah
Posted by: sarahk@schemesoftware.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar