473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

A97 query field named "Description" is a problem

MLH
I have a query field...
Description: [VColor] & "2-tone"

When I run it, the output in that field is empty.
If I change the name to MyDescription - it works fine.
I noticed the query field has a Description property setting.
That's what's causing my problem. Just a 'heads-up' to the
group letting you know to watch out for it.

It took me a long time to recognize the error. I have another
query with a field of the same name that has NEVER caused
me a problem. I used that query as a template when creating
this one. So it wasn't my first instinct to suspect the chosen
field name was a problem.
Nov 13 '05 #1
11 2044
MLH
Looking further, I see I have a table with one field
named "Description" in another database. Even
though HELP (under Field Names) doesn't strictly
forbid it and the HELP (under naming conventions)
doesn't strictly forbid it - anybody think that could
cause confusion down the line?

Believe me, the deal with the query was difficult to
figure out. Reports referencing that query and that
field would sometimes say [Description] field not found
and other times, Access 97 would lock up saying it
had to close when I merely attempted to open the report
in design view after creating and saving it.
Nov 13 '05 #2

"MLH" <CR**@NorthState.net> wrote in message
news:nk********************************@4ax.com...
I have a query field...
Description: [VColor] & "2-tone"

When I run it, the output in that field is empty.
If I change the name to MyDescription - it works fine.
I noticed the query field has a Description property setting.
That's what's causing my problem. Just a 'heads-up' to the
group letting you know to watch out for it.

It took me a long time to recognize the error. I have another
query with a field of the same name that has NEVER caused
me a problem. I used that query as a template when creating
this one. So it wasn't my first instinct to suspect the chosen
field name was a problem.


Yep. Description is a reserved word in Access. It should never be used for
the name of an object. Some place in the help there's a complete list of
reserved words, but it's near impossible to find.

Nov 13 '05 #3
MLH wrote:
Looking further, I see I have a table with one field
named "Description" in another database. Even
though HELP (under Field Names) doesn't strictly
forbid it and the HELP (under naming conventions)
doesn't strictly forbid it - anybody think that could
cause confusion down the line?

Believe me, the deal with the query was difficult to
figure out. Reports referencing that query and that
field would sometimes say [Description] field not found
and other times, Access 97 would lock up saying it
had to close when I merely attempted to open the report
in design view after creating and saving it.


I have never seen a problem with a field named "Description". There is a help
topic in Access 97 that lists all of the reserved words and "Description" is not
one of them (though "Desc" is).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4
Randy Harris wrote:
Yep. Description is a reserved word in Access. It should never be
used for the name of an object. Some place in the help there's a
complete list of reserved words, but it's near impossible to find.


Not in Access 97 it's not. At least the help topic doesn't mention it.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #5
MLH
>Yep. Description is a reserved word in Access. It should never be used for
the name of an object. Some place in the help there's a complete list of
reserved words, but it's near impossible to find.


Personally, I think it should come with a flashing red warning anytime
someone tries to use it. Its such a natural choice one can easily get
lulled into picking - whether by accident or on purpose. Either way,
can cause real probs down the road with very non-descript errors.
If a fieldname choice can cause Access to hang or unexpectedly
close, it deserves some kind of special treatment.
Nov 13 '05 #6
MLH wrote:
Personally, I think it should come with a flashing red warning anytime
someone tries to use it.


Now that would be an excellent enhancement to Accesss, IMO. I remember
about 8 years ago, I couldn't for the life of me figure out why a Jet
query I'd worked very hard on was crashing. Turned out it was the use
of "Tag" as a field name, another choice quite natural for someone
relatively new to this business to choose like "decription" or "name" or
"date".

Mind you, it's also a good reason to settle on a naming convention that
will certainly bypass any reserved word. Personally, for field names, I
use the underscore technique a lot of Oracle developers use, along with
a prefix, ie, VEH_DESCRIPTION for description of a vehicle in a a
vehicle table. I find this method much easier to read than the Resnick
convention, though I still use the latter for naming variables and
procedures in my VBA code.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #7
Sorry. It's a property in A2K, I mistakenly assumed that it was in A97
also.
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:8b****************@newssvr11.news.prodigy.com ...
Randy Harris wrote:
Yep. Description is a reserved word in Access. It should never be
used for the name of an object. Some place in the help there's a
complete list of reserved words, but it's near impossible to find.


