Search results

Eureka!!!! You pointed me in exactly the right direction. I had changed a couple of field names in the table that were referenced in the before-change macro. The mystery message has now gone away. Have a massive helping of good karma. I'm doing this work for a non-profit who will really...

Yes, our messages crossed. I poked around and found two places to see the before-change processing. I do not, however, see anything that looks questionable - not that I really know what I should be looking for. In addition, prior to my attempt to run the update mentioned above, I've never had...

A very long time ago, I added a before-change action to update a last-changed-date field. I can see this when I click Rename/Delete Macro on the Table Design tab - that is, it tells me one is there. For the life of me, I don't know how to get to that macro or find out what it's even named...

I have the following simple update statement in an Access (2021) query: UPDATE Patrons INNER JOIN PatronsWork ON Patrons.PatronID=PatronsWork.PatronID SET Patrons.Zip = PatronsWork.Zip; I've found numerous examples of update statements exactly like it on various web sites, and can think of no...