Access beginner: Have Access show prompt window when duplicate entry already exists

[ms3245]

I am not very familiar with Microsoft Access (my work computer says that it is Access 2007-2010 when the program is open). As such, my question may not even have a clear answer...

I have a table called "New App Tracking" , which is used to assign an ID number to each entry, and has several columns within in for 'Facility name' 'date received' and so on.

What I need (I don't know if this is possible) is for Access to prompt me with a pop up when an identical entry for the field "Facility name" has been detected. I don't have any forms set up, just a stand-alone table. I have a query that I can access that shows duplicates, but I need it to prompt me when I am making entries into the table as soon as it picks up another similar entry (so that duplicate applications are avoided immediately).

I have no idea how to achieve this, and I have read through multiple threads to no avail, as I don't know where I need to be going to input the coding (nor do I have the complexity of the setup existing in my database to have the code work).

[ms3245]

I resolved my own question!

[PhilOfWalton]

I think not.
I appreciate you are a beginner and I know many of the contributors to this forum rant on about Normalisation. You must get to grips with it.
You are looking at your table as if it were an Excel sheet.

You need 2 tables, one for your faculties, and one for your Application tracking.

With the TblFaculties, you need

TblFaculties
    FacultyID      AutoNumber   Primary Key
    FacultyName    Text         Indexed(No Duplicates)
 

The NoDuplicates does what it says on the tin

The TblAppTracking will look something like this

TblAppTracking 
    AppTrackingID      AutoNumber   Primary Key
    FacultyID          Number Long  Foreign Key
    DateReceived       Date
    ...
    ...
 

Then set up a relationship between the 2 tables and enforce referential integrity.
Your query based on the 2 tables will appear to show the FacultyName on every line, but in fact it is there only once.

The other thing is that you need to get to grips with forms.
Wearing the hat of a User, rather than a programmer, you should NEVER be able to see table, and rarely see queries. Only Forms for inputting & viewing data & reports

Phil