Search results

  1. S

    Simple update query - odd behavior

    Thank you both for your help! How do I give "Thanks" on here?
  2. S

    Simple update query - odd behavior

    Ah - @isladogs - I forgot about that. It one of two columns that comprise the primary key. Maybe that is it...
  3. S

    Simple update query - odd behavior

    Yeah, it doesn't get updated. Only the 36 does. I ran it was a new query (which I hadn't thought of doing before so thank you for that trouble-shooting tip). It gives this error: Microsoft Access didn't update 0 field(s) due to a type conversion failure, 1 record(s) due to key violations, 0...
  4. S

    Simple update query - odd behavior

    I think there is something really obvious I am missing but I can't figure it out - I've been teaching myself vba and I'm still pretty novice. I am trying to update a table using a sql query in vba and I'd like to update multiple rows at the same time with client IDs that are within some vector...
  5. S

    scroll to top of a multi select listbox

    I am having the same issue and have not yet found a solution.
Back
Top Bottom