D
Dustin Ventin
Okay, I've got two subforms in the detail section of a form. One subform
shows accounting-type data for all but one type of category (with a subtotal
at the bottom), and the other subform shows the exact same type of data for
the final category. In the main form's footer are textboxes that use coding
to add the totals from the first subform and the second subform. The coding
for these "grand totals" is not too complex.
=[frm-New-UpdateBudgetForecast-Budgeted].Form!txtTotalOriginalBudget+
IIf(IsError([frm-New-UpdateBudgetForecast-Unbudgeted].Form![Original
Budget]),0,[frm-New-UpdateBudgetForecast-Unbudgeted].Form![Original Budget])
Code like this is placed directly into each textbox. Now, the problem:
I noticed that if I opened this form and ever switched to another form, when
I came back the grand totals now read as #Error. To fix this, I ignored it
and simply programmed my other forms to automatically close and re-open this
form to refresh the data and get rid of the #Error. This seemed to be
working fine, until...
....I discovered that one of my users utilizes 800x600 screen resolution,
whereas I developed for 1028x(whatever). Most of the screens work fine,
simply requiring more scrolling than usual, but now this screen does not show
ANY of the data from the subforms.... and the grand total calculations are
now ALWAYS #Error on this screen.
This doesn't make any sense to me. I tried the usual code, utilizing the
..mde file code from http://www.developershandbook.com/downloads.htm, but
while that did seem to resize everything, the vertical scroll bar doesn't
appear (even though I have scroll bars set to "both"), making resizing
useless. Additionally, that solution does now seem to keep the #Error from
appearing in the grand totals.
Does anyone have any idea what's going on here? There seems to be more than
one issue at once, and I'd really appreciate some insight.
Thank you!
Dustin
shows accounting-type data for all but one type of category (with a subtotal
at the bottom), and the other subform shows the exact same type of data for
the final category. In the main form's footer are textboxes that use coding
to add the totals from the first subform and the second subform. The coding
for these "grand totals" is not too complex.
=[frm-New-UpdateBudgetForecast-Budgeted].Form!txtTotalOriginalBudget+
IIf(IsError([frm-New-UpdateBudgetForecast-Unbudgeted].Form![Original
Budget]),0,[frm-New-UpdateBudgetForecast-Unbudgeted].Form![Original Budget])
Code like this is placed directly into each textbox. Now, the problem:
I noticed that if I opened this form and ever switched to another form, when
I came back the grand totals now read as #Error. To fix this, I ignored it
and simply programmed my other forms to automatically close and re-open this
form to refresh the data and get rid of the #Error. This seemed to be
working fine, until...
....I discovered that one of my users utilizes 800x600 screen resolution,
whereas I developed for 1028x(whatever). Most of the screens work fine,
simply requiring more scrolling than usual, but now this screen does not show
ANY of the data from the subforms.... and the grand total calculations are
now ALWAYS #Error on this screen.
This doesn't make any sense to me. I tried the usual code, utilizing the
..mde file code from http://www.developershandbook.com/downloads.htm, but
while that did seem to resize everything, the vertical scroll bar doesn't
appear (even though I have scroll bars set to "both"), making resizing
useless. Additionally, that solution does now seem to keep the #Error from
appearing in the grand totals.
Does anyone have any idea what's going on here? There seems to be more than
one issue at once, and I'd really appreciate some insight.
Thank you!
Dustin