Rabu, 28 Oktober 2015

RE: [MS_AccessPros] Confirm Record Changes

 

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: "Graham Mandeno" <graham@mandeno.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar