Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    43

    Unanswered: Query - Duplicated Number

    Morning All(Or Afternoon\Evening)

    In my db form i wish to have a warning flash up when a user enters a reference number which has already been used.

    How do i do this?

    Thanks for any help.

  2. #2
    Join Date
    Feb 2004
    Posts
    43
    Doh! now sorted.

  3. #3
    Join Date
    Feb 2004
    Posts
    199
    what do you need really just warning or restriction, to do restriction easy, just put the field you need to prevent from duplicates in indexes with NO DUPLICATES option, if you need only warning, you'll need a little bit complex coding (depending on your application structure)
    MDB, ADP <-> MS SQL + VBA, ADO & RDO, .NET, Oracle, Java/Jsp.

Posting Permissions

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