Search results

  1. S

    Passing Subform as Variable

    You would have to pass the form call SomeSub Forms![FRM_FRAMES]![FRAME_1].Form sub SomeSub (frm as Form) Using Forms![FRM_FRAMES]![FRAME_1].SourceObject only passes the name of the subform and leaves out the main form information.
  2. S

    Question Pivottable Rounding

    Check http://support.microsoft.com/kb/310264. The rounding error applies to the Decimal data type, and is a bug. You can use the ccur, ssng, or cdec functions to convert the data type in the query, so that in the PivotTable view you will retain the decimal portion.
Back
Top Bottom