By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Disappearing Menus

P: n/a
Hi Everyone-

I have a problem with my menu bars disappearing. Here's a little
backround...

I have one main database that has a page called "Prior Records." There
are several command buttons that link older databases via the
hyperlink property. I had an old databae in Access 2000 File Format. I
made a backup copy then converted it to Access 2002 File Format. After
I click the command button to bring up an old database, the menu bars
across the top disappear.

For example, when I click one of my reports to view in print preview,
the menu bars across the top are no longer there. The menu bars that
used to come up are:

1.) the top menu bar: File, Edit, View, Tools, Window, and Help.
2.) Below are: the drop down box for the different views (i.e. design
view, print preview, etc...), the print icon, the magnifying glass,
etc...

Is this a setting in the properties box for the form that has the
report command buttons on them?

Or is there code missing in my VBA code for the "on click" event to
preview my reports?

In the old Access 2000 file format database, the menu bars appear. But
in the new Access 2002 file format database, those menu bars aren't
there. However when I open the new Access 2002 database in "Edit Mode"
(pressing Shift while opening it), the menu bars are present. So, I'm
thinking that it's a setting, but I don't know which one.

Here's the VBA code for the "on click" event.

************************************************** ****************************

Private Sub Command59_Click()
Dim stDocName As String

stDocName = "rpttVoters"
DoCmd.OpenReport stDocName, acPreview

End Sub
************************************************** ****************************
Thanks for your time and efforts!!!

Miguelito Bain
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
It may just be that those toolbars have not been "turned on". If you open
the report, then right-click on any toolbar/menu bar, see if the one you
want is checked off. If not, select it and it should display itself form now
on. If it isn't in the list, choose customize. For each toolbar you want
shown, select it (don't check it off) and click the properties button. Make
sure "Show On Toolbars Menu" is checked off. Built-In bars don't give this
option as they are automatically available for the object they pertain to.

Mike Storr
www.veraccess.com
"Miguelito Bain" <mi***********@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
Hi Everyone-

I have a problem with my menu bars disappearing. Here's a little
backround...

I have one main database that has a page called "Prior Records." There
are several command buttons that link older databases via the
hyperlink property. I had an old databae in Access 2000 File Format. I
made a backup copy then converted it to Access 2002 File Format. After
I click the command button to bring up an old database, the menu bars
across the top disappear.

For example, when I click one of my reports to view in print preview,
the menu bars across the top are no longer there. The menu bars that
used to come up are:

1.) the top menu bar: File, Edit, View, Tools, Window, and Help.
2.) Below are: the drop down box for the different views (i.e. design
view, print preview, etc...), the print icon, the magnifying glass,
etc...

Is this a setting in the properties box for the form that has the
report command buttons on them?

Or is there code missing in my VBA code for the "on click" event to
preview my reports?

In the old Access 2000 file format database, the menu bars appear. But
in the new Access 2002 file format database, those menu bars aren't
there. However when I open the new Access 2002 database in "Edit Mode"
(pressing Shift while opening it), the menu bars are present. So, I'm
thinking that it's a setting, but I don't know which one.

Here's the VBA code for the "on click" event.

************************************************** **************************
**
Private Sub Command59_Click()
Dim stDocName As String

stDocName = "rpttVoters"
DoCmd.OpenReport stDocName, acPreview

End Sub
************************************************** **************************
**

Thanks for your time and efforts!!!

Miguelito Bain

Nov 12 '05 #2

P: n/a
when i converted the db from 2000 to 2002, some of the settings didn't
carry along. i don't know why, maybe somebody does.

my solution- go to tools, then startup, then select the menus and
toolbars i wanted to see.

it took me a while to figure this out, so i thought that it was only
right to post a solution to this problem just in case someone else
runs into this problem.

however, i still don't know why these settings were lost when i
converted the db from 2000 to 2002.

hope everyone's having a blessed day,

miguelito
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.