Personal "Standard Library" Module of often used functions?

[directormac]

Having been off the forums for a looooong while, I feel the need to get some new discussions going... here's a question for all you guru's out there. Do you have your own "Standard Library" of functions that you have found so useful that you just automatically include them anymore? What are they?

I'm starting to get to that point myself, and here's what mdlMacStdLib has in it so far:

Code & Forms for my progress bar.
IsTable(), etc., based on John K.'s code found in this forum.
public constants: QUOTE, TWIP, TWINCH.
Functions for adding, setting, and fetching values from a variables table.
Ken Getz's functions for handling dialogue boxes.

I will probably be adding some routines for automatic form resizing based on screen res--not something I've used that often, but something I always feel like I ought to include.

What about y'all? I'd be really curious to know the "must have every time" list of functions for Pat H. and the other Access Gods...

--Standard Mac

 

[Mile-O]

I have all sorts of functions that I've done. Rather than a store I usually just plunder another database I have up and running by importing the module/

I prefer, these days, to put them all into Class Modules and use them. I'm always tweaking them as new ideas and needs come in.

My favourites are my date functions for calculating public holidays, times between, amongst other things.

And my Validation class for checking things are valid such as names, email addresses, etc.

 

[directormac]

I prefer, these days, to put them all into Class Modules and use them.

Forgive me showing my ignorance, but I have my reputation as the world's oldest newbie to protect...

When you say "Class Modules", are you referring to something different than a typical VBA module file?

I always plundered old db's as well, but I've grown too tired and lazy anymore to remember which projects used which functions, so now I start a new project by importing from my dedicated "favorite stuff" db.

--Lazy Mac

 

[Pat Hartman]

I keep a couple of "useful" stuff databases and import the code when I need it. I don't import entire modules because I don't like having unused code in a db so I only import the subs and functions that I need to use.

I also have a tool that I'm trying to load all my code into. It is Total Sourcebook by FMS. It comes with a bunch of useful little subs and functions and sample code to use them. The tool shows up as a memu item when you are in the VBA window and it allows you to add your own code to its database.

 

[pono1]

Forgive me showing my ignorance, but I have my reputation as the world's oldest newbie to protect...

When you say "Class Modules", are you referring to something different than a typical VBA module file?

--Lazy Mac

Mac,

I ain't no Access god but I can tell you that class modules are different from other VBA modules. They play a part in a system that attempts to package and standardize code, called object oriented programming (OOP), so that it (the code that follows the rules of OOP) can be reused by yourself or others...

Regards,
Tim

 

[directormac]

OOP in VBA

Having done some VB.NET, some C++, and even some Cocoa, I understand the concept of Classes--what I don't get is (1) if they are handled/stored differently in Access VBA coding than a typical sub or function is and (2) how they fit into an Access/VBA application.

Since each record could be considered an instance of a custom struct, and since most code relating to forms and reports has limited value outside that form or report, I guess I'm not seeing the real benefit of the class/subclass/instance philosophy as it relates to Access projects...

--Dim Mac

 

[Mile-O]

Mac,

here's a class module I've done on this thread regarding the popup calendar.

As for Classes in VB(A) Class Modules they are different from Classes in C++, Java, etc.

Class Modules are used to model objects given them methods and properties and suchlike.

There is no inheritance or object oriented approach with them.

 

[directormac]

I can certainly see the value of having properties and methods at your disposal when creating a custom control such as Mile's--which, by the way, I'm totally going to use as the basis for my own custom date/time picker that will work in a continuous form, unlike MS's ActiveX control. Yet another vote for Mile-O as Most-Helpful-On-High-Next-To-Pat

Is anyone using the class structure elsewhere?

--Curious Mac

 

[GBalcom]

I also have a tool that I'm trying to load all my code into. It is Total Sourcebook by FMS. It comes with a bunch of useful little subs and functions and sample code to use them. The tool shows up as a memu item when you are in the VBA window and it allows you to add your own code to its database.

Hi Pat,
Sorry to Hijack an old thread, but do you still find the sourcebook useful? I'm looking at getting it to help me with my largest app yet, but the price does seem steep...

Thanks,
Gary