Search results

Ok, so I guess that as my query uses JOIN I am not able to modify Master_Table from that query. Then I should find another workaround to refresh that table from dates coming from ADHOC table. Thanks for all your help.

Record type = Dynaset (inconsistent updates). could be not possible to edit from the query because there is INNER JOIN between 2 tables?

Hello pbaldy, thanks for the quick reply. No, I am trying to edit a value in Master_Table. The error appears in the following line: "rsd.Edit <--- rsd![Run at Rate Dt] = rsd![ADHOC_Run at Rate Dt] rsd.Update" Disregard the code under those lines, it is the same and I have to change in some...

I have 2 tables and from them I do a query called "Query_Dates". There, I created 4 calculated fields which compares fields of the two tables previously mentioned. What I am trying to do is everytime the calculated fields are equal to "Diff", gets the value from the second table (ADHOC) and and...

Hello All, I am quite new in access database programming. I have high knowledge in vba under excel, nevertheless, due to my job requirements, I am trying to develop new scripts and databases under Access platform. Hope I can help anybody from the knowledge acquired in this forum. Best.