Not in Access 97 it's not. At least the help topic doesn't mention it.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Nov 13 '05 #8
rkc
Randy Harris wrote:
Sorry. It's a property in A2K, I mistakenly assumed that it was in A97
also.
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:8b****************@newssvr11.news.prodigy.com ...
Randy Harris wrote:
Yep. Description is a reserved word in Access. It should never be
used for the name of an object. Some place in the help there's a
complete list of reserved words, but it's near impossible to find.


Not in Access 97 it's not. At least the help topic doesn't mention it.


http://support.microsoft.com/kb/q109312/

Nov 13 '05 #9

"rkc" <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in message
news:OO*******************@twister.nyroc.rr.com...
Randy Harris wrote:
Sorry. It's a property in A2K, I mistakenly assumed that it was in A97
also.
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:8b****************@newssvr11.news.prodigy.com ...
Randy Harris wrote:

Yep. Description is a reserved word in Access. It should never be
used for the name of an object. Some place in the help there's a
complete list of reserved words, but it's near impossible to find.

Not in Access 97 it's not. At least the help topic doesn't mention it.


http://support.microsoft.com/kb/q109312/


Hmm... It seems Microsoft thinks it's a reserved word.

Nov 13 '05 #10
Randy Harris wrote:
"rkc" <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in message
news:OO*******************@twister.nyroc.rr.com...
Randy Harris wrote:
Sorry. It's a property in A2K, I mistakenly assumed that it was
in A97 also.
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:8b****************@newssvr11.news.prodigy.com ...

> Randy Harris wrote:
>
> > Yep. Description is a reserved word in Access. It should
> > never be used for the name of an object. Some place in the
> > help there's a complete list of reserved words, but it's near
> > impossible to find.
>
> Not in Access 97 it's not. At least the help topic doesn't
> mention it.


http://support.microsoft.com/kb/q109312/


Hmm... It seems Microsoft thinks it's a reserved word.


I guess they expanded the list at some point. Here are all of the "D"s listed
in my help file

DATABASE
DATE
DATETIME
DELETE
DESC
DISALLOW
DISTINCT
DISTINCTROW
DOUBLE
DROP

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #11
Rick Brandt wrote:
it's a reserved word.

I guess they expanded the list at some point. Here are all of the
"D"s listed in my help file

DATABASE
DATE
DATETIME
DELETE
DESC
DISALLOW
DISTINCT
DISTINCTROW
DOUBLE
DROP


On further review I see that the help topic I was looking at is entitled "SQL
Reserved words". I had searched and found a topic labelled "Reserved words" in
the index and never noticed the "SQL" part in the title that came up. I'm sure
that the list for VBA and SQL have some overlap but that there are also distinct
entries in both as well.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Michele Fondry via .NET 247 | last post by:
hello. I have a webform form app in vb.Net that uses a SQL query. I am trying to use the substring function, but get the following error: Description: An unhandled exception occurred during the...
4
by: marclinenberger | last post by:
If you right click on a table name in the tables window and click on properties you get a dialog box that allows you to add a description of the table. My question is using VBA how do you access...
1
by: Pucca | last post by:
I'm using vs2005, .net 2.0 on Windows 2000 server. When I double click on an entry of the "Security" log in the system's "Event Viewer", a Property window pops up. In this window, there is a...
0
by: bbcrock | last post by:
I have approximately 400 column descriptions stored in an MS Word document in MS Word tables that I want to insert into SQL Server utilizing the sys.sp_addextendedproperty function. Cutting and...
4
by: thaytu888888 | last post by:
Here is my codes in aspx page: <td colspan="2" class="main_menu" runat="server" onclick='toggleDisplay(<%#Eval("description")%>);'><%#Eval("description")%></td> Here is in "View source": ...
2
by: atishrg | last post by:
Hello All Need your help.. I created addin for outlook 2007 in vs2005(vb.net)... It is working fine now I Migrated that to vs2008 and created setup for that in vs2008...
8
by: ismailc | last post by:
Hi, I would like to change the text color of (<xsl:value-of select="Description") onmouseover of image. the javascript works, it's just that i can seem to get the name correct <td>...
3
by: prakashwadhwani | last post by:
I have just been asked to port an Access 97 app from an old Pentium 3 to a new Pentium Core-2-Duo PC. On the new PC, Office 2003 is installed. On opening the database, Access provided me with an...
1
by: silverachilles | last post by:
Hello, I have php code which takes an rss feed and outputs it on a page of my website. For each item it shows the link, title and description. My problem is the description element contains a lot...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.