Form Errors - Vista Issue

[ndeans]

Hi All,

I have a simple form with 3 subforms. I have a 1 data field on the main form for each subtotal of the subforms as well as an overall total field.

I have the following code in the subtotal fields:

SETot=IIf(DCount("[ID]","qryExpenses")=0,0,DSum("[Reimbursment]","qryExpenses"))
DTETot=IIf(DCount("[ID]","qryTravelExpenses")=0,0,DSum("[Expense]","qryTravelExpenses"))
RTETot=IIf(DCount("[ID]","qryTravelExpensesR")=0,0,DSum("[Amount]","qryTravelExpensesR"))

The total field then contains the following code:

Total=nz([SETot])+nz([DTETot])+nz([RTETot])

The queries all run off data elsewhere on the form, and i have triggered a "Form Refresh" macro on each of the changeable fields of the form, (so for example when changing the start date for the period the form then refreshes and re-runs the queries and updates the forms.

All things work perfectly on our windows XP systems but the rare few Vista operating systems causes these form fields to have errors. Basically the 3 subtotal fields don't appear to refresh when they are supposed to, and the total field shows as "Error"

It is actually a fairly cosmetic thing as the more important reports are generated without error, but it is something i would like to fix anyway, simply to keep the masses happy.

Would be very appreciative of any assistance or idea's on what's happening, or perhaps what's not happening here.

BTW: All have MS Office 2007, None do not have Administrator access. All XP machines work perfectly, all vista machines have these errors.

Cheers
Nathan

 

[boblarson]

Have you done this:
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx
on each of the Vista machines?

 

[ndeans]

Still No Go

Bob thankyou for your input, i had not done that for the vista machines, i have done so now but unfortunately the problem still exists.

I have enclosed a screenshot of the offending fields. Notice the total field has the "error" in it, while the other 3 fields appear to have nothing in it, but if i put the mouse cursor in the field and left click, the correctly calculated field appears, but the total field remains with the error.

Also, at the bottom left of screen the "Calculating....." notice appears to be caught in a loop of some description and doesn't seem to change.

Again much appreciation for any assistance.
Cheers
Nathan

 

[boblarson]

Can you strip out any sensitive information and then post it here so I can play around with it and see what's up?

 

[ndeans]

Demo Version

Thanks Bob.

Please find attached a demo version of the database. Would appreciate greatly any assistance.

Cheers
Nathan