Open PageSetup Using Code - Access 2000
Posted on 2009-04-29
I have an Access 2000 database which is used by multiple users, each with a different printer. A report can be produced from paper trays. Each user must change the report page setup to direct it to a partivular paper tray. The following code works well is I use Access 2007 to open the database but Access 2000 doesn't like it at all.
DoCmd.SelectObject acReport, "rptP11D_Stage01_Individual", True
DoCmd.SelectObject acForm, "frmReportSetup", False
Can anyone suggest the correct code? I wish to access the page setup from a button on a form. Thank you.