Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rating: Thread Rating: 20 votes, 5.00 average. Display Modes
Old 09-29-2011, 02:35 PM   #61
coxmg
Newly Registered User
 
Join Date: Sep 2011
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
coxmg is on a distinguished road
Re: The Ten Commandments of Access

Dont forget to familiarize yourself with the differences between the various copies of ACCESS.-

coxmg is offline   Reply With Quote
Old 10-21-2011, 08:53 AM   #62
Vasu
Newly Registered User
 
Join Date: Oct 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Vasu is on a distinguished road
Thumbs up Re: The Ten Commandments of Access

HI,

Thank you for this valuable ten point..
Vasu is offline   Reply With Quote
Old 10-22-2011, 04:54 PM   #63
Yorkiemuncher
Newly Registered User
 
Join Date: Mar 2011
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Yorkiemuncher is on a distinguished road
Re: The Ten Commandments of Access

I learnt the 10 Commandments of Access the hard way...and now i live by them, but the really key is undstanding what you really want your database to achieve or in my case at the moment is building a little game and using the tables to store the data for players names and scores and other additional user content. Hopefully i will post the application here very shortly.

Yorkiemuncher is offline   Reply With Quote
Old 01-27-2012, 12:57 AM   #64
greenear
Newly Registered User
 
Join Date: Jan 2012
Posts: 12
Thanks: 1
Thanked 0 Times in 0 Posts
greenear is on a distinguished road
Re: The Ten Commandments of Access

Quote:
Originally Posted by Yorkiemuncher
I learnt the 10 Commandments of Access the hard way...and now i live by them,
I shall adhere to them as good as I am able XD
greenear is offline   Reply With Quote
Old 08-26-2012, 04:00 PM   #65
EL_Gringo
Newly Registered User
 
Join Date: Aug 2012
Location: Costa Rica
Posts: 7
Thanks: 3
Thanked 0 Times in 0 Posts
EL_Gringo is on a distinguished road
Re: The Ten Commandments of Access

Quote:
Originally Posted by DCrake View Post
Thou shalt not use "SendKeys", "Smart Codes" or "GoTo" (unless the GoTo be part of an OnError process) for these will lead you from the path of righteousness.
I skipped 'GoTo' since I worked with the wonderful (structured) GFA-Basic for Atari, back in '87. In fact, I can only imagine one case (except for the mentioned case of error-trapping) of a useful GoTo, that is when a friend calls and says 'GO TO David's bar, I'll be there in 5 minutes'. All the rest can be dealt with with If, Select Case, Loops and a an eventual 'exit sub' here and there.

Thanks for the post, DCrake!

El Gringo
EL_Gringo is offline   Reply With Quote
Old 09-24-2012, 06:21 PM   #66
kipcliff
Registered User
 
Join Date: Sep 2012
Location: Wisconsin, U.S.A.
Posts: 71
Thanks: 2
Thanked 8 Times in 8 Posts
kipcliff is on a distinguished road
Re: The Ten Commandments of Access

It's nice to see a listing of lessons I learned the hard way. I wish I had this list when I started working with Access. lol
kipcliff is offline   Reply With Quote
Old 11-21-2012, 10:49 AM   #67
jeds
Newly Registered User
 
Join Date: Nov 2012
Location: CNY Fingerlakes
Posts: 28
Thanks: 19
Thanked 0 Times in 0 Posts
jeds is on a distinguished road
Re: The Ten Commandments of Access

Quote:
Originally Posted by DCrake View Post
thou shalt abhor the use of "Lookup Fields" which art the creation of the Evil One.
OK, I would like to understand the reasoning behind this one. I have read this elsewhere, but as a newbie the explanation did not sink in. To explain what I *think* I understand at this point:

Lookup fields are Lookup and Relationship fields where you type in the fields you want available in the dropdown box??? As opposed to pulling them from a table?

I think I also understand that you have to use a particular one of these if you are building an online database, which I am not doing and do not expect to ever do.

In the back of my mind something is shouting "value fields", is that related to this subject or am I really lost?

Thanks

jeds is offline   Reply With Quote
Old 12-01-2012, 03:08 PM   #68
reyvr24
Newly Registered User
 
Join Date: Dec 2012
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
reyvr24 is on a distinguished road
Re: The Ten Commandments of Access

I really enjoy reading this thread Though I have learned already some of this commandments the hard way, it's nice to know that there is logic behind all the challenges in creating a good database.
reyvr24 is offline   Reply With Quote
Old 12-01-2012, 07:53 PM   #69
MartinC
Newly Registered User
 
Join Date: Nov 2012
Posts: 3
Thanks: 2
Thanked 0 Times in 0 Posts
MartinC is on a distinguished road
Re: The Ten Commandments of Access

I've seen numerous databases where the programmer had spaces in the names. I've done that a few times, too, and haven't encountered any problems. What is the downside to spaces in names?
MartinC is offline   Reply With Quote
Old 12-01-2012, 10:30 PM   #70
John Big Booty
AWF VIP
 
John Big Booty's Avatar
 
Join Date: Aug 2005
Location: Planet 10, by way of the Eighth Dimension
Posts: 8,263
Thanks: 113
Thanked 1,012 Times in 865 Posts
John Big Booty is a jewel in the rough John Big Booty is a jewel in the rough John Big Booty is a jewel in the rough
Re: The Ten Commandments of Access

