Global Data?

[nathan sanders]

Hi,

Is there a way of storing a global variable, suach as a month/year so that i
can use that in reports and queries without having to declare/change it in
every instance

Cheers

Nathan

 

[Graham R Seach]

Nathan,

You can declare a public variable (or variables) in a standard module:
Public g_iMonth As Integer
Public g_iYear As Integer

Then put a value into it from anywhere (except queries)
g_iMonth = intMyMonth
g_iYear = intMyYear

Or you can put it all in the one variable:
Public g_sMonthYear As String

....and refer to it like so:
g_sMonthYear = Format(intMyMonth, "00") & Format(intMyYear, "2000")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[John Vinson]

Hi,

Is there a way of storing a global variable, suach as a month/year so that i
can use that in reports and queries without having to declare/change it in
every instance

In addition to the global variable approach Graham suggests, one idea
is to have an always-open Form (such as a switchboard) with textboxes
for such generally used information. You can then refer to

=[Forms]![frmSwitchboard]![txtYear]

in your queries.

John W. Vinson[MVP]

 

[Nathan Sanders]

Thank you Graham.

Nathan,

You can declare a public variable (or variables) in a standard module:
Public g_iMonth As Integer
Public g_iYear As Integer

Then put a value into it from anywhere (except queries)
g_iMonth = intMyMonth
g_iYear = intMyYear

Or you can put it all in the one variable:
Public g_sMonthYear As String

...and refer to it like so:
g_sMonthYear = Format(intMyMonth, "00") & Format(intMyYear, "2000")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Nathan Sanders]

Thanks John.

Hi,

Is there a way of storing a global variable, suach as a month/year so that
i
can use that in reports and queries without having to declare/change it in
every instance

In addition to the global variable approach Graham suggests, one idea
is to have an always-open Form (such as a switchboard) with textboxes
for such generally used information. You can then refer to

=[Forms]![frmSwitchboard]![txtYear]

in your queries.

John W. Vinson[MVP]