Results 1 to 2 of 2
  1. 09-10-2013, 10:36 PM #1
    Ruegen's Avatar
    Ruegen
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Validation Rule Violation

    I am getting Validation Rule Violation when doing an append on an old table - I'm guessing there are zero-length-strings somewhere in the fields and I'm guessing I have to convert those to null using an update query before I can append?



    Any suggestions?

    website moderator note: accidentally posted thread in wrong area
    Reply With Quote Reply With Quote
  2. 09-11-2013, 12:09 AM #2
    Ruegen's Avatar
    Ruegen
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Nevermind - sorted it
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Validation Rule Help!
    By confidego in forum Access
    Replies: 8
    Last Post: 07-20-2011, 12:54 PM
  2. cascading combobox and validation rule violation
    By AndycompanyZ in forum Forms
    Replies: 7
    Last Post: 06-22-2011, 12:13 PM
  3. Help with validation rule
    By Desstro in forum Programming
    Replies: 5
    Last Post: 02-27-2011, 08:05 PM
  4. Validation Rule
    By Megan in forum Access
    Replies: 1
    Last Post: 11-05-2010, 09:45 AM
  5. Validation Rule
    By smitstev in forum Access
    Replies: 5
    Last Post: 06-30-2009, 09: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
  •  

Forum Rules

Other Forums: Microsoft Office Forums