Solved

Access 2007

Posted on 2011-03-21
2
315 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
Comment Utility
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
Comment Utility
And if you are working with the Ribbon ... this is a must have tool:

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

mx
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

743 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

17 Experts available now in Live!

Get 1:1 Help Now