Reference

[Guest]

I have a network database that users enter information into. I want to run
the crossmatch on the info entered and then I want to fax information back to
the customers using WinFax. My computer is the only one with Winfax and a
modem.

I am testing the trail version of ACG Winfax® Integration Class Library for
MS Access. This is my problem. I set the reference and then remove it when
I run the crossmatch. Since I am the only user with the WinFax library it
causes problems if the reference is not removed when another user opens the
database. This happens for various reasons.

I need some coding when the database is opened to "Remove the ref if it is
set". I am the only one who needs the Winfax Libary because I am the only
using Winfax.

Any Suggestions? Thanks for any help.


strfilename = "C:\Program Files\PDF Mail Library\Winfax Library 11.mde"
Set ref = References.AddFromFile(strfilename)
References.Remove ref

 

[Douglas J. Steele]

Can you use the Winfax library using Late Binding? In that way, all other
code will still work, and a trappable error will be raised when you try and
instantiate the reference to library.

 

[Guest]

Doug,

What is Late Binding? The idea about a trappable error seems promising?

 

[Douglas J. Steele]

Tony Toews has a bit of information about Late Binding at
http://www.granite.ab.ca/access/latebinding.htm

In a nutshell, rather than setting a reference to a library, and then
declaring objects like

Dim MyObject As Library.ObjectType

Set MyObject = New Library.ObjectType

you simply declare the objects as Object, and use the CreateObject method to
instantiate them:

Dim MyObject As Object

Set MyObject = CreateObject("Library.ObjectType")


Hopefully Tony's illustration will help you understand that gibberish <g>