Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 31st, 2004, 04:01 PM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default SQL Statement Problem

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
 
Old January 31st, 2004, 06:12 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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


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
 
Old January 31st, 2004, 07:07 PM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default

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
 
Old February 1st, 2004, 02:28 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Beth M
 
Old February 1st, 2004, 11:59 PM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default

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


Quote:
quote:Originally posted by BethMoffitt
 Open the VB Editor and then go to Tools > References.

Beth M
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
 
Old February 2nd, 2004, 10:34 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

My pleasure :)

Beth
 
Old February 4th, 2004, 06:32 PM
Registered User
 
Join Date: Jul 2003
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Beth, how many times have you slain this problem? A few dozen?
 
Old February 4th, 2004, 06:39 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

A lot more than that... I have been using Access since 2.0. What about you?
 
Old February 4th, 2004, 06:54 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old February 4th, 2004, 06:58 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Beth M





Similar Threads
Thread Thread Starter Forum Replies Last Post
convert a SQL Statement from MS Access to a SQL Corey Access 6 March 28th, 2007 12:33 PM
SQL select statement problem shrisangeeta Classic ASP Databases 3 June 15th, 2006 10:28 AM
sql statement problem thas123 SQL Server 2000 4 February 22nd, 2006 01:59 PM
help needed with a SQL select statement problem wslyhbb Java Databases 1 August 14th, 2003 07:30 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.