Max Wanadoo
max.wanadoo at gmail.com
Tue Mar 31 16:01:56 CDT 2009
Hi Susan, I don't know the answer but if you set a Reference to Microsoft Access 12 Object Library then it will probably compile ok. Whether it works or not is another matter hth Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: 31 March 2009 21:12 To: AccessD at databaseadvisors.com Subject: [AccessD] Getting error of Ribbon argument Private Sub Command0_Click() 'Hide 2007 Ribbon. DoCmd.ShowToolbar "Ribbon", acToolbarNo End Sub Private Sub Command1_Click() 'View 2007 Ribbon. DoCmd.ShowToolbar "Ribbon", acToolbarYes End Sub Trying to apply these and both arguments generate a run-time error in Word 2007 -- says variable not defined. The Office 12 Object Library is referenced. Works fine in Access 2007 -- is this capability not available in all the 2007 apps? Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com