Hi all,

Up until I upgraded to Windows 2000, I've had an easy time with the Queries Dialog Box inside my Music Inventory application (Access 2000). A while ago, I moved the database from Windows 98 to Windows 2000 and now, the Queries Dialog Box will not work. The VBA code is fine. It's the SQL Statement that puts the names of all the queries into an existing listbox that's giving me a headache.

This is the SQL Statement:

SELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left([Name],1)<>"~" ORDER BY [Name];


The error I keep getting is "Undefined function 'Left' in expression"

However, I am not getting this error with another database that I have (Flash MX 2004 MovieTracker). So, my question is this: Why is Music Inventory 2001 giving me this error and not Flash MX 2004 MovieTracker?

Thanks in advance,

Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

__________________
Ben Horne
-------------------------
I don\'t want to sound like I haven\'t made any mistakes. I\'m confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age

 

Usually whenever you receive this type of error, it is Reference related. Open your references and see if any are missing. If not, uncheck the references and then re-establish.

Regards,

Beth M

OK,

Where are those references located? I'm a bit clueless on where to go with this next

Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

Open the VB Editor and then go to Tools > References.

Beth M

Got it,


Beth, thanks so much for the help. I did find one missing reference. I've unchecked that reference since I found it. Now, the SQL Statement works normally


Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

My pleasure :)

Beth

Beth, how many times have you slain this problem? A few dozen?

A lot more than that... I have been using Access since 2.0. What about you?

majora
Make sure that you check for this problems when you have a lot of users with different versions of MS OS or MS Office. Also try to use the same version of software as your users. I have seen folks uprade their pc, but not their user's pcs, that will make this problem come up more often.



Sal

Unfortunately you don't have that luxury when you develop a software product for general distribution to the masses by retail sales. :/

Beth M