Object not set error message, #name? comes on form after being frozen?

[sara07]

Hello,

I have some users complaining that when they are doing order entry on access form - they would see #name? on all of the text boxes throughout the screen. this is very randomly though. I went to the user and they said first it would get frozen and then #name? would come and then this annoying message would come "object not set" in which it is a infinite message. I think you have to click on it 100 times before it goes away. But why is this #name? coming and how can i prevent it from not happening again? PLEASE HELP ITS VERY IMPORTANT!! And its very random they arent geting it now.. but they were ... I cant replicate the issue. I have access 2002 and connected to SQL Server 2000 backend.

 

[JoeAtWork]

Look in the query the form is bound to. In the query, look for any functions that are getting called. The error is likely happening in one of those functions (or a function called in one of the nested queries).

If you find the function, look for an object variable that is not being initialized. And put in an error handler that tells the users the function name and the error description - at least they will be able to give you more information the next time it happens.

 

[JerryKlmns]

Does this access 2002 file reside on a server? Network connection problem is very common. You could move the mdb on each PC and gain also in time.