If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

vb and access

banbutcher · 2005-02-14 18:32:45

is there any way of checkin for duplicate records in vb when i try add another one? i need it: if a song already exists then msgbox else DBMusic.Recordset.Update but i dont know how to do it! any help will not go unnoticed!! Cheers

Options

14-02-2005 7:32pm

#1

banbutcher

Registered Users Posts: 483 ✭✭

Join Date: April 2002

Posts: 371

is there any way of checkin for duplicate records in vb when i try add another one?

i need it: if a song already exists then msgbox else DBMusic.Recordset.Update
but i dont know how to do it!
any help will not go unnoticed!!
Cheers

0

Comments

Options
#2 14-02-2005 9:44pm
aidan_walsh

Closed Accounts Posts: 17,208 ✭✭✭✭

Join Date: February 2003

Posts: 15589

Why not run a Select with the entered details and make sure that 0 records are returned.

Is this not a better question for the Programming board?

0
Options
#3 15-02-2005 1:56am
Spunj

Registered Users Posts: 437 ✭✭

Join Date: July 2001

Posts: 381

Been a while since I have used Access but you shoould be able to set up a Unique index made up of Song Name, Artist, Album, Year (or whatever makes a song unique in your db) and then just catch the error that access will throw and handle it gracefully.

That should save you soing a select query before every insert.

0
Options
#4 15-02-2005 10:18am
Seth Brundle

Moderators, Politics Moderators Posts: 39,933 Mod ✭✭✭✭

Join Date: April 2003

Posts: 38907

This thread is running concurrently in two forums but I'll reply to the busier one!

Anyway, open one recordset to check if the value exists. If rs.eof then run the insert statement, otherwise display some kind of message to the user.

Also, Im not sure what way you plan on operating this (does the user type in the name of a song?) but it is possible to have the same song listed with one incorrectly spelled!

0