sql server programming: Check for Duplicate values in Access -- sql server programming

RE: Check for Duplicate values in Access

R.D
10/23/2005 12:24:02 AM

Hi
First of all, This is not the right forum because there is a dedicated forum
for access.
well. Use primary key (SOME THING LIKE SELECT COLUMN WHILE DESIGININGG AND
RIGHT CLICK SELECT PRIMARY KEY) in access on the column so that it will
prevent and throws an error. you can customise your error using VBA.

You have to use VBA because you are not using SQL SERVER 2000

--
Regards
R.D
--Knowledge gets doubled when shared

[quoted text, click to view]

RE: Check for Duplicate values in Access

ML
10/23/2005 4:38:02 AM

Why are you making your users think of unique values? Why would any user care
what number his job is given?

Use a column constraint and design a function that will automatically
generate unique values for the job column. You sound like a crappy ISP -
designed to serve millions of users, yet each of them must create his/her own
*globally unique* username in order to create a valid account. A total waste
of time.

Re: Check for Duplicate values in Access

Chris2
10/23/2005 8:12:18 AM

[quoted text, click to view]
Hi, I'm creating a database that needs to check a value in a text
field
called JobCreate in a form called frmJobCreated against a table called
tblJobCreated which has a whole list of job numbers in a field called
JobNo, then come back with a message telling the user if there is a
duplicate value...any help would be greatly appreciated,,thanks,
Fraser

Fraser,

Pleaes try reposting your above message in *one* of the following
newsgroups:

comp.databases.ms-access
microsoft.public.access.forms
microsoft.public.access.formscoding

Sincerely,

Chris O.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.