I can't get openargs to work with a report

P

Pro From Dover

I am trying to open a report with the command line DoCmd.OpenReport
"TWOSUM_SCORECARD", acViewNormal, , , , WEEK_NUM

The report opens but when I test Reports!TwoSum_ScoreCard.openargs it
contains a null value. I did check to make sure I am passing a value. What am
I doing wrong???

I am using ACCESS 2003.
 
A

Allen Browne

Was the report already open?

OpenArgs applies only when the report is originally opened.
Even if you have it open in deisgn view, it's already open.
 
A

Arvin Meyer [MVP]

That would probably be because the OpenReport Method does not have an
OpenArgs argument:

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]
 
A

Allen Browne

Still using A2000, eh Arvin? :)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Arvin Meyer said:
That would probably be because the OpenReport Method does not have an
OpenArgs argument:

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Pro From Dover said:
I am trying to open a report with the command line DoCmd.OpenReport
"TWOSUM_SCORECARD", acViewNormal, , , , WEEK_NUM

The report opens but when I test Reports!TwoSum_ScoreCard.openargs it
contains a null value. I did check to make sure I am passing a value.
What am
I doing wrong???

I am using ACCESS 2003.
Click to expand...
Click to expand...
 
K

Klatuu

As of 2003, It does, but the mdb must also have been converted to 2003.
(you can get TV sets in color now, too, Arvin :)
--
Dave Hargis, Microsoft Access MVP


Arvin Meyer said:
That would probably be because the OpenReport Method does not have an
OpenArgs argument:

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Pro From Dover said:
I am trying to open a report with the command line DoCmd.OpenReport
"TWOSUM_SCORECARD", acViewNormal, , , , WEEK_NUM

The report opens but when I test Reports!TwoSum_ScoreCard.openargs it
contains a null value. I did check to make sure I am passing a value. What
am
I doing wrong???

I am using ACCESS 2003.
Click to expand...
Click to expand...
 
A

Arvin Meyer [MVP]

Actually that was from the A 97 helpfile which as we all know is still the
best. Looking at that from 2003, I see the 3 additional arguments.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Allen Browne said:
Still using A2000, eh Arvin? :)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Arvin Meyer said:
That would probably be because the OpenReport Method does not have an
OpenArgs argument:

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Pro From Dover said:
I am trying to open a report with the command line DoCmd.OpenReport
"TWOSUM_SCORECARD", acViewNormal, , , , WEEK_NUM

The report opens but when I test Reports!TwoSum_ScoreCard.openargs it
contains a null value. I did check to make sure I am passing a value.
What am
I doing wrong???

I am using ACCESS 2003.
Click to expand...
Click to expand...
Click to expand...
 
Top