Quote:
Originally Posted by MartinC View Post
I've seen numerous databases where the programmer had spaces in the names. I've done that a few times, too, and haven't encountered any problems. What is the downside to spaces in names?
If you have spaces embedded in object names then when they are referenced (in VBA code) the name must be enclosed within square brackets, which are not required if spaces are not used.
__________________
...but they're only monkey boys!!!
John Big Booty is offline   Reply With Quote
Old 12-02-2012, 12:57 AM   #71
Rabbie
Super Moderator
 
Rabbie's Avatar
 
Join Date: Jul 2007
Location: Returning to Scotland
Posts: 5,906
Thanks: 110
Thanked 76 Times in 68 Posts
Rabbie is a jewel in the rough Rabbie is a jewel in the rough Rabbie is a jewel in the rough
Re: The Ten Commandments of Access

Quote:
Originally Posted by jeds View Post
OK, I would like to understand the reasoning behind this one. I have read this elsewhere, but as a newbie the explanation did not sink in. To explain what I *think* I understand at this point:

Lookup fields are Lookup and Relationship fields where you type in the fields you want available in the dropdown box??? As opposed to pulling them from a table?

I think I also understand that you have to use a particular one of these if you are building an online database, which I am not doing and do not expect to ever do.

In the back of my mind something is shouting "value fields", is that related to this subject or am I really lost?

Thanks
This refers to lookup tables in Tables not in forms. Look-ups in tables just make things difficult as you don't see what is actually stored.
__________________
The best solution is the simplest one that meets all requirements.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Rabbie is offline   Reply With Quote
The Following User Says Thank You to Rabbie For This Useful Post:
jeds (12-02-2012)
Old 12-02-2012, 01:04 AM   #72
nanscombe
Newly Registered User
 
nanscombe's Avatar
 
Join Date: Nov 2011
Location: Kent, UK.
Posts: 1,082
Thanks: 0
Thanked 256 Times in 249 Posts
nanscombe will become famous soon enough
Re: The Ten Commandments of Access

Quote:
Originally Posted by MartinC View Post
What is the downside to spaces in names?
Until you learn not to do it you leave yourself open to (un)helpful comments as to why you shouldn't.
__________________
Nigel
Ex Tactical Systems developer
nanscombe is offline   Reply With Quote
Old 12-02-2012, 01:47 AM   #73
Lightwave
Ad astra
 
Lightwave's Avatar
 
Join Date: Sep 2004
Location: Edinburgh
Posts: 1,401
Thanks: 123
Thanked 137 Times in 129 Posts
Lightwave will become famous soon enough
Re: The Ten Commandments of Access

Here's another way of explaining it.

For many computer languages a simple space is a special character that generally separates things denoting the end of one thing and the start of another.

Therefore if you have a column which is called The First Field.
Computer languages tend to consider that as three different things they don't recognize context which is something which comes naturally to us.

It's also a reason why you should avoid other special characters eg / naming a file star/wars and then referring to it in code would cause an error as the computer would think you are changing directory.

A more general rule could be avoid special characters when naming objects.
Lightwave is offline   Reply With Quote
The Following User Says Thank You to Lightwave For This Useful Post:
Rabbie (12-02-2012)
Old 12-02-2012, 02:17 AM   #74
ChrisO
Newly Registered User
 
ChrisO's Avatar
 
Join Date: Apr 2003
Location: Brisbane, Australia
Posts: 3,202
Thanks: 7
Thanked 275 Times in 195 Posts
ChrisO is just really nice ChrisO is just really nice ChrisO is just really nice ChrisO is just really nice
Re: The Ten Commandments of Access

To quote MartinC in post #69…

>>I've done that a few times, too, and haven't encountered any problems.<<

If MartinC can put even one space in a name and it works then it would appear that MartinC knows how to do it.

Can anyone produce a sample of the same VBA code or SQL which works sometimes but fails at other times due to a space?

I’m not saying it can’t be done but I would like to see it.

Chris.
__________________
Access 2003, Win7, GMT +10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ChrisO is offline   Reply With Quote
Old 12-02-2012, 02:22 AM   #75
nanscombe
Newly Registered User
 
nanscombe's Avatar
 
Join Date: Nov 2011
Location: Kent, UK.
Posts: 1,082
Thanks: 0
Thanked 256 Times in 249 Posts
nanscombe will become famous soon enough
Re: The Ten Commandments of Access

Indeed, it's easy to use names with spaces.

As long as you are in the habit of enclosing every field / table name etc in square brackets.

__________________
Nigel
Ex Tactical Systems developer
nanscombe is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 97 Linking to tables in Access 2000 Amileaux General 6 10-16-2013 04:55 AM
FTP Upload Module gisash1 General 12 01-21-2010 05:07 AM
Beginner's Guide to ODBC Banana Access FAQs 1 06-18-2009 08:10 PM
User Defined Type - Access 97 to 2000/2002 Mile-O Access FAQs 0 12-01-2005 06:35 AM
Access Charts/Graphs durdle17 Reports 5 10-04-2004 02:42 AM




All times are GMT -8. The time now is 05:00 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World