[AccessD] ACCESS2003 Function is not Expression

Dan Waters df.waters at comcast.net
Tue Jan 15 14:51:48 CST 2013


Hi Tony,

With my short experience so far with Access 2010, it's a little pickier than
previous versions.

In Access, there are a number of key words, like 'Name', 'Field', 'Table',
and dozens of others.  Those words should not be used as the name of an
object, or a field in a table, or a variable in code, etc.  I'm going to
guess that the word 'KeyWord' is a key word itself, and Access 2010 just
doesn't want to use it.

I currently have a report to fix that is trying to display a person's name
where the field in the table is 'Name'.  Gee ...

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Tuesday, January 15, 2013 2:36 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] ACCESS2003 Function is not Expression

Hey All

 

I have run into another interesting problem. On the client's machine when I
try to populate a ListBox from a query referencing a table in the backend
MDB called "KeyWord" the ListBox comes up empty. If I set it to a recordset
I can easily manipulate it using code. What I did was rename the table to
"KeyWordTbl" and all my queries work fine. I know some of you will be saying
"always designate a table with "Tbl"". But this was a revision of a many
years old application that has been running fine with no problems. I follow
"If it is not broke don't fix it".  As I mentioned before the only
difference between my machine and the client's is he has ACCESS2010
installed. What I do not understand is why the queries for the table
"KeyWord" work fine on my machine and on a friend's machine who has
ACCESS2007 installed. I figure the client's machine has a reserved word
"KeyWord" and ours don't. This whole thing has been baffling. I know some of
the gurus will be saying "Hey you twit the simple answer is.........".
Anyway got to finish revising my code and get the application out to the
client.  Oh to be an Oscar Meyer wienie.

 

Thanks

Tony Septav

Nanaimo, BC

Canada

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list