Naming question

#11

It took me a while to get motivated and sign up for a news server when my
ISP dropped newsgroups, but now I'm back, and glad to be here. Looks like
traffic is kinda low... maybe there'll be an influx when Microsoft shuts
down their sponsored Access groups.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

"Salad" <salad (AT) oilandvinegar (DOT) com> wrote

Quote:

Access Developer wrote:

Larry Linson

I think I remember that name. It's been so long. There was a guy named
Lyle that was a member of this group as well.

#12

Allen Browne, if I recall, has an extensive list of Reserved Words on his
website. I can't think of a reserved word, though, that begins with one of
the Reddick prefixes, so that would, I guess, apply mostly to Field names.

Drop Greg Reddick an e-mail suggesting he mention reserved words. I haven't
communicated with him, myself, but have been told that he's very
"approachable".

I'm a little short of time right now, but I'll take a look at your original
post on this subject, later and see if I have anything to add to what's
already been written.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

"Lars Brownies" <Lars (AT) Browniew (DOT) com> wrote

Quote:

One addition: I think a naming convention should mention reserved words
and why not to use them. I don't see that mentioned in the RNC article.

Lars

"Access Developer" <accdevel (AT) gmail (DOT) com> schreef in bericht
news:856a94FlilU1 (AT) mid (DOT) individual.net...
Hi, Lars. I strongly recommend AGAINST inventing new personal naming
conventions. A very, very large number of Access developers use the
Reddick Naming Conventions, which are documented in detail at
http://www.xoc.net/downloads/rvbanc.pdf. Not only do you save the stress,
time, and effort of resolving questions such as you ask here, but if you
come along after someone else, or they after you, the probability is
higher that you'll have an easier time because you both use the same
conventions.

Some will say that it doesn't matter what convention you use, as long as
you're consistent. That only applies if everyone who looks at your
applications is in your company which has adopted an
only-locally-standard naming convention.

Larry Linson
Microsoft Office Access MVP

"Lars Brownies" <Lars (AT) Browniew (DOT) com> wrote in message
news:hsk9co$319j$1 (AT) textnews (DOT) wanadoo.nl...
I'm still composing my personal naming convention and I have a question
about it.

In my apps I have a table tblUser with the first field: UserID. In a
field in another table this ID number is used to store which user
entered the data. I'm doubting what name I should give to this field. If
I only call it UserID then the field name would not be descriptive
enough. So I'm thinking about EnteredByID but I'm doubting whether I
should add the ID part. I know there is no right answer to this
question, but I do wonder what others would do.

Thanks, Lars

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Naming question

comp.databases.ms-access comp.databases.ms-access

Re: Naming question - 05-18-2010 , 11:00 AM

Re: Naming question - 05-18-2010 , 11:05 AM