Access 2000 OpenReport arguments

[albert.repasky]

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

 

[Allen Browne]

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.