Defining a variable

B

Biggles

I am having trouble with something I think is simple. Here is what I want to
do. I want to create a module that is simply a list of my commonly used
pieces of information, which I only currently have one, but nonetheless, I
want to use that in many queries, forms, reports. How should I set up the
module and then how do I reference it elsewhere. Right now, I simply have:

txtPLAN_YR = "2006"

in several places. I want to make that go away. Please help.
 
J

John Nurick

Hi Biggles,

Many of my databases have a module called vbGlobals which contains
(among other things) constant declarations for this sort of thing:

Public Const COMPANY_NAME = "Acme Firework Corp"

Another approach - if this is data that changes from time to time - is
to have a table for your settings:

tblSettings
SettingName - Text, primary key
SettingValue - Text

with records such as
"Plan Year", "2006"

You can then use DLookup() to retrieve the value wherever it's needed.
 
B

Biggles

Of course, my first reply is "Wow, you got to work on Acme Firework?" Sorry,
had to be said.

I would like to use that public const method, but how do I reference in
other modules? Is it something like

VBGLOBALS.COMPANY_NAME

?
 
J

John Nurick

As long as it's declared in an ordinary module (as against a form or
class module), just use COMPANY_NAME.

The capital letters aren't compulsory: I like to use them to make it
clear that this is a constant; I'd use CompanyName or strCompanyName for
a variable.
 
T

Tim Ferguson

The capital letters aren't compulsory: I like to use them to make it
clear that this is a constant; I'd use CompanyName or strCompanyName for
a variable.
Click to expand...

Of course, strict Hungarian would make this gc_strCompanyName


Tim F
 
Top