Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Office Links menu item dropped in runtime version of Access 2002

Posted on 2006-05-16
5
Medium Priority
?
325 Views
Last Modified: 2008-03-03
Users of an application I programmed cannot access the office links menu from the toolbars when using the runtime version of Access 2002.  This is true with one exception.  One workstation that used to have the full version of Access 2002 installed shows these menu items.  This is specific to machine and not log-in.  

Is there a office library that contains the allowable menu items that I can copy to other machines - this will not work if I have to install and dis-install full flavoured Access on all users machines.

Thanks in advance.

Greenbase
0
Comment
Question by:Greenbase
  • 3
  • 2
5 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 16688633
Hi Greenbase,
I assume you have created a menu with the required items on it?
Do the machines that don't show the menu have Word and Excel installed?

Pete
0
 

Author Comment

by:Greenbase
ID: 16688667
Yes - They have Word and Excel 2003 installed.

The version of Access is 2003.

The problem isn't really that I can't assign the Office links menus to the toolbar - I actually can to a form menu.  However, when a report comes up this is replaced by a default report bar without office links.  Only the workstation where fuull featured Access has been installed will show Office Links in this menubar.
0
 

Author Comment

by:Greenbase
ID: 16688670
Sorry, Access 2002 is the version
0
 
LVL 77

Accepted Solution

by:
peter57r earned 1500 total points
ID: 16688792
I don't understand your comment about menu bars.
If you want a menu feature in the runtime you must create your own menu bar and set the reports meu property to that menu.

Pete
0
 

Author Comment

by:Greenbase
ID: 16696123
Doh!

I had been doing this but didn't assign the menu bar.  In the meantime I was distracted by an argument the user was making about there being different default menu bars that Access was using.

This is something that looked difficult but was actually simple.  

0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

810 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