Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Defining constants for use in Report objects

Status
Not open for further replies.

jaaret

Instructor
Jun 19, 2002
171
I have several reports that I want to dynamically change the trim colors depending on which client requests the report. How can I set up a Module so that these color values can be called from any report object?

Const NPBlue = 6572321
Const NPRed = 1126546

Const WREBlue = 10244100
Const WRERed = 255

(Etc)


Jaaret
 
Create a standard module, then put those values into it at the declarations section.
Precede the word "Const" with "Public" to make them externally accessible from this module.

Eg:

Public Const NPBlue = 6572321

Thereafter you can then use the values in your code.

John
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top