Recent content by swav_one

Yessss!! RoyVidar's suggestion worked. I had a space in rsJobs.find "JobReference= '" & find & "'" A small success - I wonder for how long ... Thanks for your help - really appreciated. I did change the name of the field from "memo" to "extra". Some of your suggestins did not work or I...

Unfortunatelly it does not work. Oh and by the way, the debuger highlights this line: rsJobs.Fields("extra") = rsJobs.Fields("extra") & "My text here"

Hi All, I've put together a piece of code that allows me to modyfy Access reccords from my Excel tracking sheet. The code takes a refference number from a cell in Excel and then finds this refference no in Access to modify records linked to it. It all works fine in my dummy database, but when...