Bill Patten
bill_patten at embarqmail.com
Mon Apr 9 11:37:23 CDT 2012
I use this solution, (I do it programmatically but do this manually to see if it works for you.) Go to Options then Current Database then make Ribbon name blank, click the menu bar drop down and select your menu and turn off allow built in toolbars. Close the database and re open and I have my menu bar and no ribbon. Allow full menus and allow default Shortcut Menus are both checked. Oh I haven't figured out how to select the Menu Bar programmatically so I select it before I ship. It stays set unless they open it in 2003. By the way, hitting Ctrl and F11 brings back the old File Edit View .... menu we know an love. HTH Bill -----Original Message----- From: Keith Sent: Monday, April 09, 2012 7:26 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Access 2007 Toolbar Issue I had the same issue. I had created a nice custom menu bar in A2003, but when I converted to A2007, it was an add-in and I have never found a way to modify or customize it further. So I created a custom form, put all my menu bar commands on there and am able to continue to develop my 'function menu' as I see fit. Keith At 4/9/2012 07:29 AM -0500, you wrote: It was built in Access 2003 using the view toolbars customize feature from the menubar. The database was later converted to access 2007 where it became an addin. I have been researching the problem and believe the cause is that the export toolbar command in Access 2003 has no counterpart in Access 2007. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, April 06, 2012 8:54 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 Toolbar Issue How did you build the toolbar, code or macros? Charlotte Foust On Fri, Apr 6, 2012 at 11:35 AM, Kaup, Chester < Chester_Kaup at kindermorgan.com> wrote: > I had a database in Access 2003 with a custom toolbar. One of the items on > the toolbar used on a report was export. I moved the database to access > 2007. Now in the addin toolbar I still have the item export. When I click > on it I get the message: > > You tried to perform an operation involving a function or feature that was > not installed in this version of SACROC surveillance. > > SACROC surveillance is the name of my database > > I need some help on what to for or where to look to fix this error. I > checked all the VBA reference and they are the same. > > Thanks. > > Chester Kaup > Engineering Technician > Kinder Morgan CO2 Company, LLP > Office (432) 688-3797 > FAX (432) 688-3799 > > > No trees were killed in the sending of this message. However a large > number of electrons were terribly inconvenienced. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com