How to troubleshoot?

[Danny Sanders]

We have a home grown Access 2000 app that worked on *every* Win 2k
workstation SP 3 or 4 with Office 2000 Sr1 and SP3. Worked as admin or a
regular user.

No matter what combination of Win 2k SP and Office SP the Access app worked
as expected.

We ordered 3 new Dell latitude D500 laptops. On these 3 laptops ONLY we can
not get the Access app to work. No combination of Win2k SP and Office SP
will allow the app to work. The error persists whether logged in as admin or
user.

The error message is :
"This expression is typed incorrectly, or it is too complex to be evaluated.
For example a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables"

Once this message is cleared a series of "Object Invalid or no longer set"
appears and you have to OK each.

I am not a programmer. I can't tell you what is supposed to happen. The
person that created the app is here and I can relay questions if necessary.

We need to get this app working on these computers. It worked on the Dell
Latitudes we are moving from.

Any Ideas?

Thanks
DDS

 

[JohnFol]

Have you narrowed this down to a specific query / piece of code?

 

[Danny Sanders]

From our programmer:

Description:

The forms that fail are set up with a combo box to select a record type and a subform to present all the records of that type on the form. The subform has about 30 data objects and 40 calculated objects from a query that does not fail when run independently.



Failure:

Data modification (including update queries) causes all calculations to fail - it seems the combo box selection cannot be held - the error message is:



"This expression is typed incorrectly, or it is too complex to be evaluated.
For example a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables"


Thanks for the help John.