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,
Madison Area Technical College student
Go there. I have a lot of awesome photos that I rendered myself