Solved

Access 2007

Posted on 2011-03-21
2
318 Views
Last Modified: 2012-06-21
My OS is windows 7 and I am trying to implement the following, but am not getting it :
'***HOW TO CALL THIS FUNCTION***
'Add a Custom Menu Item to the standard Toolbox or to the Standar Menu Bar.
'Right Click with your mouse on a blank area of the Toolbox or the Menu bar.
'From the dropdown menu select "Customize". A dialog window named "Customize"
'pops open with 3 tabs. Select the second tab named "Commands".
'This Window is divided into 2 subwindows. On the left is "Categories" on
'the right side is "Commands" . Make sure the first item "File" on the left hand window
'is selected. Now in the right hand window you should see the item "Custom".
'Scroll the window up or down if it is not visible.
'Now with your left mouse button click - hold - drag and drop the "Custom" item
'onto the Standard Toolbox or Standard Menu Bar. Release the mouse button.
'The "Modify Selection" button is now available. Click on it.
'Change the "NAME" property to ROTATE or whatever you want.
' Now select "Properties".
'In the "On Action" property fill it in exactly as below with the name of this function.
'      =fRotextEMF()
'That's it. Click "Close" then "Close" again.

Can any Guru please give me a step by step with screen shots, as I do not seem to be gettting it.  My first problem is identifying correctly the Standard Toolbox or Standard Menu Bar.  Hope u could please give me a snap shot which is which.  It will be nice if someone could kindly give me the steps with snapshots.  thank u.
0
Comment
Question by:jegajothy
2 Comments
 
LVL 18

Accepted Solution

by:
Richard Daneke earned 250 total points
ID: 35184449
You instructions will work with Access 2003 and earlier.  Your title suggests you have Access 2007.   Here you will need to customize the Ribbon or customize the Quick Access toolbar.

Customzie the Ribbon instructions link at microsoft:
http://office.microsoft.com/en-us/access-help/customize-the-ribbon-HA010211415.aspx?CTT=1

Quick Access toolbar instructions link at microsoft:
http://office.microsoft.com/en-us/access-help/customize-the-quick-access-toolbar-HA010362102.aspx?CTT=1
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 35184470
And if you are working with the Ribbon ... this is a must have tool:

http://www.accessribbon.de/en/

mx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now