Access' answer to Personal.xls for macros?

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

Access 2003

What is the smartest procedure to have macros easily available to loaded projects. Similar to
Excel's Personal.xls?

I do realize that Access permits only one project per Access instance.

That said, their may be a way to have the best of all worlds? If the answer is no, I would like to
know that.

TIA Dennis
 
Dennis said:
Access 2003

What is the smartest procedure to have macros easily available to
loaded projects. Similar to Excel's Personal.xls?

I do realize that Access permits only one project per Access instance.

That said, their may be a way to have the best of all worlds? If the
answer is no, I would like to know that.
Click to expand...

I could be wrong, but I don't think you can easily do this with macros,
as opposed to VBA routines. With VBA, you can create a library database
that contains one or more modules with your common library routines, and
then set a reference to that database in each new project. You would
set that reference using the VB Editor's Tools -> References... dialog.
Another alternative that is almost the same is to save your library
database as an Access Add-In (".mda" file) which you can then install
for each new database by using the Add-in Manager (Tools -> Add-Ins).
 
database as an Access Add-In (".mda" file) which you can then install
for each new database by using the Add-in Manager (Tools -> Add-Ins).
Click to expand...

??? You only need to install once ???

(david)
 
david epsom dot com dot au said:
??? You only need to install once ???
Click to expand...

I'm sure you're right, David. I haven't used add-ins much, so I'm not
really familiar with their ins and outs.
 
Add-ins install as a registry entry: either to the default 'profile'
or (rarely) to the active 'profile'. Installation to the active
'profile' fails if the 'profile' is installed under the runtime key.

A 'profile' is a set of access registry keys loaded instead of the
default set: there is a command line parameter. This allows you to
customize Access for different applications. Access has a list of
installed profiles in the registry (or potentially two lists, if you
use the 'runtime' Access key instead of the normal Access key)

Menus are not part of the Access Profile: they are part of the user
profile. Access may also be customised by loading COM objects via
the menu: I've never done that, so I don't know how that is controlled.

AFAIK, I agree with you: I don't know how you could directly use
macro's from a library.

(david)
 
Back
Top