Search results

  1. 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...
  2. J

    How do I update data related to a read-only query on a form?

    does anyone know how to write this in VBScript? Does anyone know how to convert the above code to VBSCript so I can use it in Data Access Pages? Jenny
  3. J

    How do I update data related to a read-only query on a form?

    Thanks Larry, that looks like exactly what I need to do. Do you know how to write the same thing in VBScript? I've created this form in Data Access Pages so it doesn't like the syntax. Thanks again, Jen
  4. 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...
  5. 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...
  6. 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...
Back
Top Bottom