John,
That is a good point. I concede to the expert.
Doyce
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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