Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 6th, 2008, 03:59 AM
Friend of Wrox
 
Join Date: Apr 2007
Location: , , .
Posts: 110
Thanks: 1
Thanked 2 Times in 2 Posts
Send a message via MSN to ayazhoda
Default modifications in legacy application menus

Hi All

We have migrated our access application from access 2003 to access 2007.

Just wondering is there any way to modify application menus in access 2007.

Thanks

Reply With Quote
  #2 (permalink)  
Old May 6th, 2008, 11:51 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

What do you mean by modify the application menus? Are you talking about the forms in the Access application, or are you talking about custom menus and ribbons? There are ways to do both.


mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote
  #3 (permalink)  
Old May 7th, 2008, 05:14 AM
Friend of Wrox
 
Join Date: Apr 2007
Location: , , .
Posts: 110
Thanks: 1
Thanked 2 Times in 2 Posts
Send a message via MSN to ayazhoda
Default

Thanks for reply donald

This is what i found and i did try this work very well but there's few glitches.

There are 5 steps to customizing the ribbons:

    * Create the ribbon XML - the ribbon definitions are done through an XML file, and the first step is to build that file. This is pretty easily done with a simple text editor, but can be made even easier with Visual Studio tools.
    * Specify callbacks - next, you need to build small VBA routines that handle ribbon actions like clicking a button or selecting something from a dropdown.
    * Create table for XML file - next, you create an Access table to hold the XML you created in step 1.
    * Add the ribbon to that table - next you create a record in the table for each custom ribbon, containing the ribbon name and the XML definition of the ribbon.
    * Set the Custom Ribbon property - finally, you set the Custom Ribbon property for the database as a whole or for specific forms and reports to load the ribbon you defined in the table above.


for more information
http://blogs.msdn.com/access/archive...access-ui.aspx

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
"/Modifications" maxshreck BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 October 10th, 2006 01:13 AM
Membership modifications...should I? Tremmorkeep BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 10 September 22nd, 2006 04:20 AM
Need of struts-legacy.jar sam123 Struts 1 May 24th, 2006 10:24 PM
Legacy references in a duplicate project JohnS VS.NET 2002/2003 0 March 10th, 2005 02:08 PM
legacy app and .Net web services interoperation. asaleh .NET Web Services 0 October 7th, 2003 05:44 AM



All times are GMT -4. The time now is 06:30 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.