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:
Restore
Move
Size
Minimize
Maximize
Close

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.
LVL 1
mlcktmguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
0
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.
0
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
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

hnasrCommented:
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.
0
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlcktmguyAuthor Commented:
Thanks for the responses, I have not had time to try them yet.  I will keep you posted.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.