how and where do i declare a global variable?

[jeffmoore]

How and where do i declare a global variable?

 

[TLady]

You create module _Global
And here you write under

Option Compare Database
Option Explicit

Public Const RL2ID = "TIA"
Public ReportStartDate As Variant (if you need datatype)
Public Const ContractStartDate = #7/1/2002#
Public Const TemplateFileName As String = "ExcelFileName - YYYYMMDD.xls"

Ask if you need to know more
I have a lot to share on this subject

TIA

 

[TLady]

Or even better - tell what you are trying to do

 

[jeffmoore]

Thanks for the fast response.
I'm not sure how to create 'module_global'
I need a global variable as it is easier than having to pass the var several times.
TIA

 

[TLady]

OK,
open up Access and click on Tab "Module"
then button "New" and Save it as _Global.
Open Up and you'll see

Option Compare Database
Option Explicit

Public YourVariableName As String (or whatever you need to be)

Then next step

Function GetYourVariableName()
GetYourVariableName = "HappyNewYear"
End Function

After this whenever you need "HappyNewYear" value - you can use YourVariableName or GetYourVariableName

Again, if you were more specific - I could help better

TIA

 

[jeffmoore]

I got it to work thanks again