[AccessD] Code Librarian /was Thanks

Charlotte Foust cfoust at infostatsystems.com
Fri Jan 31 17:40:00 CST 2003


I tend to have several libraries, including the one that comes with
Office Developer, which has the sample code in it from the help files.
I also have a WIP library for the stuff that isn't ready for Prime Time
yet.

Charlotte Foust

-----Original Message-----
From: John Bartow [mailto:john at winhaven.net] 
Sent: Friday, January 31, 2003 2:36 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Code Librarian /was Thanks


I categorize it a number of different ways so that I can keep it one db.
I keep the actual code snippets in a memo field so for about 600
snippets and the various info invloved its only about 3MB.

I could see splitting it up for VB, C, Java for different languages
though.

JB


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte Foust
Sent: Friday, January 31, 2003 4:08 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Code Librarian /was Thanks


One way of handling that would be to have multiple databases for
different kinds of things.  For instance, I have a category in my
CodeLib that I call Information and I put snippets of things in there
that otherwise I may not remember, like the method for getting the hWnd
of a control or how to use the Recordset.Name property of a DAO
recordset to retrieve the SQL used to create it.  Or we might have a
separate database for DAO code and one for ADO code.  Of course, then
we'd need a way to cross index them .... <vbg>

Charlotte Foust

-----Original Message-----
From: David McAFee (Home) [mailto:dmcafee at pacbell.net]
Sent: Friday, January 31, 2003 11:03 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Code Librarian /was Thanks


Sounds like a great idea, however, what would we post, code and
keywords? or would there be some database passed around? IT seems as if
most already put "keeper" code in them as it is when they see useful
code. Rather than re-invent the wheel, I believe it is best to keep it
as is and have a group of people that update a master copy that is made
available for download on the accessD website. This way anyone who wants
it can download it and use it as is, through the native engine. The only
trouble is, who will update it, and who chooses what is good enough to
put in the db? Some advance programmers might think that something is
not worthwhile to place in this db, OTOH, what if it gets filled with
useless stuff?

Will they be simply cutting and pasting code from their project that
works, using their variables and filed names:


    Me!lstCompaniesFound.RowSource = "EXEC stp_002A_CompanyNameSearch '"
& Me!txtCompanyNameEntry.Text & "'"


 or will the code be cleaned up as such:

    Me!YourListBoxNameHere.RowSource = "EXEC YourStoredProcedureNameHere
'" & Me!YourEntryTextBox.Text & "'"

Will we be asking for full commenting (No War and Peace) of code?

just a few thoughts,

David McAfee


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Lembit Soobik
Sent: Friday, January 31, 2003 7:58 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Code Librarian /was Thanks


Sure, Pedro,
a great idea. Would you participate, or maybe even lead that team?

Lembit

Lembit Soobik
lembit.soobik at t-online.de
----- Original Message -----
From: <pedro at plex.nl>
To: <accessd at databaseadvisors.com>
Sent: Friday, January 31, 2003 11:55 AM
Subject: RE: [AccessD] Code Librarian /was Thanks


> Hello Group,
>
> isn't it a good idea to make a Code Librarian database, as AccessD 
> group,
with
a lot of examples of codes and expressions, which also can be searched
with keywords and can run as a normall .MDB. Just a thought.
>
> Pedro Janssen
>
>
> In antwoord op:
>
> > From: "Charlotte Foust" <cfoust at infostatsystems.com>
> > To: <accessd at databaseadvisors.com>
> > Date: Thu, 30 Jan 2003 15:38:28 -0800
> > Subject: RE: [AccessD] Code Librarian /was Thanks
> >
> >
> > This is a multi-part message in MIME format.
> >
> >It's designed to be an add-in, not something you run direct.  If you
> open it as an add-in, it doesn't ask for a password.
>
> Charlotte Foust
>
> -----Original Message-----
> From: Software Design & Solutions Pty Ltd. 
> [mailto:SDSSoftware at Optusnet.com.au]
> Sent: Thursday, January 30, 2003 3:02 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Code Librarian /was Thanks
>
>
> Why is it prompting me for a password if this part of the developer 
> tools?
>
> Kath
>
> ----- Original Message -----
> From: David McAFee (Home) <mailto:dmcafee at pacbell.net>
> To: accessd at databaseadvisors.com
> Sent: Friday, January 31, 2003 8:32 AM
> Subject: RE: [AccessD] Code Librarian /was Thanks
>
> A bitchin' little tool that comes with Office Developer (started in 
> A2K, I believe). I just started using it this past year, and its 
> really neat! It can be shared amongst developers. Its a little db that
> holds sample code
> (instead of saving it as a bunch of little notepad files
> like I used to) :).
>
> You get to it by clicking on Start -> Programs ->
> Microsoft Office 2000
> Developer - > Code Librarian
>
> David McAfee
>
> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]On Behalf Of
> Tom Adams
> Sent: Thursday, January 30, 2003 1:22 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Code Librarian /was Thanks
>
>
> CodeLib.mdb - Who, where, cost????
>
> Thanks Tom
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list