Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem with Append Query (validation rule violati (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    When I run the following query I get Can

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Problem with Append Query (validation rule violati (a2k (9.0.6926) SP-

    Remove fields one by one from the query until the problem disappears. Then you'll know which is the offending field.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Append Query (validation rule violati (a2k (9.0.6926) SP-

    There are 215 records
    When I run the query the first it finds problems with 165 records

    When I remove the first field in the query DlTranCode: Left([strCodeDTC],1) it runs and finds problem with 2 records

    When I remove the following it runs OK
    VMo: Format([dtmVaccinDate],"mm")
    VDy: Format([dtmVaccinDate],"dd")
    VCn: Left(Format([dtmVaccinDate],"yyyy"),2)
    VYr: Mid(Format([dtmVaccinDate],"yyyy"),3,2)
    I changes the above destination fields to Allow Zero Length and the query worked

    I can

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Problem with Append Query (validation rule violati (a2k (9.0.6926) SP-

    It's too much work. Sorry.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Problem with Append Query (validation rule violati (a2k (9.0.6926) SP-

    The fact that changing your query to allow zero length suggests you may have records with null dates and possibly null.strCodeDTC.
    Charlotte

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Append Query (validation rule violati (a2k (9.0.6926) SP-

    I changed all the destination fields to Allow Zero Length and the query worked

    Thanks, John

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Problem with Append Query (validation rule violati (a2k (9.0.6926) SP-

    My bet is that your source table has zero-length values in some fields. This will be true if you imported it. You will have these even if the table says you can't! But when you try to append to another table, you get the error.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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