No menu bar

J

Jasper Recto

I have an access program that a list of menu buttons that are links to
folders. When I start the program, all I get is the form that auto starts.
I don't see the menu bar at all or even the frame that says "Microsoft
Access". What option controls this feature?

Thanks,
Jasper
 
A

Arvin Meyer

Jasper Recto said:
I have an access program that a list of menu buttons that are links to
folders. When I start the program, all I get is the form that auto starts.
I don't see the menu bar at all or even the frame that says "Microsoft
Access". What option controls this feature?
Click to expand...


Application.SetOption "Built-in Toolbars Available", False

or True. Run this from a Debug window (Ctrl+G)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
R

Rick Brandt

Jasper Recto said:
I have an access program that a list of menu buttons that are links to
folders. When I start the program, all I get is the form that auto starts.
I don't see the menu bar at all or even the frame that says "Microsoft
Access". What option controls this feature?
Click to expand...

The person who created the file added programming to hide the Access interface.
Depending on how it was implemented you might not be able to do anything about
it. Try holding the shift key as you open the file.
 
J

Jasper Recto

How do you hide the access interface? That's what I want to learn how to
do!

Thanks,
Jasper
 
J

Jasper Recto

Rick,

What do I do with this code from the website? Do I put it into a module?
How do I call this function?

Thanks,
Jasper
 
R

Rick Brandt

Yes, you put it in a module and would typically call it in the open event
of a form automatically opened at startup.
 
J

Jasper Recto

Rick,
I placed the code in a module called 'AccessWindow'. I saw some information
on the web that said to create a procedure in the 'On Open' event. it looks
like this:

Private Sub Form_Open(Cancel As Integer)
Me.Visible = True
fSetAccessWindow SW_HIDE
End Sub

When I open the program, everything disappears. I don't see my form. I
made sure that the 'Pop Up' was yes but that didn't help.

Any ideas?
Thanks,
Jasper
 
R

Rick Brandt

Jasper Recto said:
Rick,
I placed the code in a module called 'AccessWindow'. I saw some information
on the web that said to create a procedure in the 'On Open' event. it looks
like this:

Private Sub Form_Open(Cancel As Integer)
Me.Visible = True
fSetAccessWindow SW_HIDE
End Sub

When I open the program, everything disappears. I don't see my form. I
made sure that the 'Pop Up' was yes but that didn't help.
Click to expand...

It's a bit of a crude process that I also had some difficulties with. It
also seems to act differently depending on your Access version. In Access
97 I had to execute the code in a Timer event as the Open event acted like
it was "too soon".
 
A

Albert D. Kallal

You can hide the ms-access interface without any code at all.

The posters here are confusing the issue of hiding the "main" background
grey window that ms-access has. That code posted will hide this main
background window, but it does NOT hide the ms-access interface, tools bars,
and all of the menu options. So, it is not 100% clear here what you are
trying to hide? That posted code is to run off the main backgroud window. It
does NOT hide the database window, or the tool bars, or design mode etc.

All of the features you need to hide the ms-access menus and features can be
accomplished with no code, and you don't even need secuirty here. So, all of
the options you need can be found in tools->startup.

I have a sample working example that hides everything..and it uses no code
at all to hide everthing. You can download the sample here:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

Grab the 3rd one from above. Try running it..and see how all of ms-access
is hidden. you can now exit..and then re-run/re-load the application,but
hold down the shift key to get inside.
 
J

Jasper Recto

My goal is to not see any sort of background. I don't want to see the grey
MS Access window or the any sort of tool bar. All I want is the form that I
created.

I clicked on the linked you sent and it takes me to 'Word Merge Examples'.
Is that correct?
I downloaded some of the examples but all of them show the MS-Access window.

Am I missing something?

Thanks,
Jasper
 
A

Albert D. Kallal

I downloaded some of the examples but all of them show the MS-Access
window.

Am I missing something?

Thanks,
Jasper
Click to expand...

No, it was me who was missing something! I was not sure if in fact you were
trying to hide that background...or hide all of the ms-access interface.
Word, Excel..and most of office has that "grey" main window..and so does
ms-access. I thought that you might be trying to hide all of ms-access, but
not necessary that main "grey" application window. So...in effect, the other
posters did understand your intentions..and I did not!!

However, my example does show you can "hide" the ms-access interface...and
that is somewhat of a different issue then hiding the main gray background
window. (and, so...yes..that code you were pointed to does accomplish what
you seem to need).
 
Top