Search results

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

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

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...

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...

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