Naming question
in [Help]
|
From: Access Developer on 18 May 2010 12:00 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(a)oilandvinegar.com> wrote in message news:XcqdnUm08-Vgi3PWnZ2dnUVZ_uqdnZ2d(a)earthlink.com... > 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.
From: Access Developer on 18 May 2010 12:05
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(a)Browniew.com> wrote in message news:hslci4$fa4$1(a)textnews.wanadoo.nl... > 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(a)gmail.com> schreef in bericht > news:856a94FlilU1(a)mid.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(a)Browniew.com> wrote in message >> news:hsk9co$319j$1(a)textnews.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 >> >> |