Functions

  • Thread starter Thread starter Spencer.Sadkin
  • Start date Start date
S

Spencer.Sadkin

Is there something in access similar to the personal workbook for
excel? I

I want to have my modules (because they contain functions) available
in any database that i may open. The closest alternative ive found so
far is to create a database that contains all my modules and then
import them as necessary to individual databases. Thanks a lot in
advance.
 
Is there something in access similar to the personal workbook for
excel? I

I want to have my modules (because they contain functions) available
in any database that i may open. The closest alternative ive found so
far is to create a database that contains all my modules and then
import them as necessary to individual databases. Thanks a lot in
advance.
Click to expand...

The correct way with Access is to create a database to hold all your
modules, place it in a 'common' folder (ie not along with an application),
then set a reference to it from each database that requires it's
functionality. To do this, open the VB editor, drop down the Tools menu,
select 'References' and click the Browse button. In the file dialog, change
the 'Files of Type' to *.mdb and navigate to your file. That's it, you
should now be able to call it's public procedures as if they were contained
in the current database.

An mdb file used in this manner is called a Library database.
 
See my Add-in Tips, Hints and Gotchas page athttp://www.granite.ab.ca/access/addins.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
Click to expand...

I set up the database using References, which worked. However now when
the other user has Access open I get a "do not have exclusive rights"
error so I cant update the functions. How can I remove the reference
from his computer? When i go back into tools>references there is no
box for the database that i referenced to be unchecked.

Thanks
 
I set up the database using References, which worked. However now when
the other user has Access open I get a "do not have exclusive rights"
error so I cant update the functions.
Click to expand...

You should be working with the references MDB on your own system.
Once it's ready you make it available on the server for the others to
download as required. Don't share the MDB/MDE on the server.

This is where utilities such as the Auto FE Updater come in handy.
How can I remove the reference
from his computer? When i go back into tools>references there is no
box for the database that i referenced to be unchecked.
Click to expand...

Now that's interesting. I have no idea.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top