WHAT IS A MODULE? WHEN SHOULD I USE IT?

[Gilberto Lawas via AccessMonster.com]

I see the module option in my Access program but I've never used it. Most
of my work is done though Design View, Query Builder, Expression Builder,
Macro Builder.

The other day however a friend asked me to modify a Database she was using
at work. I opened it up and found a series of tables, forms, and reports.
No Macros, No real Queries.. It did have a few Modules though, and it
grouped and manipulated data in ways I haven't seen before. Needless to
say I couldn't help my friend.

Can someone explain in one or two sentences what a Module is? And should I
be using them?

r/s
clueless

 

[Rick Brandt]

I see the module option in my Access program but I've never used it.
Most of my work is done though Design View, Query Builder, Expression
Builder, Macro Builder.

The other day however a friend asked me to modify a Database she was
using at work. I opened it up and found a series of tables, forms,
and reports. No Macros, No real Queries.. It did have a few Modules
though, and it grouped and manipulated data in ways I haven't seen
before. Needless to say I couldn't help my friend.

Can someone explain in one or two sentences what a Module is? And
should I be using them?

r/s
clueless

It's a container for VBA "stuff". In it you will find sub-routines,
functions and variable declarations.

Similar to the code module for a form or a report except that the code in
those can only be used when that particular form or report is open and even
then only if the sub or function is declared as Public. The stuff in a
standard module can be called from anywhere in the app so if you have code
stuff that you need to use anywhere in the app you place it in a standard
module.

If you're doing most of your work with macros then that is why you haven't
had need of a module yet.

 

[Gilberto Lawas via AccessMonster.com]

Thanx again Rick.

/bow

 

[TaNaia Dunigan]

Hello Gilberto I have been trying to locate you for some time. Email me
(e-mail address removed). 309-232-5079. TaNaia. I wouldn't know how to solve
that problem.If u r not gilberto lawas will u please forward this info