String functions in Access 2000

[Ham]

I converted a database from Access97 to Access2000. The database has a lot of VB modules in it doing string manipulation. However, the functions Right$, Left$, etc. no longer work. I'm assuming I need some sort of object library that isn't being referenced now. Here's what's in the reference list currently: 'Visual Basic For Applications'; 'Microsoft Access 9.0 Object Library'; 'Microsoft DAO 2.5/3.5 Compatibility Library'; 'MISSING: UTILITY.MDA'; 'OLE Automation'; and 'Microsoft Visual Basic for Applications Extensibility 5.3'. I have no idea what that 'MISSING:..' means, but I would guess it isn't good news. I certainly would appreciate any help/suggestions anyone might have. Thanks. -- Ham

 

[JimHorton]

Ham,<br>
I've had similar problems, I think 2000 no longer by default includes the library with those functions. Open a module, go to Tools¦References, and add (I think it's Da03.6 or MS Access 9.0 OLB). Anyway, the problem goes away when the correct reference is added)<br>
--Jim

 

[elizabeth]

I have DAO 2.5 and Right$ works for me.

 

[DougP]

Drop the $ sign<br>
just use Left<br>
<br>
Then Dim your variable as a string<br>
<br>
Dim MyVar as string<br>
x = Left(MyVar,1) <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[elizabeth]

Isn't $ an old (shortcut) way of dimming as string?

 

[DougP]

Yes but the key word is &quot;OLD&quot;<br>
She don't always work anymore.<br>
So I've dropped it from my usage.<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[Ham]

Thanks for the quick replies. I did exchange MS DAO 2.5/3.5 Library for the MS DAO 3.6 Object Library. That by itself did not resolve the issue. The MISSING: UTILITY.MDA entry bothered me, so I did rummage through the computer and find 2 utility.mda files. I used the browser of the references dialog box to add the newer of the 2 utility.mda files to the references list. That did take care of the problem.<br>
<br>
Thanks again for your responses. -- Ham Rutledge