Ask Experts Questions for FREE Help !
Ask
    aveary's Avatar
    aveary Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Oct 9, 2013, 04:01 PM
    Access Database
    Is there a way to flag information in an access database so that the same data cannot be input twice? I work with a vehicle control system but some of the vins are showing up more than once. I think more than one person in the office may have entered the same paperwork or two people registered the same vehicle causing it to show up twice... trying to prevent this from happening again.

    Thanks
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Oct 9, 2013, 04:26 PM
    Sure, In table design mode select the VIN field and set it to No duplicates.
    aveary's Avatar
    aveary Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Oct 9, 2013, 04:48 PM
    Awesome! Thanks so much.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Access Database [ 5 Answers ]

I keep getting this error message, what should I do? I tried to delete the record where the error appears but the system won't allow me to. (The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.)

Inserting an aprostrophe into an Ms access database [ 2 Answers ]

Hi there, I have the ffg code so far, which inserts info into the database. But how do I go about inserting/ writing code to insert a surname like O'Reily (take not of the aprostrophe) into the database. Imports System.Data.OleDb Public Class Form1 Public cn As OleDbConnection ...

Using access create database [ 3 Answers ]

To all. I'm need you all help, how to using Microsoft access create a database. Sample like I want record all the stock in my database and how to using Html interface link to the database. :(

View more questions Search