Mid Function in Access97

[Phil Hellmuth]

I'm unable to use the Mid function in VBA with Access97. When
attempting to add the proper Visual Basic for Applications reference
(VBE6.DLL), I encounter an error, as it conflicts with the default VBA
reference, which cannot be removed. Anything else I can do?

Thanks in advance.

 

[John Nurick]

Hi Phil,

Mid() is available in a standard Access 97 installation. VBE6.DLL is not
required: it belongs to later versions.

You probably have some other references problem. See
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html for more.