How do I add a reference?

[mathisjay]

I need to be able to use the CUMIPMT() function that is part of the Analysis Toolpak add-in for Excel.

I see that Access already has some financial calculations such as PMT(), IPMT(), and PPMT(), but CUMIPMT() is missing. In order to get it to work with Excel, I had to install the Analysis ToolPak Add-in.

How do I do the same thing for Access?

 

[Pat Hartman]

Open any code module (create a new empty one if you don't have any). Then go to Tools/References. If the library has been properly registered it should show up in the list. Just scroll to it and check the box next to it.