Is there an online website or book that I can purchase that tells me when to
use bracets, quotation marks, parenthesis, etc. I have began creating macros
and I'm not sure when to use brackets or quotation marks. Also, is there
something that explains what type of keys to use for formulas, * =
multiplying, etc. Thank you!!!
Press F1 for starters... all of this is in the Access help. Unfortunately the
Access Help SEARCH facility (indexing, table of contents, etc.) has been
woefully inadequate ever since A2000 was released - the info is all there,
but can be a bear to find.
You would use [square brackets] around fieldnames, table names, and form and
report objects, e.g. [Forms]![MyFormName]![SomeTextboxName]; quotes around
text strings to be taken literally; parentheses where syntactically required
("It Just Depends"). Are you in fact using Macros (which are pretty limited)
or Modules (VBA code)?
Here are some general references, wherein you should be able to find links to
more detailed syntax training:
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/
A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html
A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
