Printable View
I've created an Access Database that uses the MID and FORMAT functions from Visual Basic. I have now found that the database wont work on a computer that doesn't have Visual Basic installed. Is there a way I can find out which files are needed for these functions?
Hi,
these Functions are part of the VBA-Library.
This Lib is installed with Access. There must be another problem!
KIK
Maybe, but I can't think what else it could be. When I compile the code in Access without having VB installed it doesn't recognise MID, MID$ and FORMAT. If I then install VB it works fine. I looked at the help file for MID and the title of the page was Visual Basic reference, which is what made me think they were VB methods not VBA methods.
in the code-window, you can write the library before the function:
if you try, you will see, that vba is the lib:
vba.mid()
vba is a module of access. you have not to install it.
KIK
Me thinks your right,
Maybe is should try setting InstallShield to install the Access 97 object.
Thanks a lot for your help.