Recent content by poflynn

Solution The query is by nature read only but... After much hunting here is the solution Set rst = New ADODB.Recordset rst.CursorLocation = adUseClient rst.Open "SELECT * FROM EqptListQuery", CurrentProject.Connection, adOpenKeyset, adLockOptimistic rst.ActiveConnection =...

I'm not sure how to achieve this. Essentially. I have a table that contains a column whose entries become columns. the inital table is an output from Autocad an as such can't be changed. I am trying to present the data in a more user-friendly, useable format Phill

I have a query that by nature is read-only. This data is used to populate a form in datasheet mode. Somehow I need to be able to edit the entry and update the source table. Any Ideas. I appreciate the fact that I will need vba code to do the updating. that is no problem. I have tried to...