Expression too complex (only on AMD machine)

[LoneReaper]

I have a StoneEdge database and there is 2 ways to search for records. The first one is from the main switch board, "view orders" and when you press it, it first brings up the search box, then finds the order and takes you to the "Orders" form, once you are in that form it has a "search" button to press to search for orders again. If i search using that button, when it finds the order it gives me and Error

"The expression you typed is incorrect or too complex to evaluate..."
I press ok , then it says
"Object is Invalid or no longer set" a bunch of times

then it fills in all the order info with #NAME

This is a new AMD machine with fresh WIN2K and fresh OFFICE XP. This doesnt happen on any other machine. Any suggestions?

 

[WayneRyan]

Lone,

Given that it only happens on one machine, REFERENCES should be the
place to start. Get code in Design View, select Tools --> References.

Compare the good/bad computers.

Also, use the Search facility here: References

Wayne

 

[LoneReaper]

same

everyting is the same, infact we have a server that has install files and update files for our database so everybody has the same files and the references checked ok. could it possible be a problem with the chip that i have? bad "math coproccessor" or something like that?

 

[The_Doc_Man]

I've never heard of that before, but while you are searching, you might try the Microsoft Knowledge Base for topics with the key phrases:

AMD Hardware Abstraction Layer Problems/Anomalies/Errors

AMD Processor (or CPU) Problems/Anomalies/Errors

And also, if it is XP, find out if you have Service Pack 2, which included lots of patches for lots of components. Verify that all machines are patched equally. I have seen some cases where a machine refused to install elements of an update because some instruction failed. But AMD actually is a pretty good CPU chip. I'd be surprised if it failed on you.

Further, I doubt that error message you reported would be issued after a CPU failure. I think you'd get a different message than that.

One last thing to check: The resources on your system can be an issue.

You need to determine whether your swap file is abnormally small and/or size-limited below the level of the other machines, or whether the free space on that disk is very low.

You need to run the System Info program (from Control Panel) to determine the system's available "Resources." Or if you have a performance monitor package, they will track resources and warn you of impending depletion.

As to the specific errors, the only REAL error is "The expression you typed is incorrect or too complex to evaluate..." - all else after that is sort of like a secondary splatter issue. So can you determine the expression it does not like? And if it isn't too long, post it for us?

 

[LoneReaper]

ok

all computers have all current patches and updates. I will see if i can get that expression. Our database guy will need to get it for me. So i will post if i can get it from him. Thanks for the help so far.

 

[kero9394]

I have similar problem.

My database maintains a small library, and has several forms to track books, members, and transactions.

These were the steps taken to produce the error:
1. from main form, I put some codes in the click event to open other forms, such as member's and book's.
2. other forms are opened correctly, with filtered data specific to that particular transaction.
3. close form.
4. if I tried to move to another record in the main form, Access always give me the object invalid error.

Note that this happens on two windows 2000 machines. My home computers which are both Windows XP are not experiencing this problem.

I was hoping anyone could track this down.