Recent content by Aboo
-
A
Query Not Visible When Connecting to Excel
Thx. How would I use your solution to my situation? -
A
Query Not Visible When Connecting to Excel
Yes it is in excel I am getting error. Any work sound in Access? -
A
Query Not Visible When Connecting to Excel
Thx. I changed it. SELECT Vehicles.VehicleID, Vehicles.[VIN Number], Vehicles.Make, Vehicles.Model, Vehicles.Year, Vehicles.[Price (JYP)], Vehicles.[Price (AUD)], Sum(tblExpenses.Amount) AS SumOfAmount, [Price (AUD)]+Nz(Sum([tblExpenses]![Amount]),0) AS [Est Cost], Vehicles.[Rec No]... -
A
Query Not Visible When Connecting to Excel
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... -
A
Forgot Nearly Everything
Many thanks. As a supplementary question is there an option to keep saving a back up of the database. I vaguely remember there was one. -
A
Forgot Nearly Everything
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... -
A
id is not an index in this table
Many thanks. I just gave up on this and created a new DB. Appreciate it. -
A
id is not an index in this table
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...