Access 2007 Bible

Prev | Current Page 2025 | Next

Michael R. Groh, Joseph C. Stockman, Gavin Powell, and Cary N. Prague

"Access 2007 Bible"

The library reference is stored within the Access database file and should not have
to be reset unless the location of the library file changes.
Also, the exact path to the library database is stored in the application database. This means that if
the library database is moved, renamed, or unavailable at runtime, calls to functions and objects in
the library database will fail. Be sure to adequately trap and handle such errors.
Programming references
Perhaps the easiest way to add references, or at least ensure that references are included in your
Access applications at runtime, is to add a little bit of code that adds the reference to the current
database:
Public Sub AddLibraryReference()
On Error Resume Next
References.AddFromFile(??????)
End Sub
The On Error Resume Next is a little bit of a cheat. Access raises an error if you add a reference
that already exists in the database. Putting On Error Resume Next above the statement that adds
the reference instructs Access to ignore this error.

Pages:
2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037

Cytherea (page 263) The Abbot (page 233) to political society (page 173)

Free E-Books

Michael R. Groh, Joseph C. Stockman, Gavin Powell, and Cary N. Prague

"Access 2007 Bible"