Search results
-
J
What have I done? You can't open a subform when it is also open in Design view
Problem: Visual Basic run-time error 7792: You can't open a subform when it is also open in Design view. I have a subform with properties for SourceObject, LinkMasterFields, LinkChildFields changing according to objects and events in the master form. The subform was bound to a query before... -
J
How do I update data related to a read-only query on a form?
Hi all, I'm so tired of looking... please help me!! I have an Access Data Access Page based on a query which is not updatable. The query is based on a many-to-many table (e.g. OfficeProducts with foreign keys for OfficeID and ProductID and an Amount field). The query is not updatable as I have... -
J
simple, but so difficult!! updating record in DAP form based on read-only query
Hi all, I'm so tired of looking... please help me!! I have an Access Data Access Page based on a query which is not updatable. The query is based on a many-to-many table (e.g. OfficeProducts with foreign keys for OfficeID and ProductID and an Amount field). The query is not updatable as I... -
J
Tab Controls and Linked Subforms with One to Many Relationships
Hi there I've got 3 tables related to one another with one to many relationships. They are: 21_Category 22_SubCategory 23_Indicator where the 23_Indicator table has 22_SubCategory as its parent and 21_Category as its grandparent. The forms wizard in Access has nicely developed a form with 2...