Access 2003 - Missing Menu Bar

J

Juliet Alpha

Hi again Mike, or anyone out there.

I 'repaired' the Office installation as you suggested, but to no avail.

Looking at the Access window, there is the Title bar at the top followed by
the Tool bar, then nothing other than the grey background (which is what you
would expect prior to starting/creating an access application). Just no Menu
Bar.

Am I doing something daft, or do I have a faulty copy of Office 2003? On
intial installation of Office 2003, I did follow the prompts to download and
install any upgrades from Microsoft. Might there be a problem with these?

I am not an expert, but have been using Access to a basic/intermediate level
since Access-2, then 95, then 97, then 2000, then XP and now 2003. First time
that I have seen this problem, and as far as I know, there is no function to
'Switch-off' the Menu bar - is that right?

The OS on this machine is Windows XP (Home), SP2.

Hope to get a resolution soon. Thanks in advance.

Regards

Juliet Alpha.
****************************
 
A

Arvin Meyer

You may have run an application that hid or disabled the menu bar. Create a
module and add the following 2 functions which can be called from the
Immediate window:

Function ShowMenu()
On Error Resume Next
DoCmd.ShowToolBar "Menu Bar", acToolbarYes
End Function

Function HideMenu()
On Error Resume Next
DoCmd.ShowToolBar "Menu Bar", acToolbarNo
End Function
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
J

Juliet Alpha

Thanks for this Arvin.

Unfortunately I do have enough knowledge about Modules or programming to
know what to do with this information. Also, I think that it should not be
necessary as the menu bar should, I thought, be an integral part of the
installation.

I have run the 'set-up' again to uninstall and then re-install the office
suite and got the same result.

Time to abandon '2003 and return to the old trusted Office 2000 I think!!

If there are any other useful suggestions out there, I would be pleased to
hear them. Thanks.

Juliet.
***********************
 
A

Arvin Meyer

I'm not particularly fond of Access 2003, but I'd take it in a heartbeat
over the corruptions and bugs I've received with Access 2000.

Create a new standard module and simply paste in the code. Then save it with
any name. You can then open a new form and stick a command button on it,
oprn the property sheet and type:

=ShowMenu()

Go to form view and click on the button. Alternatively, use the Immediate
window right in your module and type:

? ShowMenu()

then hit the Enter key.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
J

Juliet Alpha

Thanks again Arvin.

I will store your good advice for further self learning at a later date, but
for now I did manage to figure out a fix, as follows, should anyone else be
interested:-

RESTORE MISSING MENU BAR:-
* right click the Tool Bar and select 'Customize'
* select the Toolbars tab and then click on 'Properties'
* goto the 'Selected Toolbar' dropdown and look for 'Menu Bar'
* click 'Restore Defaults' and, Hey-Presto, just like magic the Menu Bar
appears

........and I thought that the Menu Bar could not be hidden...........you
learn something new every day. Isn't life fantastic?? Thanks Microsoft for
your little hidden puzzle on the installation disk. It saved me having to
meet a deadline!!!!!!!

Regards
Juliet Alpha
London
 
Top