Syntax to Pass Variables

[Guest]

I want to pass a variable with a report name instead of specific report name
but can't seem to get it to work.

This Works:
Set objRpt = .Reports![DB1_rpt3_control_totals]

How can I replace "DB!_rpt3_control_totals" with a variable, "strReportName"?

This Does not work:
Set objRpt = .Reports![& """ strReportName """ &]

What is the correct syntax?

Note: I am trying to evaluate the "Pages" of a report that is open and in
preview mode. The report is in an external database, not the current
database.

Thank You

Ross

 

[Guest]

Set objRpt = .Reports!['" & strReportName & "']"

Notice single quotes - If that doesn't work try

Set objRpt = .Reports![" & strReportName & "]"

 

[Guest]

Klatuu,

No Luck.

Thank you.

Set objRpt = .Reports!['" & strReportName & "']"

Notice single quotes - If that doesn't work try

Set objRpt = .Reports![" & strReportName & "]"

I want to pass a variable with a report name instead of specific report name
but can't seem to get it to work.

This Works:
Set objRpt = .Reports![DB1_rpt3_control_totals]

How can I replace "DB!_rpt3_control_totals" with a variable, "strReportName"?

This Does not work:
Set objRpt = .Reports![& """ strReportName """ &]

What is the correct syntax?

Note: I am trying to evaluate the "Pages" of a report that is open and in
preview mode. The report is in an external database, not the current
database.

Thank You

Ross

 

[Ken Snell [MVP]]

Try this, assuming
(1) that the . in front of Reports is because you have a "With
DatabaseObjectName" prior to it
(2) that strReportName is the name of the report

Set objRpt = .Reports(strReportName)

--

Ken Snell
<MS ACCESS MVP>

Klatuu,

No Luck.

Thank you.

Set objRpt = .Reports!['" & strReportName & "']"

Notice single quotes - If that doesn't work try

Set objRpt = .Reports![" & strReportName & "]"

I want to pass a variable with a report name instead of specific report
name
but can't seem to get it to work.

This Works:
Set objRpt = .Reports![DB1_rpt3_control_totals]

How can I replace "DB!_rpt3_control_totals" with a variable,
"strReportName"?

This Does not work:
Set objRpt = .Reports![& """ strReportName """ &]

What is the correct syntax?

Note: I am trying to evaluate the "Pages" of a report that is open and
in
preview mode. The report is in an external database, not the current
database.

Thank You

Ross

 

[Guest]

Ken


It Works!

I have learned that it is only simple when you KNOW the answer.

Thank you so much!

Ross

Try this, assuming
(1) that the . in front of Reports is because you have a "With
DatabaseObjectName" prior to it
(2) that strReportName is the name of the report

Set objRpt = .Reports(strReportName)

--

Ken Snell
<MS ACCESS MVP>

Klatuu,

No Luck.

Thank you.

Set objRpt = .Reports!['" & strReportName & "']"

Notice single quotes - If that doesn't work try

Set objRpt = .Reports![" & strReportName & "]"

:

I want to pass a variable with a report name instead of specific report
name
but can't seem to get it to work.

This Works:
Set objRpt = .Reports![DB1_rpt3_control_totals]

How can I replace "DB!_rpt3_control_totals" with a variable,
"strReportName"?

This Does not work:
Set objRpt = .Reports![& """ strReportName """ &]

What is the correct syntax?

Note: I am trying to evaluate the "Pages" of a report that is open and
in
preview mode. The report is in an external database, not the current
database.

Thank You

Ross

 

[Ken Snell [MVP]]

You're welcome.
--

Ken Snell
<MS ACCESS MVP>

Ken


It Works!

I have learned that it is only simple when you KNOW the answer.

Thank you so much!

Ross