references (1 Viewer)

[CoachPhil]

are there reference links that will replace
Graphitti User Interface Controls and
Microsoft Windows Common Controls 2.6.0 ?

in a multi user environment most users have no problem accessing the app but others have issues with the above references

CoachPhil

 

[SOS]

First of all, each user would need to have the files on their computer and registered to use them. If they do not have them then there will be an error.

You can use LATE binding so that you can use error handling to make it so that code that normally runs would not if they don't have those files installed. With early binding (where you have the reference set) then it will fail with a system error when trying to open the database.

For example, if they didn't have Excel loaded you could get past that with

Dim xlApp As Object

Set xlApp = CreateObject("Excel.Application")

and then catch an error if it could not create the object

where if you set a reference to Excel and then used

Dim xlApp As Excel.Application

Set xlApp = New Excel.Application

it would fail immediately upon trying to open the database and would not give you the opportunity to catch the error and bypass or give a user friendly message.