Search results

Yes; I have changed the file names back to their originals and they do hold for awhile. However; eventually they suddenly flip back to expressions.

This update query fires directly after an append query which copies the record to a history table. Perhaps the first query has the table occupied when the update query attempts to run.

I have a simple update query that sets the existing values of all the fields in a specific record in a table to Null. However; for some reason the query replaces the field names with expressions such as Exp1:MyFieldName1, Exp2:MyFieldName2, Exp3:MyFieldName3, etc. Can anyone explain why this...

I started working with Microsoft Access 2002 and VBA in 2002. As office administrator for an independent accounting firm with over 65 staff members and with no programming experience the learning curve was long. The learning never ends of course. I retired in April of this year but continue...