Syntax for Reports! & GroupLevel

[Andrew]

Hi there:

I can successfully control a report's GroupLevel ControlSource property by
using:

..Reports!rptEE STMT_A.GroupLev el(i).ControlSo urce = "CorpName"

where rptEESTMT_A is the actual name of the Access Report.

However, I have about 75 reports to process. Each report has its own unique
name. I don't want to create 75 different statements to process each of
the reports. For example:

..Reports!rptEE STMT_A.GroupLev el(i).ControlSo urce = "CorpName"
..Reports!rptEE STMT_B.GroupLev el(i).ControlSo urce = "CorpName"
..Reports!rptEE STMT_C.GroupLev el(i).ControlSo urce = "CorpName"
..Reports!rptEE STMT_D.GroupLev el(i).ControlSo urce = "CorpName"
and so on. This is long and tedious.

I created a function that would process each of the reports. I used a
string field called "sReportNam e" that stores the name of the Access Report
and used it in the statement:

..Reports!sRepo rtName.GroupLev el(i).ControlSo urce = "CorpName"

However, VB comes back with an error message saying that: "The report name
'sReportName' you entered is misspelled or refers to a report that isn't
open or doesn't exist.". This means VB does not recognize the string
variable "sReportNam e" actually stores the name of the Access Report.

Can someone please give me suggestions on how to write a function that could
process the reports instead of writing out separate statement for each
Access Report.

Thanks in Advance

Andrew

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try:

..Reports(sRepo rtName).GroupLe vel(i).ControlS ource = "CorpName"

Reports is a collection. See the Access help articles on collections
to understand why the above works.

MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP8egDoechKq OuFEgEQLddwCfWf RgiRfM4kG7sWSHN IU7rM/ZIngAn0uN
GuFe4b4OLvglLiJ 6n1AvdMOX
=/niS
-----END PGP SIGNATURE-----
Andrew wrote:

Hi there:

I can successfully control a report's GroupLevel ControlSource property by
using:

.Reports!rptEES TMT_A.GroupLeve l(i).ControlSou rce = "CorpName"

where rptEESTMT_A is the actual name of the Access Report.

However, I have about 75 reports to process. Each report has its own unique
name. I don't want to create 75 different statements to process each of
the reports. For example:

.Reports!rptEES TMT_A.GroupLeve l(i).ControlSou rce = "CorpName"
.Reports!rptEES TMT_B.GroupLeve l(i).ControlSou rce = "CorpName"
.Reports!rptEES TMT_C.GroupLeve l(i).ControlSou rce = "CorpName"
.Reports!rptEES TMT_D.GroupLeve l(i).ControlSou rce = "CorpName"
and so on. This is long and tedious.

I created a function that would process each of the reports. I used a
string field called "sReportNam e" that stores the name of the Access Report
and used it in the statement:

.Reports!sRepor tName.GroupLeve l(i).ControlSou rce = "CorpName"

However, VB comes back with an error message saying that: "The report name
'sReportName' you entered is misspelled or refers to a report that isn't
open or doesn't exist.". This means VB does not recognize the string
variable "sReportNam e" actually stores the name of the Access Report.

Can someone please give me suggestions on how to write a function that could
process the reports instead of writing out separate statement for each
Access Report.

Thanks in Advance

Andrew

[Andrew]

Thank you for your help. It is working now. I can eliminate a lot of
repetitive codes. : )

"MGFoster" <[e-mail] > wrote in message
news:9e******** ***********@new sread2.news.pas .earthlink.net. ..

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try:

.Reports(sRepor tName).GroupLev el(i).ControlSo urce = "CorpName"

Reports is a collection. See the Access help articles on collections
to understand why the above works.

MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP8egDoechKq OuFEgEQLddwCfWf RgiRfM4kG7sWSHN IU7rM/ZIngAn0uN
GuFe4b4OLvglLiJ 6n1AvdMOX
=/niS
-----END PGP SIGNATURE-----
Andrew wrote:

Hi there:

I can successfully control a report's GroupLevel ControlSource property by using:

.Reports!rptEES TMT_A.GroupLeve l(i).ControlSou rce = "CorpName"

where rptEESTMT_A is the actual name of the Access Report.

However, I have about 75 reports to process. Each report has its own unique name. I don't want to create 75 different statements to process each of the reports. For example:

.Reports!rptEES TMT_A.GroupLeve l(i).ControlSou rce = "CorpName"
.Reports!rptEES TMT_B.GroupLeve l(i).ControlSou rce = "CorpName"
.Reports!rptEES TMT_C.GroupLeve l(i).ControlSou rce = "CorpName"
.Reports!rptEES TMT_D.GroupLeve l(i).ControlSou rce = "CorpName"
and so on. This is long and tedious.

I created a function that would process each of the reports. I used a
string field called "sReportNam e" that stores the name of the Access Report and used it in the statement:

.Reports!sRepor tName.GroupLeve l(i).ControlSou rce = "CorpName"

However, VB comes back with an error message saying that: "The report name 'sReportName' you entered is misspelled or refers to a report that isn't
open or doesn't exist.". This means VB does not recognize the string
variable "sReportNam e" actually stores the name of the Access Report.

Can someone please give me suggestions on how to write a function that could process the reports instead of writing out separate statement for each
Access Report.

Thanks in Advance

Andrew