Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2006

    Unanswered: Error 3022 help...

    I have developed an app in vb6 that checks a table in Access 2.0 for missing dates and times. I can find the times, but when i try to add the missing times to the table i get the 3022 message saying about duplicate values etc. I am using DAO etc. etc.

    Normally for us to add data to this table we create the times in excel copy them then Paste Append into access.

    How can I get around this.

    The code I have is as follows
    with rsFill
      .fields("Time") = someVar
      .fields("Id") = someVar2
      .fields("Value") = someVar3
    end with
    can anyone help me???
    Last edited by loquin; 10-03-06 at 14:54.

Posting Permissions

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