10-24-2018, 08:52 AM
|
#136
|
|
Newly Registered User
Join Date: Sep 2018
Posts: 31
Thanks: 26
Thanked 1 Time in 1 Post
|
Re: The Ten Commandments of Access
Quote:
Originally Posted by isladogs
Another point might be readability for others.
IMO MyCamelCaseField is easier to read than My_Camel_Case_Field ...but you may disagree.
|
I personally find the version with underscores easier to read, but I think it may be a matter of personal preference (albeit a weak one).
Quote:
Originally Posted by Galaxiom
[L]ots of tiny words make terrible object names no matter how they are typed. A couple of SubstantialWords makes a far more readable name. Surely nobody would ever include a preposition (eg 'of') in a name.  
The underscore already has a role in VBA separating the procedure name from the object name.
Code:
Private Sub SomeControl_AfterUpdate
|
That was NOT a real world example. strPath_Ext or strFile_Name are more likely examples.
Your point about the role of underscore is well taken.
|
|
|
|
10-24-2018, 10:21 AM
|
#137
|
|
Nifty Access Guy
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,377
Thanks: 556
Thanked 949 Times in 898 Posts
|
Re: The Ten Commandments of Access
I find that often, the underscore is hidden, making it look like a space. I find this disconcerting!
Sent from my SM-G925F using Tapatalk
__________________
Code:
|||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Uncle Gizmo |
| |
| |
| Get $20 worth of "Nifty Code" |
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
Last edited by Uncle Gizmo; 10-24-2018 at 10:29 AM.
|
|
|
|
|
01-09-2019, 10:25 PM
|
#138
|
|
Newly Registered User
Join Date: Jul 2011
Location: Townsville; Queensland; Australia
Posts: 21
Thanks: 8
Thanked 0 Times in 0 Posts
|
Re: The Ten Commandments of Access
I love it oh "Wise Man". I shall abide by your commandments
|
|
|
|
|
10-08-2019, 12:12 AM
|
#139
|
|
Newly Registered User
Join Date: Aug 2019
Posts: 11
Thanks: 3
Thanked 0 Times in 0 Posts
|
Re: The Ten Commandments of Access
Hey Guys, these commandments are with the tune of the SCRIPTURES, so they are instructive.
got some preachers here. pretty good.
|
|
|
|
|
11-20-2019, 10:04 AM
|
#140
|
|
Nifty Access Guy
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,377
Thanks: 556
Thanked 949 Times in 898 Posts
|
Re: The Ten Commandments of Access
Quote:
Originally Posted by taylor941
When I read the title I thought about the ten commandments of the Bible hehe...
|
If you break one of the Bibles Ten Commandments, then you only have God to deal with. If you break one of the MS Access Ten Commandments, then you have, Colin, Pat, Richard, me and a host of other people to deal with!
__________________
Code:
|||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Uncle Gizmo |
| |
| |
| Get $20 worth of "Nifty Code" |
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
|
|
|
|
|
The Following 3 Users Say Thank You to Uncle Gizmo For This Useful Post:
|
|
|
11-20-2019, 10:28 AM
|
#141
|
|
High Noon Moderator
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,382
Thanks: 115
Thanked 3,114 Times in 2,831 Posts
|
Re: The Ten Commandments of Access
Love it! 
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.
Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
|
|
|
|
|
The Following User Says Thank You to isladogs For This Useful Post:
|
|
|
11-22-2019, 01:26 AM
|
#142
|
|
Pristine Curmudgeon
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 2,035
Thanks: 457
Thanked 302 Times in 261 Posts
|
Re: The Ten Commandments of Access
Quote:
Originally Posted by Uncle Gizmo
If you break one of the Bibles Ten Commandments, then you only have God to deal with. If you break one of the MS Access Ten Commandments, then you have, Colin, Pat, Richard, me and a host of other people to deal with!
|
Almost as scary as meeting the almighty...
__________________
“It follows then as certain that night succeeds the day, that without normalization, we can do nothing definitive, and with it, everything honorable and glorious.” - with apologies to George Washington
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
Rate This Thread |
 Linear Mode
|
|
All times are GMT -8. The time now is 03:16 AM.
|
|
