More than one year later, this discussion is continued!!!
To add a reference to a DLL in Access, you need to go open the Visual Basic Editor (ALT-F11), then open the Tools menu and select References. Let's say you select "Microsoft Excel" from the references. To use it now, you need to declare an object variable, instantiate it and finally use it. See this piece of code:
Sub x()
Dim objXL As Excel.Application
Set objXL = New Excel.Application
With objXL
.Workbooks.Add
.Visible = True
End With
Stop
End Sub
>Hi Eric,
>
>I am a VFP person by trade.... I have a problem I need to solve in Access... the solution is a dll file but I am very, very 'thin' on access knowlege... can you tell/show me how to 'reference' a dll in access, and then use it??
>
>TIA
>
>Ric
>
>>>All,
>>>
>>>I want to be able to create a calculated fields using the SOUNDEX function. Access does not have a SOUNDEX function, but Visual Basic does. Can I or how can I use the VB SOUNDEX function in Access.
>>
>>If you want to use it in Access module, you can create a DLL in VB (with a method that includes SoundEX), reference it in Access and use it.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com