Prev: Set Default Printer at Runtime
Next: printing report from subform selection
From: albert.repasky on 26 Jun 2008 16:23
I am developing with Access 2003. I have some users that are still on
Access 2000. Can someone tell me the arguments for Access 2000 for
OpenReport and how they are different then Access 2003?

I know you use acNormal instead of acViewNormal for 2nd argument. And
I guess there is no 5th argument. It just too hard to find
documentation for the old version.

Thanks ahead of time.

Arep
From: Allen Browne on 26 Jun 2008 22:56
Use the Object Browser to see what you should use.

Open the Immediate Window (Ctrl+G) Type:
DoCmd.OpenReport "Report1",
Now the Intellisense provide a list of arguments:
View as acView = acViewNormal
and the valid arguments are listed vertically.

If you check them in the Object Viewer (F2 in the code member), you will see
that acNormal is a member of acFormView. It actually works because acNormal
(for forms) and acViewNormal (for reports) are both zero, but it's not the
right enumeration. Some members of acFormView (such as acFormDS) don't apply
to reports.

The Intellisense list also shows how many arguments are valid for your
version of Access. FilterName is useless. WhereCondition is invaluable.
WindowMode and OpenArgs are available only in later versions of Access.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<albert.repasky(a)bnymellon.com> wrote in message
news:cffccbb0-620c-4ae9-8b4a-e85a300b6db0(a)f63g2000hsf.googlegroups.com...
>I am developing with Access 2003. I have some users that are still on
> Access 2000. Can someone tell me the arguments for Access 2000 for
> OpenReport and how they are different then Access 2003?
>
> I know you use acNormal instead of acViewNormal for 2nd argument. And
> I guess there is no 5th argument. It just too hard to find
> documentation for the old version.
>
> Thanks ahead of time.
>
> Arep

 | 
Pages: 1
Prev: Set Default Printer at Runtime
Next: printing report from subform selection