G
Guest
Hi all, I've had a frustrating few days trying to get access to a subform
that I've added to a library database.
The scenario is this: I've been developing a suite of databases as part of a
'Czech language reference' project, and during the development process have
generated a large number of useful functions, class modules, tables, and
forms, which are often needed in more than one of the satalite databases.
Some of my forms are built from subforms (with associated class modules) that
are exactly the same for more than one of the main forms in my system.
I had been running about deleting and re-importing these objects as I made
fixes, until I found out (to my initial delight!), that Access supported a
mechanism of 'library' databases (see
http://www.microsoft.com/technet/archive/office/office97/maintain/off413ef.mspx?mfr=true).
However, despite the promises in that document, I've been unable to gain
access to forms, macros, queries, etc. in the library database. In fact,
until I came accross the workaround for class modules (see
http://www.mvps.org/access/modules/mdl0034.htm), I was ready to forget the
whole idea!
My immediate need is to connect a form in the main database with a subform
in the library database. The problem is that Access complains it can't find
the subform when I try try to open the main form (it seems not to be able to
see any of the forms, macros, etc. in the library database at all). I've
tried to find some way of proving scope for the subform (eg.
'MyLib.sbfMySubform'), but to no avail.. So my question is, how the heck do I
get access to subforms (and indeed other 'invisible' objects) in the
libraray??
By the way, it appears that Microsoft went out of their way to hide library
objects (see http://support.microsoft.com/kb/160011/en-us for details), but
no explanation or or alternative method of use is offered!! Can anyone help
me before I run out of hair?!
Thanks guys!
Dom.
that I've added to a library database.
The scenario is this: I've been developing a suite of databases as part of a
'Czech language reference' project, and during the development process have
generated a large number of useful functions, class modules, tables, and
forms, which are often needed in more than one of the satalite databases.
Some of my forms are built from subforms (with associated class modules) that
are exactly the same for more than one of the main forms in my system.
I had been running about deleting and re-importing these objects as I made
fixes, until I found out (to my initial delight!), that Access supported a
mechanism of 'library' databases (see
http://www.microsoft.com/technet/archive/office/office97/maintain/off413ef.mspx?mfr=true).
However, despite the promises in that document, I've been unable to gain
access to forms, macros, queries, etc. in the library database. In fact,
until I came accross the workaround for class modules (see
http://www.mvps.org/access/modules/mdl0034.htm), I was ready to forget the
whole idea!
My immediate need is to connect a form in the main database with a subform
in the library database. The problem is that Access complains it can't find
the subform when I try try to open the main form (it seems not to be able to
see any of the forms, macros, etc. in the library database at all). I've
tried to find some way of proving scope for the subform (eg.
'MyLib.sbfMySubform'), but to no avail.. So my question is, how the heck do I
get access to subforms (and indeed other 'invisible' objects) in the
libraray??
By the way, it appears that Microsoft went out of their way to hide library
objects (see http://support.microsoft.com/kb/160011/en-us for details), but
no explanation or or alternative method of use is offered!! Can anyone help
me before I run out of hair?!
Thanks guys!
Dom.