Execute Form Without Access Menus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.

My question is How can I execute my Access Application withou the Main
Access Window toolbar. Moreover, when I execute each application, the Main
Form is always inside the Access Window. Can I have just one window per
application?
 
Nuno said:
Hi.

My question is How can I execute my Access Application withou the Main
Access Window toolbar. Moreover, when I execute each application, the
Main Form is always inside the Access Window. Can I have just one
window per application?
Click to expand...

Access is an MDI application (as is Word and Excel). See if you can view a
Word document or an Excel sheet without the application window wrapped
around it (you can't).

There are API calls you can use to "hide" the Access application window, but
this imposes quite a lot of restrictions on how your application can be
used. I have done this once or twice for small utility applications that
consisted of only a single form and it's not too bad in that context. For
more complex apps it is way more trouble that its worth.

Code examples are available at the link below...

http://www.mvps.org/access/api/api0019.htm
 
Thanks for the answear.
What if instead of hidding the Access application window, hide the comand's
menu that are visible on the application window? Can be possible?
 
Nuno said:
Thanks for the answear.
What if instead of hidding the Access application window, hide the
comand's menu that are visible on the application window? Can be
possible?
Click to expand...

The options in Tools Startup can hide almost all of that.
 
I am ready using that possibility but it seams that it's not possible to hide
the 'File', 'Window' and 'Help' menus.

I also tried to use the fSetAccessWindow function, but the Access shows me
an error about the 'SW_HIDE'. I put all the code mencioned in your link in
one Module, but possibly i'm not doing it in the right way.

Thanks again.
 
Use acces 2003 developer extensions which are part of the Ms Visual Studio
2005 tools for Ms Office 2003. You can get just acces 2003 developer
extensions on it's own. Very simple wizard interface allows you to customize
everything very easily. Just used it yesterday. Allows you to strip
properties out of the forms so your database stays secure. Good Stuff.
--
Bernard Piette
Solutions Architect
http://www.BernardPiette.com
1610 Boul. St-Jospeh, Suite 1
Lachine, Quebec H8S 2N1
 
I have not had any luck hiding the default menu bar, but I have discovered
that if I create a custom menu bar and select it in the form's properties, I
can hide it by using code in the form's Open event:
DoCmd.ShowToolbar "YourToolbar", acToolbarNo

YourToolbar is whatever name you have given to the custom menu bar. See
Help for more about creating custom menus.

I have read that I can hide the default menu bar, but as I said, I can't
seem to get that to work. Apparently Access can't handle the idea that
somebody would not want a menu bar. I am using Access 2000, and maybe that
has changed in later versions.
 
Back
Top