Skip to Main Content

DataBank: Library Fund Management Tips & Tools

Note:

You need to take Steps 1-3 whenever you copy the Access document "Fund Management Reports."

If you only copy it once to your C: drive or desktop, you do not need to repeat these steps.

SET YOURSELF UP TO GENERATE FUND MANAGEMENT REPORTS: STEP 1

Go to L:\COLLABORATION\Access DB\Fund Management Reports.
 
Copy the Access document "Fund Management Reports" to your C: drive or desktop. And open it.

STEP 2

Update your Trust Center setting in your local installation of Access. Enable the Macros that power the Selector DB:

 1.  Click on the windows button in the upper left corner of the Access screen and select "Access Options" on the bottom right-hand side of the menu .

 

2.  On the Access Option Menu, click on the "Trust Center."

 3.  In the Trust Center, click on the "Trust Center Settings" button.

 

4.  Within the "Trust Center Settings" menu, click the radio button to enable all macros.

 

 

STEP 3

Update the language key in your ODBC settings to get diacritics to show up correctly in Voyager Reporter:

1.  Go to the Run prompt and enter "regedit".

2.  Open up the following folders in sequence:

                a.  HKEY_LOCAL_MACHINE

                b.  SOFTWARE

                c.  ORACLE

                d.  KEY_OraClient10g_home1

 

See below for examples:

 

 

 

3.  Look in the box to the right and double-click on NLS_LANG:

 

 

4.  Paste the following text over the text you find in NLS_LANG:  AMERICAN_AMERICA.US7ASCII

5.  You should now be able to use diacritics successfully, unless you don't have the Unicode VBA  in your database or the code is bad.  See further available instructions in the L:\COLLABORATION\Access DB\Documentation folder.

STEP 4

Choose the type of report you need. For example, a Transaction Report for Past Fiscal Years:

 
1. Go to L:\COLLABORATION\Access DB\Fund Management Reports
2. Copy the Access document "Fund Management Reports" to your desktop
3. Click on "Transaction Detail for *Any* Fund..." under Other General Use Reports
4. You will be prompted for the fund code and then the fiscal year 
  
 
 

HELP

for Setup or Access or Voyager Help

Thanks

Thank you, Nat Gustafson-Sundell, for all of your work on this.