Recent content by maxcess

  1. M

    Subform links and updates

    I can see your point of view, but I believe waiting 12 hours for a reply on one site before posting to another site is a legitimate request for help from more sources.
  2. M

    Subform links and updates

    I have an Orders form, without any underlying related tables. Located in the upper half of this form, I have a sfrmOrders in datasheet view with a ssfrmOrderDetails as a subform embedded in it. On the lower half of the form, I have a sfrmOrderProcessing in single form view. The goal is for...
  3. M

    Copy number from previous field into new as default

    Please help. I'm trying to use code in the On Current event of a form where a field name DIDA is examined for a 0 value. If it is found, the value of the DIDA field would match the value of the previous autonumered DID field. The default value of DIDA can be set at 0 in the table properties...
  4. M

    continuous form within continuous form

    Oop, spoke too soon on the drop list part... looks promising.
  5. M

    continuous form within continuous form

    Adam, that was intelligible enough. You understand the concept, and the outline.zip was awesome. Because it is a datasheet, however, drop lists and autocomplete are not available, and not much is possible for dressing up the appearance. I have a better grasp of the overall design limits now...
  6. M

    continuous form within continuous form

    Thought so. Subform will need to be in footer then. This is where I get the Parameter error that I posted separately now.....
  7. M

    continuous form within continuous form

    Indeed it does. But I am looking for interleaving the child form values with the parent form. Like one can do in a report.... Heading1 value1 value2 value3 value4 Heading2 valueA valueX value6 Heading3 valueZ value3... as opposed to: Heading1 Heading2 Heading3...
  8. M

    Enter Parameter Value on form close error

    It does not appear harmful, just cosmetic. Is there a way to supress it or deal with it. The issue seems like http://support.microsoft.com/default.aspx?scid=kb;EN-US;811860 but it is Windows 2000 with Access XP rather than Windows XP. The condition follows when the main form closes. There is a...
  9. M

    object variable or with block variable not set

    Looks like a bug in Access at the third subform. As long as the editing is done with form and subform, the link build button works correctly.
  10. M

    continuous form within continuous form

    The master and child are set, but it still looks like master table above and child table below, not interleaved.
  11. M

    continuous form within continuous form

    Tried the subform in the form footer, but the values did not appear to insert themselves between the parent data rows. One was stacked on top of the other. Is that what is to be expected, or were my settings possibly incorrect. The button idea is a possibility - just trying to avoid mouse clicks.
  12. M

    continuous form within continuous form

    Is it possible to make a form look like a continuous cascading outline (kind of like a report can list things under a heading using page header/footer criteria). That suggests a continuous form within a continuous form where the second form can expand and contract between the rows of the main...
  13. M

    object variable or with block variable not set

    Not sure how the error started happening. Creating a new form with subforms worked without error, until at some point, the master/child link box returned this error. From what I have researched on this error so far, the underlying table properties are correct (required vs not required). There is...
  14. M

    vb for controls in continuous form

    Righto. That worked, and for a subform the expression was Forms![frmStaff]![sfrmStaffList]![chkInactive]=True. Thanks...
  15. M

    vb for controls in continuous form

    Is it possible to use If..Then to change control colors on a continuous form? It works for a single form, but using a checkbox for a value to color other controls sets all controls in a continuous form the same. Example: If Me.chkInactive.Value = True Then Me.Firstname.ForeColor = vbRed...
Back
Top Bottom