Results 1 to 4 of 4
  1. 04-25-2013, 05:39 AM #1
    msasan1367
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60

    duplicate error

    this is my program:


    Database9.zip

    I want
    1- duplicate error when name + family + telephone is same

    2- duplicate error when accountno is same
    Reply With Quote Reply With Quote
  2. 04-25-2013, 06:21 AM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Research unique index

    Make a unique index for

    a) name + family + telephone and
    b) accountno
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
  3. 04-25-2013, 07:47 AM #3
    msasan1367
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60
    Quote Originally Posted by orange View Post
    Research unique index

    Make a unique index for

    a) name + family + telephone and
    b) accountno
    I don't find any useful things, please give me link
    Reply With Quote Reply With Quote
  4. 04-25-2013, 01:11 PM #4
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    For general approach http://en.allexperts.com/q/Using-MS-...alue-check.htm


    For a similar request previously see
    https://www.accessforums.net/databas...ers-30927.html
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Key Autonumber is too low - getting duplicate error
    By TedT in forum Access
    Replies: 4
    Last Post: 02-13-2012, 08:33 AM
  2. Error on entering duplicate value
    By anwaar in forum Programming
    Replies: 3
    Last Post: 09-02-2011, 01:25 PM
  3. Duplicate Entry Error
    By Dee300 in forum Forms
    Replies: 3
    Last Post: 08-16-2011, 07:29 PM
  4. Duplicate Check code with Run-Time error '3079'
    By viper in forum Programming
    Replies: 5
    Last Post: 10-18-2010, 10:12 AM
  5. Need help on error : Changes requested to table not successful coz duplicate value
    By cwwaicw311 in forum Access
    Replies: 0
    Last Post: 03-16-2010, 08:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums