Results 1 to 4 of 4
  1. #1
    visidro is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2013
    Posts
    23

    Duplicate a record

    I am having trouble duplicating a record on a form.


    It gets tripped up on the phone number field ?????

    The phone field has an telephone input mask
    The error message is:

    "The value you entered isn't appropriate for the input mask '99/99/0000;0_' specified for this field"

    Help please with any suggestions
    victor

  2. #2
    Kennertoy is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    29
    Does the Table telephone field in design have the - 'Indexed - (Yes - No Duplicates)' - flagged? Change to duplicates OK., and try it.

  3. #3
    visidro is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2013
    Posts
    23
    No that didnt help, still error

  4. #4
    visidro is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2013
    Posts
    23
    Actually ... if after the error I press the ,<esc> key ..... it works.

    I guess we can live with the error/warning message

    thank you

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 03-09-2013, 10:39 AM
  2. Goto Record when Duplicate Record Exists
    By rlsublime in forum Programming
    Replies: 13
    Last Post: 03-22-2012, 03:46 PM
  3. Replies: 5
    Last Post: 03-02-2012, 08:58 PM
  4. Duplicate last record to next record in form
    By jdhaldane in forum Forms
    Replies: 4
    Last Post: 12-17-2010, 04:22 PM
  5. If duplicate record, go to original record
    By BigBear in forum Forms
    Replies: 2
    Last Post: 10-06-2010, 02:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums