Yorkiemuncher said:I learnt the 10 Commandments of Access the hard way...and now i live by them,
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.
thou shalt abhor the use of "Lookup Fields" which art the creation of the Evil One.
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?
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.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
What is the downside to spaces in names?
Exactly. Always enclose them in square brackets if you use spaces. Personally I can see no need to have spaces. To me FirstField is just as clear as First Field and also one less char to type 3 less if you include the square brackets. Still whatever people are happy with.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.
1. Ask, "Would an infinite being truly choose this?"
An infinite being could do anything for any reason, otherwise they would be finite
2. Everything is just an interesting point of view
"Thou shalt not ra**, murder or kill", interesting but merely a point of view.
]3. Live in 10 second increments
4. Live as the question (not as the answer)
5. No form, no structure, no significance
No rules? Therefore this list is meaningless
6. No judgment, no discrimination, no discernment
No justice, no punishment, no vengence
7. No drugs of any kind
No penicillin, no aspirin, no insulin
8. No competition
No reason to improve or strive to a goal, stagnation
9. Do not listen to, tell, or buy the story
10. No exclusion