Using the MID function in MS Access

[Mandy]

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?

[KIK]

Hi,
these Functions are part of the VBA-Library.
This Lib is installed with Access. There must be another problem!

KIK

[Mandy]

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.

[KIK]

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

[Mandy]

Me thinks your right,

Maybe is should try setting InstallShield to install the Access 97 object.

Thanks a lot for your help.