Anytime you have unresolved issues in your query or SQL command, the statements will be not updatable. Try not making your queries and SQL so complicated when intending to use them to update data.
You could run a query to obtain your data, then use VBA variable fields to move the data from the query to your Update command only updating the table, not a query. Just one idea. There are a thousand ways to do it I'm sure...
Buk1tH3d
Last Activity: Jan 8 '20, 09:27 PM
Joined: Dec 5 '19
Location: Richardson, TX
-
It appears you have relationships in your recordsource query that cannot be resolved when you click in the combobox. Try reworking your relationships in your query. Try to make your tblNames your primary table and other tables are joined using "left join" which is the #2 choice in the join properties. That might work for you.Leave a comment:
-
This is a very basic design code for what your asking for... you would just use "MovePrevio us" to get to the previous record and get your previous value in the recordset. Hope this gets you close enough to work the rest out on your own.
...Code:Dim rst As Recordset Dim strSQL As String strSQL = "Select * From [Tbl] Where (criteria)" Set rst = CurrentDb.OpenRecordset(strSQL,Leave a comment:
-
You could try creating a brand new Access 2010 application on a 32 bit machine. Then copy the objects out of the 64 bit application to the 32 bit application. You may have some modifications to make in your code as there may be some code/features that 2010 application can not include from the newer application. But it should be a short rework. I have never done this, but this would be my approach to the problem. Good luck.Leave a comment:
No activity results to display
Leave a comment: