Search results

  1. R

    Cannot update. Database or object is read-only. (Error 3027)

    Hi, what do you mean by as long as DB is not locked? Thanks
  2. R

    Cannot update. Database or object is read-only. (Error 3027)

    [CODE]/Dim db As DAO.Database Dim rec1 As DAO.Recordset Dim recFiltered1 As DAO.Recordset Set db = CurrentDb Set rec1 = db.OpenRecordset("SELECT [Product Suppliers Name].[Product ID], [Product Suppliers Name].[Supplier] FROM [Product Suppliers Name];", dbOpenDynaset, dbSeeChanges)...
  3. R

    Can insert records in subform but cannot delete records in subform

    My apology. I should say I right click on each row. There is no *.
  4. R

    Can insert records in subform but cannot delete records in subform

    Hi, One is mainform, the other is a subform. The row source of the mainform is base on read only query. This query extracts various fields from various tables. And one of the fields is ID. The row source of the subform is base on a table. The common identifier(“key”) between the read-only...
  5. R

    Can insert records in subform but cannot delete records in subform

    I have a subform linked to one mainform The row source of the subform is base on a table. The row source of the mainform is base on a query(should be read only query) because sum(), group by clause, join are used in the query. The common identifier between the table and the query is an ID...
Top Bottom