Free E-Books

A good convention to follow is to use a special prefix for function and object names in the library
database. For instance, you may use your initials or lib as a prefix to make sure all objects in the
library have unique names. If, by coincidence, a library function or library object has the same
name as a function or object included in an application, an error occurs.
Library Database Object References
Perhaps the most common problem associated with library databases is keeping object references
straight. For instance, if a function in a library database refers to a table, is the table found in the
application database or in the library database?
Access follows these rules when referring to objects in library databases:
n Bound controls, forms, and reports are always bound to record sources (tables and
queries) in the library database. Access always searches the library database when
1087
Reusing VBA Code with Libraries 33
trying to resolve a record-source reference. If the record source cannot be found, an error
occurs.


Pages:
2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044