Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2007

Posted on 2011-03-21
2
Medium Priority
?
342 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 19

Accepted Solution

by:
Richard Daneke earned 1000 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 1000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

886 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