I have a query which I connected to the Excel and it was working fine. Recently I noticed that one field EstCost was not showing value for one field. So I changed it to the formula with NZ function. It works well in Access but the query is showing an error, (Expression Error, the key did not...
It is amazing what age does to you. At one stage I built full MS Access system for a large company which dealt with program management. After being retired and after a lapse of 5 years, when I needed to build a small system to deal with vehicle imports, I was completely blank. Occasionally...
I think I opened the same DB in W11 and W10 separately. I noticed this error only when I opened in W10. Tried to research and it looks pretty bad. So to save a few things, I managed to export everything except forms. I can open most objects but not forms. Issue is that worked fair bit on...