How do I install Add In

[snowsride]

I have created several functions that are contained within a module called My Functions saved in an Add-In database called MBC_Functions.mda

I want to make the Add In available to other users - how can I do this?

I have tried making entries in the USysRegInfo table of MBC_Functions.mda by following instructions in 'Beginning Access 97 VBA' from Wrox Press but I am doing something wrong.

My version of Acess is stored on my hard drive in a directory named c:\Program files\MSOffice\Access

The MBC_Functions.mda is stored on a network drive R:\ so that it will be available to others.

MBC_Functions is displayed as an available Add-In but I get an error when I try to install it 'The add in could not be installed because it is missing a USysRegInfo table'

Any guidance appreciated.

Thanks

 

[Carol]

Your mda should be installed on the front-end of every pc where the database will be accessing it. It should be stored within the following directory:

C:\Windows\Application Data\Microsoft\AddIns

You will then have to activate this within each users database.

Good luck.

 

[snowsride]

By trial and error I am now able to use the custom functions I have created which are stored as an mda file on the network server - I don't think it's necessary to have the Add In stored on the c: drive. However, the mda is not listed in the Expression Builder i.e. although I can use the functions I can't see them listed - it was displayed one during one of my trial and errors but it's not there now.

I have a feeling the USysRegInf may be the key but MS only refers to its use with wizards and menus not with custom functions.

For clarity I currently have 3 separate functions, one to calculate the average across fields, one to get the maximum value and one to get the minumum value across fields each has it's own function name and they are all stored in My Functions module which is saved in MBC_Functions.mda

Fnally, I don't understand the need for both linking the Add In via Tools, Reference in the Modules tab and Tools, Add Ins in the Query tab the latter doesn't seem to do anything, but if the former is omitted and only the latter used then it doesn't work!

Help