Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

check if data already exists in table

Status
Not open for further replies.
jono261970

jono261970

Programmer
Jun 28, 2002
182
GB
Hello,

I have written a small program to keep track of our static ip addresses. The only problem is that you can enter the same address twice. How can I tell VB to check the MS Access field for duplicates before it writes to the db.

cheers,

jono




A good fortune may forbode a bad luck, which may in turn disguise a good fortune.
 
Sort by date Sort by votes
Hi Jono,

Would it not be easier to set the field in the access db to not accept duplicates and then trap the returning error in VB, i assume this would work.

 
Upvote 0 Downvote
Hi Rivethed,

Thanks matey. Indeed it is much easier. DOH!


cheers,

jono



A good fortune may forbode a bad luck, which may in turn disguise a good fortune.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
Check if mobile number exists, with Api rest or other service. Possibile? 1
Replies
2
Views
513
sal21
sal21
sal21
  • Locked
  • Question
Strongm.... only for you - check if the customer have riceved the email 1
Replies
2
Views
445
sal21
sal21
sal21
  • Locked
  • Question
scraping table in web page 3
2
Replies
24
Views
4K
strongm
strongm
sal21
  • Locked
  • Question
scraping table dont work 2
Replies
7
Views
447
strongm
strongm
sal21
  • Locked
  • Question
NOT FOR ME, get value from table web
Replies
1
Views
237
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top