Creating and using add-ins

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

Dale Fye

I have a program I am currently using for a wide variety
of purposes, which means I have several versions of the
mdb, each of which has additional functionality built in.

I would like to take the core elements of this mdb and
create an Access add-in, so that when I update it, I only
have to change the reference to the add-in, not replace
all the forms, queries and tables associated with it.

Anyone know any books or other resources that address this
subject well?
 
Dale said:
I have a program I am currently using for a wide variety
of purposes, which means I have several versions of the
mdb, each of which has additional functionality built in.

I would like to take the core elements of this mdb and
create an Access add-in, so that when I update it, I only
have to change the reference to the add-in, not replace
all the forms, queries and tables associated with it.

Anyone know any books or other resources that address this
subject well?
Click to expand...


The Access 2002 Developer Handbook has part of a chapter on
how to set the references and a little bit about placing
procedures in modules. This is probably adequate if your
library only contains code modules.

I'm not familiar with enough books to know if there's other
books that go into using forms and reports in a library, but
the general issues are not too complex to figure out. The
first thing to be aware of is that you'll have to create a
library procedure to open the library forms (and another for
reports). The procedure doesn't need to do anthing more
than pass its arguments to the OpenForm/OpenReport method.

A little more complex and subtle issue is how you specify
the record source for the forms and reports. This depends
on the location of the tables involved - in the library, in
the front end or in a back end.
 
Back
Top