String handling functions not working 3

[GDGarth]

I changed computers, and the new one didn't work right, so I put the old one back. Unfortunately, the I.S. guy removed Access 97 from the old computer, so it had to be reinstalled.

After reinstalling (using "select all", to get everything), some of the text handling functions don't work. Specifically, I've got field in queries that use "Str", "Left", and "Right", and they just turn up "error". I'm pretty sure the database is not corrupted.

Here's an example from an append query - it has worked fine until the computer change:


IDNumber: Str([Build Schedule]![Build Date])+" "+([Build Schedule]![Sequence Number])


Any ideas? In the above example, I was able to change it to "Cstr" and get it to work, but I don't really want to go through and change a bunch of things unnecessarily.

 

[JeremyNYC]

Check your references. ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[GDGarth]

I should know where to do this, but I can't find it in Access 97. I thought it was under the "tools" menu, but I can't find it there.

What am I missing?

 

[JoyInOK]

From the code window (not the regular database window), choose Tools/References. Chances are you'll find one listed with it's name and a MISSING note beside it (I think this one is the VBA DLL, probably because the new install is in a different location than the previous version.

 

[KornGeek]

I'm not sure where it is in 97 (it's been too long), but in Access 2000 it is under the Tools menu for the VBA code window (not the Tools menu of the database window).

I got this exact same error when I was missing a reference once, so I believe Jeremy is on the right track.

 

[GDGarth]

Jeremy's my favorite poster, and Joy just turned into my second favorite!

I knew I had set references before, but I couldn't find where it was.

I found it, and it works fine now.

Thanks a bunch!

 

[GDGarth]

Korngeek gets a star too! That's exactly where it is (as Joy pointed out)

 

[KornGeek]

Thanks for the star. I guess Joy and I were posting at the same time. Glad to see you got this worked out.