If a value already exists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form "BatchTracking" with a field [FileName]. What I would like to
happen is when I put in a value that already exists, to have my own message
box show up with what I tell it to say, instead of microsofts default message
box. Is this possible?
 
Thank you very much, that is exactly what I was looking for.

Ofer Cohen said:
Check this link on "Preventing Duplicates from being entered - Database
Solutions for Microsoft Access"

http://www.databasedev.co.uk/duplicates.html
--
Good Luck
BS"D


Ryan said:
I have a form "BatchTracking" with a field [FileName]. What I would like to
happen is when I put in a value that already exists, to have my own message
box show up with what I tell it to say, instead of microsofts default message
box. Is this possible?
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking if record already exist 4
Table Default Values 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
how do I alert user (ASAP) if record already exists? 2
Enter Parameter Value in Access Form 0
How to replace duplicate entries in subform with correct reference ID 5
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Pause Subform 1

Back
Top