Free E-Books

CAUTION
NOTE
448
Programming Microsoft Access Part II
Very often you have to manually enter the square brackets, quotation marks, or pound sign delimiters
around identifiers to make sure Access understands what you mean.
Entering object names
Object names are identified by placing brackets ([]) around the element. Although the brackets
are usually optional, Access requires the use of brackets when the object contains a space or punctuation
in its name (like a dash). If these conditions are not present, you can ignore the brackets??”
Access inserts them automatically. The following expressions are syntactically identical:
Buyer & [Sales Person ID]
[Buyer] & [Sales Person ID]
The field name SalespersonID was changed in the previous example to Sales
Person ID; placing spaces between the names demonstrates how to use brackets
around the field name when it contains spaces. The example databases on this book??™s CD do not use
spaces in object names.
Notice that in both cases the brackets are placed around Sales Person ID because this object
name contains spaces.


Pages:
929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953