Solved

Access 2007

Posted on 2011-03-21
2
326 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 19

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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

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…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

752 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