[AccessD] Create a .lib library for use with Access

[Arthur Fuller]

Stuart,

Thanks for the link. I read another of his pieces, and learned the solution
to a completely unrelated issue, as well.

On Tue, Mar 21, 2023 at 6:28 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Good article here on how to build and use them:
>
> https://www.devhut.net/ms-access-library-databases/
>
> On 21 Mar 2023 at 11:55, Arthur Fuller wrote:
>
> > Thanks, Jim. That's what I thought, but I couldn't remember the file
> > name extension.
> >
> > On Tue, Mar 21, 2023 at 7:36AM Jim Dettman via AccessD <
> > accessd at databaseadvisors.com> wrote:
> >
> > >
> > > A "lib" file in Access with VBA code is put in a .accda or .mda
> > > file.
> > >
> > > It can include any Access object (tables, forms, reports, etc) and
> > > have VBA code.
> > >
> > > You create it with Access and VBA just as you would normally and
> > > write VBA code.   Once saved, you then use it in other apps by
> > > setting a reference to it or using it as an add-in.  This is the way
> > > all the built-in Wizards work in Access.  The Zoom box for example
> > > that you get when you hit Shift/F2 is in a library database.
> > >
> > > In regards to a .dll or type lib, you create those in something
> > > else, then either write a DECLARE in your code, or set a reference
> > > to it in your app, then make calls/use it.   But there's no VBA
> > > associated with it.
> > >
> > > HTH,
> > > Jim.
> > >
> > > -----Original Message-----
> > > From: AccessD On Behalf Of Arthur Fuller
> > > Sent: Tuesday, March 21, 2023 5:29 AM
> > > To: Access Developers discussion and problem solving <
> > > accessd at databaseadvisors.com>
> > > Subject: Re: [AccessD] Create a .lib library for use with Access
> > >
> > > Ok, I'm wrong. But I thought John Colby has created one, consisting
> > > of VBA code. Maybe I misunderstood; it wouldn't be the first time.
> > > But I was given to understand that one could collect a bunch of
> > > reusable code and package it. Maybe John meant that he references
> > > it, although if it's not a .Lib file or a .DLL, then I have no clue
> > > as to how one might reference it. It seems a shame to gather all
> > > that reusable code and then have to import it into the next app one
> > > is going to write. But I guess if that's what's required, ok, I'll
> > > do it that way. Creating an Add-In seems totally wrong. (Actually, I
> > > am creating an Add-In, but it has a form as well as some modules, so
> > > that's quite another kettle of fish; easy enough to implement,
> > > though.
> > >
> > > On Tue, Mar 21, 2023 at 3:47AM Stuart McLachlan
> > > <stuart at lexacorp.com.pg> wrote:
> > >
> > > > How do you expect to use a .lib file in Access?
> > > >
> > > > If we are talking about same thing, a .lib is a file which is
> > > > statically linked  into an application at compile time. (And
> > > > that's a realy compile to a .exe file - not what Access does with
> > > > VBA code)
> > > >
> > > > It's essentailly the same as a DLL wrapped inside an executable
> > > > file.
> > > >
> > > >
> > > >
> > > > On 21 Mar 2023 at 2:35, Arthur Fuller wrote:
> > > >
> > > > > I'm having lousy luck searching for this. I keep getting hits
> > > > > that tell me how to create a library database, not a .lib file.
> > > > >
> > > > > Suggestions?
> > > > >
> > > > > --
> > > > > Arthur
> > > > > --
> > > > > AccessD mailing list
> > > > > AccessD at databaseadvisors.com
> > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > Website: http://www.databaseadvisors.com
> > > > >
> > > >
> > > >
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > >
> > >
> > > --
> > > Arthur
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur