Referencing global constants from reports

[Bruce Saunders]

I must be missing something really basic. I want to set certain global
constants for use across the board in forms and reports. I defined them in as
public constants in a module. The debugging window shows that things are set
right, but I can't seem to get them referenced in the reports themselves.
Hints? Thanks in advance.

 

[Duane Hookom]

Do you have a public function in a standard module that returns the value of
the global constant? Otherwise, how were you attempting to reference them?

 

[Bruce Saunders]

Duane, thanks for your fast response to what is most likely a fundamental
misunderstanding....

Here's what I did in a module called modGlobals

Option Compare Database
Option Explicit

Public Const gClientInits As String = "ABCD"
Public Const gClientName As String = "Client"
Public Const gProprietary As String = "Proprietary and Confidential to " &
gClientInits


I had thought I could refer to these in various reports by setting text
boxes =[gClientInits], etc.

 

[Rick Brandt]

Duane, thanks for your fast response to what is most likely a
fundamental misunderstanding....

Here's what I did in a module called modGlobals

Option Compare Database
Option Explicit

Public Const gClientInits As String = "ABCD"
Public Const gClientName As String = "Client"
Public Const gProprietary As String = "Proprietary and Confidential
to " & gClientInits


I had thought I could refer to these in various reports by setting
text boxes =[gClientInits], etc.

Variables can only be referenced directly from within VBA code. In Queries
and expressions on forms and reports you need to build a function that
returns the value of the variable and then use the function instead.

 

[Duane Hookom]

Thanks Rick,
A function might be:

Public Function GetgClientInits() as String
GetgClientInits=gClientInits
End Function

You can then set a control source property to
=GetgClientInits()

--
Duane Hookom
MS Access MVP
--

Duane, thanks for your fast response to what is most likely a
fundamental misunderstanding....

Here's what I did in a module called modGlobals

Option Compare Database
Option Explicit

Public Const gClientInits As String = "ABCD"
Public Const gClientName As String = "Client"
Public Const gProprietary As String = "Proprietary and Confidential
to " & gClientInits


I had thought I could refer to these in various reports by setting
text boxes =[gClientInits], etc.

Variables can only be referenced directly from within VBA code. In
Queries
and expressions on forms and reports you need to build a function that
returns the value of the variable and then use the function instead.

 

[Bruce Saunders]

Thanks, Duane and Rick - this solved my (current!) problem.
--
Bruce

Thanks Rick,
A function might be:

Public Function GetgClientInits() as String
GetgClientInits=gClientInits
End Function

You can then set a control source property to
=GetgClientInits()

--
Duane Hookom
MS Access MVP
--

Duane, thanks for your fast response to what is most likely a
fundamental misunderstanding....

Here's what I did in a module called modGlobals

Option Compare Database
Option Explicit

Public Const gClientInits As String = "ABCD"
Public Const gClientName As String = "Client"
Public Const gProprietary As String = "Proprietary and Confidential
to " & gClientInits


I had thought I could refer to these in various reports by setting
text boxes =[gClientInits], etc.

Variables can only be referenced directly from within VBA code. In
Queries
and expressions on forms and reports you need to build a function that
returns the value of the variable and then use the function instead.