Duplicate Records Using Access 2000

[Guest]

I have a database for people to book on to courses that we run. One of the
tables is course Instances eg Course name Course Date Course Time etc. I
would like to create a Macro that I can add to a button that willl check to
see if the course already exists in the table is there a query I can create
that will check the table if the course already exists I will ge an error
message but if the course does not exist I will move on to add the next
record Hope this makes sense.

Thanks in advance for any help you may be able to give.

 

[Guest]

Dear JOPO

Thanks for your reply. I am a bit of a novice at this but I am not trying
to pick a course from a list I just want to add new courses and to avoid
adding the same course on the same day at the same time based on the date and
time.

PS I think I can use your advice somewher else on the database.

 

[Jeff Boyce]

Another way to approach this, rather than having the user enter all the info
and THEN be told the course already exists, would be to use a combo box to
list all the available courses.

Let the user select the one desired or, using the NotInList event, prompt
them to enter a new one.

JOPO (just one person's opinion)

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/