Finding Records using VB

[ShadowGrafix]

OK I'll try to explain correctly

Im using VB6

I have a book inventory program that currently holds names,etc.

I want to add a search to my program with a pop-up where i can enter a book name so i can see if that books currently exists in the database without the possibility of adding a second record.....

the database is quite large and i dont have time to screw with multiple records....

also if the book exist I want it to pull up that record as well

any help would be great

 

[jlgdeveloper]

Your code should look for duplicates automatically before adding new books, and if found, should alert the user.

What you have mentioned doing is very simple, you need to learn how to access your data.

Here is a primer on accessing data natively: faq222-2103 Jonathan Galpin

http://www.keen.com/categories/categorylist_expand.asp?sid=5215353&gid=0&pmode=0

 

[ShadowGrafix]

Ok it alerts me however I would like to do a search to see if it exists...

any code out there to do this?