Doyce-
Excellent idea also. But if she wants to catch it on a form before Access spits
out its obtuse error message, then Before Update is the way to go.
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/
(Nashua, NH)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of dnwinberry
Sent: Tuesday, March 06, 2012 12:20 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Duplicates in a field
Hi Katrina,
Yes, in the design view of your table, set the index property for the citation
number to "Yes, No Duplicates."
Doyce
--- In MS_Access_Professionals@yahoogroups.com, ka0t1c_ang3l <no_reply@...>
wrote:
>
> Hello everyone!
>
> I'm creating a new database for our Public Safety Department. In my database
I have a Citation Number that is issued. Is there a way to code this field to
prompt me that the number entered has already been used to avoid duplicate
numbers being issued?
>
> Any help is appreciated!
>
> Thanks!
>
> Katrina
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar