• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

Where is menu coming from, what is invoked

Export To Excel Menu
I'm working with a legacy app that was written long ago.  Whenever a report is generated and previewed on the screen a menu appears at the top, upper left of the screen right under the blue 'Microsoft Access line.

I attached a picture of that portion of the  screen

If I click on the first icon of the menu I get a drop down of:

Immediatley to the right of that icon is an icon that looks like a miniature Excel logo with text that says 'Export Screen Contents To Excel'.  When I hover over the 'Excel' option it displays 'Office Links'.

I can't find anywhere that is placing that menu on the screen.

Where is it coming from?  What causes this to display at the top of the form?
How can I change the contents of it?
Or how can I supress it from appearing?

I've never seen it on any forms that I created so the prior developer wanted it there.
1 Solution
Rey Obrero (Capricorn1)Commented:
open the report in design view
hit F4 to see the reports Property window

select the Other tab

see if there is an entry at  Toolbar and/or  Menu bar properties
mlcktmguyAuthor Commented:
The Menu_Bar has an entry but when I view it in the 'Customize' toolbar is has no options specified.  I think it is the blank menu underneath the 'Export Screen Contents to Excel' menu in the image at the beginning of my post.

The shortcut menu is populated and contains a menu that appears when a right click occurs on the report.  It has an option to "print' the report or 'Email the report as an attachment.

There is no entry in the 'Toolbar' property.

Still don't know where it's coming from.
Rey Obrero (Capricorn1)Commented:
<The Menu_Bar has an entry >

try removing the entry and open the report, see if you will still see the menu
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

The first menu is the control menu that appears in every Window. It is similar to the access control menu.

The other one, need to be looked at.

Try to reproduce it with just the report and no data, and upload.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You're using Access 2003, so I'd assume those are custom menus or toolbars. There are several different ways to do that, and several different ways to control when they show up.

I'd try setting a breakpoint in the OPen or Load even of the report, and step through the code to see if there is some method being called to create or show that menu.

I believe it's also possible to set the ShortcutMenu property in code, so you might need to look for that.
mlcktmguyAuthor Commented:
Thanks for the responses, I have not had time to try them yet.  I will keep you posted.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now