Access 2000 Add-ins

[Jayashree Krishna]

Hi,

I have a Accounts.mda file which contains one form and few functions which
would be called from the form. I want to install this feauture as a add ins
from the menu. I added the following records in USysRegInfo table of
accounts.mda file

Subkey Type Valname value
"HKEY_CURRENT_ACCESS_PROFILE
\Menu Add-Ins\Findstr" 0

"HKEY_CURRENT_ACCESS_PROFILE
\Menu Add-Ins\Findstr" 1 Expression =Findstring()
"HKEY_CURRENT_ACCESS_PROFILE

\Menu Add-Ins\Findstr" 1 Library C:\Documents and
Settings\sjayashr\Application Data\Microsoft\AddIns\test.mda

"HKEY_CURRENT_ACCESS_PROFILE
\Menu Add-Ins\Findstr" 4 Version 3

I compiled the code in accounts.mda. I kept the account.mda file in D:/. I
added it from Testmain.mdb file, add-in-manager. It's getting installed
properly and the account.mda file is available in the library location given
above.

But when I clicked this "Findstr" from the Testmain.mdb, I am getting the
following error.

"Microsoft access can't find the wizard or there is a syntax error in the
declaration
section of the visual basic module. The wizard you need may be missing from
the
libraries section of the microsoft access section of the windows registry..."

Why I am getting this error? What else should I do to call a function in the
add-in database from the menu? Please help me to solve this /

 

[Cindy M.]

Hi =?Utf-8?B?SmF5YXNocmVlIEtyaXNobmE=?=,

I have a Accounts.mda file which contains one form and few functions which
would be called from the form. I want to install this feauture as a add ins
from the menu.

Since you haven't received a response here, you might try asking your question
in an ACCESS-specific newsgroup such as

http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.access.m
odulesdaovba&lang=en&cr=US

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Jayashree Krishna]

Hi,

I got the answer. I have declared the calling function with Private sub
instead of Public function. When I used the public function code everything
worked out