Built-in Tab Names in Access Ribbons

re: Built-in Tab Names in Access Ribbons

Anthony Moore — Thu, 11 Dec 2008 01:37:32 GMT

Rob,

There is actually an bunch of excel files that microsoft released that have all the inbuilt controls that the office suite has in them.

This includes Word, Outlook, Excel, Powerpoint and most importantly (for us at least) Access.

I am currently trying to find the official link, however in the interim, this pack can be downloaded from this location.

http://cid-50810c099c90c99a.skydrive.live.com/embedrow.aspx/Public/RibbonControls.zip

re: Built-in Tab Names in Access Ribbons

Anthony Moore — Thu, 11 Dec 2008 01:40:00 GMT

Rob,

There is actually an bunch of excel files that microsoft released that have all the inbuilt controls that the office suite has in them.

In the link you provided.

If you open the AccessRibbonControls.xlsx file in the link you provided, and filter Control type to tab, it will provide you with a list of tabs inside Access

This Download link also includes Word, Outlook, Excel, Powerpoint and most importantly (for us at least) Access.

Ribbon Site: For Beginners

http://itexcellence.spaces.live.com

re: Built-in Tab Names in Access Ribbons

Niren Joshi — Fri, 12 Dec 2008 16:54:49 GMT

I am sorry I am posting unrelated stuff here. But I hope to get the attention of the Access Team. I have an Access application written in Access 2007 which does inserts and updates on a table. It runs continuously and keeps growing in size. So I had the following command in there to compact every hour -

CommandBars("Menu Bar").Controls("Tools").Controls("Database utilities").Controls("Compact and repair database...").accDoDefaultAction

However, since I upgraded to Office 2007, this command no longer works. I have searced the internet to no avail. Could the Access team suggest what would be an equivalent command to compact in Access 2007. Right now I am having to manually compact the database using the Manage>Compact & Repair menu.

I sincerely hope the Access team can help with this request.

Thanks,

Niren

re: Built-in Tab Names in Access Ribbons

Niren Joshi — Fri, 12 Dec 2008 17:06:05 GMT

oops.. I meant to say the application was written in Access 2000, and the compact command worked well in it. After upgrading to 2007, the same command does not work..

re: Built-in Tab Names in Access Ribbons

André Minhorst — Sat, 13 Dec 2008 19:55:36 GMT

Hi,

I still don't understand why Microsoft puts the idMso constants in an Excel file. Why didn't they just put a simple enumeration with all values in a library like the Office 12.0 Object Library where the other ribbon related objects and methods are? It would be much easier just to write "Commandbars.Execute msoFileSave" with IntelliSense helping to find the right constant ("FileSave" in this case). Actually I have to open the Excel file or to search in the Access options dialog which is not very comfortable.