Search the Table for spacific name and count duplicates

Question

Dear Users

 

I have problem with this:

 

I have a TextBox and a Button in my Form1. ( my data base is Access 2003 ).

 

 

I want to:  Button when Clicked, it search for Example "employers" table and find what the user typed in TextBox.

 

For example: I typed "John Jobs" in TextBox, I want the button to search the Table "Employers" for a field with that name. and it my also there are duplicate data and it found 2 same data for "john jobs" so it count them and show them in message box:

 

Messagebox.Show("there are  (????)  "jon jobs" in your data Base" );

 

thank you 

 

 

Answer 1

There are lots of samples available here, how to use ADODB.RecordSet etc.. please do browse and try. If not working share your code, we will help you out. Another way of learning.