Bill-
The only way to trap the error is to test for a duplicate in Before Update,
issue your own error message, and cancel the save. Why are you running an
Append query? If the user is entering the new data in a form bound to the
table, that shouldn't be necessary. I would need to know the structure of your
table (at least the key fields) to help you with the Before Update code.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Singer
Sent: Thursday, May 17, 2012 8:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Indexes
I have created a unique index on a table to prevent duplicate records from
being added,(you can't play two events at the same facility at the same
time) however the error message that comes up is not very user friendly. I
am wondering if there is a way to change that message?
The other option is to put a test and message box in the before update
property of the button that runs that append query that updates the table.
However this programming is a bit more difficult for me.
Thanks for steering me in the right direction.
Bill Singer
MN
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar