Calling an custom DLL

[pkane]

I am building a custom DLL that will be passed parameters and needs to pass back data to ACCESS.

Any help in how to call from ACCESS would be appreciated.

Thanks in advance.

Pat Kane

 

[Travis]

In the Declarations Section of your module add this:

Private cMyDLL as THEDLLNAME


Then in the code that will use the dll add this.

Set cMyDLL = New THEDLLNAME
x = cMyDLL.FunctionName(Parameter1,Parameter2)

You can make cMyDLL Public if you want. Just remember to Set cMyDLL = Nothing when your done or you could leave Access in a point that is not completly shut down.