Using VBA to open reports in Access 2000, 97

[Joe4]

I have written some VBA code my computer in Access 2002. Essentially, I am simply attempting to open a Report in Print Preview mode. This is my code:

DoCmd.OpenReport "rpt Rolodex", acViewPreview, "", "", acNormal

Someone using Access 2000 or Access 97 get errors when this code is run, and it highlights this line.

Does this command not work on earlier versions? Could someone tell me what code to use to open forms in Access 2000/97?

Thanks.

 

[Dugantrain]

Your syntax looks ok, but try taking out the empty strings so that your code looks like:

DoCmd.OpenReport "rpt Rolodex", acViewPreview, , , acNormal

 

[Joe4]

Thanks for the reply. I just found the answer I need.

I actually got the original code by writing a Macro on 2002 to open the report, then did the utility to "Convert the Macro to Code".

I recreated it on the computer using Access 2000, and the argument very similar, except with one less argument:

DoCmd.OpenReport "rpt Actions", acPreview, "", ""

When I change it to this code, it works fine on both Access 2000 and Access 2002.

Forget any mention of Access 97. Access 97 won't even open a database made in Access 2002.