(Warning - Stupid question) What is a module?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What exactly is a Module? I'm looking for the big picture explanation. What
is it & what is its purpose in life? I suspect that I've been writing some
here & there, but I'm flying by the seat of my pants, cutting & pasting like
mad. But I'm missing the world view here. Anybody?

thx
sr
 
If you do not know, the question is not stupid.
From Access 2007 help:
Modules, like macros, are objects you can use to add functionality to your
database. Whereas you create macros in Access by choosing from a list of
macro actions, you write modules in the Visual Basic for Applications (VBA)
.... programming language. A module is a collection of declarations,
statements, and procedures that are stored together as a unit......
 
Simply put? A module is a set of code accessible from anywhere in your
project. A class object, on the other hand, is more locally defined (to a
form or report, e.g.).
 
ah! so I have been writing class objects. Exactly what I wanted to know.
thanks. I was wondering why I kept writing the same code over & over on
different forms.
I'll research how I convert some of my redundant code over to modules.
Thanks so much for your help.
 
Back
Top