Recent content by Philyn Gwee

Thanks for sharing that it happened to you too. I had to create the single-table query to fix the issue only in Dec 2019. Before that it was working fine. Ah.. I understand the role idea you shared. Will see if we could improve the database using this method in future. Thanks!

Really not sure, nothing has been changed. I have checked but could not find what is the problem. It is a mystery that I am still trying to solve.

Thanks!

Hi thank for your reply. I have multiple tables as different people are given rights to access each branch's records. The tables are uploaded and shared in SharePoint with the relevant people I need to share with in each branch. I have several of such qrytbl_Staff_. These are queries not...

Hi thanks for your reply. I did a debug but nothing shows up but yet it is not updating the field. Different people are given rights to access each branch's records. The tables are uploaded and shared in SharePoint with relevant people I need to share with in each branch.

Hi I am new here. I am trying to see what is the problem with my database. One of the Update statement does not seem to be working anymore (I realised it was since Dec 2019). I am not sure what happened as I did not make any changes to it. Hope someone could point me in the right direction...

Hi I am new here. I am not trained in any coding or programming whatsoever. But I have something which I need to work on as part of my job. Now I am facing some issues and trying to troubleshoot some problems in my access database. Hope to learn from the expert community here. I have just...