Forum Discussion

kiefertrey's avatar
kiefertrey
Copper Contributor
Jun 16, 2021

Use verification rule to stop input of duplicate values in a field of another form?

Hello all,   I am new here and new to Access. I have created a database for my employer to track job records. Each job has a unique job number. I tried to use unique indexes to stop duplicate value...
access
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Jun 17, 2021

kiefertrey Do you not have permissions to see the linked SharePoint lists which are tables in your Access FE?

It's a over an hour long, but Albert Kallal's recent presentation might be useful here. I believe it addresses the issue of modifying SP lists, but it's very useful anyway. Have a look when you have time.

  • Karl_Donaubauer's avatar
    Karl_Donaubauer
    MVP
    Jun 17, 2021

    Hi,

     

    Just to add some details to George's comment on the Sharepoint design changes:

     

    If you have the permissions to do changes on the Sharepoint list, you could set the field to accept only unique values. This is of course possible in the column settings in Sharepoint itself but as Albert showed in the mentioned video even in Access. You can open the linked Sharepoint list in datasheet view, choose the Fields tab in the ribbon and change the Unique setting for the column.

     

    In case the Fields tab is greyed out for the Sharepoint list/table you first have to check the option to use the cache format that is compatible with Access 2010 and later in File - Option - Current Database - Caching Web Service and Sharepoint tables.

     

    Servus
    Karl
    *********
    http://AccessDevCon.com
    https://www.donkarl.com

Resources