Hi Bill,
I often create unique indexes too -- the unique index prevents duplicates during batch appends, but I don't use it as a way to inform the user of anything
Use the form BeforeUpdate event to do validation and issue friendly messages.
Warm Regards,
Crystal
Microsoft MVP
remote training and programming
www.AccessMVP.com/strive4peace
www.YouTube.com/LearnAccessByCrystal
www.YouTube.com/LearnByCrystal
* (: have an awesome day :) *
________________________________
From: Bill Singer <Bill.Singer@at-group.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, May 17, 2012 12:18 PM
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