>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