Download Total Access Statistics User Manual
Transcript
Preparing Your Database Library Reference To use a function in a library database, you need to create an explicit reference from your database to the library. Handle this by putting a module in design mode, and invoking the VBA Editor’s Tools, References menu: Access Library References Selection Make sure Total Access Statistics is selected. If it does not appear in the list, use the [Browse] button to locate the library file (TASTAT_R.MDE or TASTAT_R.ACCDE) in your installation directory. The reference is an explicit path, which means if you change the drive or location of the library, the reference is broken and the function calls will not compile. You can programmatically add library references with the AddFromFile command. This example adds a reference to the file name in the strFileName variable: Dim ref As Reference Set ref = References.AddFromFile(strFileName) Please refer to the VBA help file for more information on reference commands. 156 Chapter 11: Advanced Topics Total Access Statistics