Crystal,
I may want to do this with a few more tables. Am I correct in understanding
that I will have to remove the PK as a unique index.
Bill Singer
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Thursday, May 17, 2012 1:48 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Indexes
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
<mailto:Bill.Singer%40at-group.net> >
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar