I can't get openargs to work with a report

  • Thread starter Thread starter Pro From Dover
  • Start date Start date
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.
 
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.
 
That would probably be because the OpenReport Method does not have an
OpenArgs argument:

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]
 
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.
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OpenArgs 3
Access OpenArgs in Access 2010 failing 0
Cant get a report to print 9
multiple openargs 1
OpenArgs question 2
OpenArgs Problem 2
OpenReport & OpenArgs 2
printing 1 sheet of report 1

Back
Top