Error in Windows XP

[Kila]

I have a report written in Access 2000 that pulls up just fine on my PC, which is running Windows 2000 on a network. However, other users using Windows XP on the same network across the street get this error message:

You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object you specified.

They are getting this message when they click "OK" on a dialog form I created, but I am not getting the same message on my PC. The dialog becomes invisible when you click "OK" (a macro does this). Any ideas? Some kind of conflict with the "Visible" property & Windows XP?

Thanks in advance.

 

[Kila]

Update...

Update....the users at the other site are using Access 2003, and I am using Access 2000. Any ideas how to get around this error?

 

[mmmcpher]

Possible Solution

Kila,
I had virtually the same issue.

To fix it I would suggest you ensure that the shappmgr 1.0 Type Library has been ticked within Tools > References while using VB.

I would also suggest compareing whats ticked within your reference library to other users.

 

[Kila]

Applications Selected

Thanks for your response. Sorry for the delayed response on my part...I went out of town & your reply got lost in the mix. I have the following ticked:

Visual Basic for Applications
Microsoft 9.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Visual Basic for Applications Extensibility 5.3
shappmgr 1.0 Type Library (just added)

Another person referred me to a Microsoft website for the following bug:

BUG: You may receive an error message when you run a macro that uses the SetValue action to set the Visible property of an object in Access 2003

...at the website: http://support.microsoft.com/default.aspx?scid=kb;en-us;841916

However, I cannot tell you if either help worked. I was following the instructions from the Microsoft website, but I had to stop & normalize the database. It was written a few years ago before I learned that you had to have names for things that did not include spaces. So when I started writing code & macros for the Microsoftr help, I realized I needed to fix it. There are a LOT of tables, queries, and reports, so it has taken awhile with my other work also. I will let you know if this works.

In the meantime, there are SO many items listed under references. How do you know which ones you need? Just out of sheer curiosity, what would happen if you selected ALL of them, just in case?

 

[mmmcpher]

References

Hi Kila,

Sorry for the delay, I have barely been at work trying to use up the remaining holidays that I have left.

Anyways Hope you had a good christmas.

Your question about what would happen if all the references were selected even if they were not needed.
To be honest I'm not to sure as I have never tried it. I'm assuming that it may slow your system down due to the fact when you use a function it relates itself to the reference library. So I would say only use the ones you actually need.

Your second question about how do you know which reference you need to flag.

Well for example if you were designing you application to download to say MS Excel then you would need to flag Microsoft Excel 9.0 object Library.

I have also noted sometimes that if my application does not compile correctly it will tell you that a reference libary is missing.

Hope this sheds a little light on things.

I'm goning to have a read over that link you sent on your last post.