2 Questions: Code to exit via cmdExit; Code to hide/disable tool b

#1 (**permalink**) 28-Jul-2006, 08:39 AM

Would someone please tell me what code to use for:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13685-2-questions-code-exit-via-cmdexit.html

1)To exit application via
Private sub cmdExit ()
???
End sub

2) To hide/disable tool bars
Private sub Form_Load ()
???
End sub

and to enable them on exit ??? if needs be???
Thank you

*

#2 (**permalink**) 28-Jul-2006, 08:39 AM

> 1)To exit application via
> Private sub cmdExit ()
> ???
> End sub

================
Docmd.Quit
================

> 2) To hide/disable tool bars
> Private sub Form_Load ()
> ???
> End sub
>
===================
DoCmd.ShowToolbar "ToolBarName", acToolbarNo

And it better to use the form Activate event then the load event, just
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
incase you moving between forms, and this tool bars will be set to yes in
other forms

===================

#3 (**permalink**) 28-Jul-2006, 08:39 AM

Dear Ofer,
Thank you for your reply. The exit works perfectly.

How do I find a list of what the toolbar names are?
I would like to turn-off all of the Drop-Down menus (not show them),
and turn-off all of the toolbars (not show them) - form view, formatting,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
& web
Where do I find out the names of these, or can I turn-off all of them at
once?

Thank you,
Andy

"Ofer Cohen" wrote:

> > 1)To exit application via
> > Private sub cmdExit ()
> > ???
> > End sub
>
> ================
> Docmd.Quit
> ================
>
>
> > 2) To hide/disable tool bars
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
> > Private sub Form_Load ()
> > ???
> > End sub
> >
> ===================
> DoCmd.ShowToolbar "ToolBarName", acToolbarNo
>
> And it better to use the form Activate event then the load event, just
> incase you moving between forms, and this tool bars will be set to yes in
> other forms
>
> ===================

#4 (**permalink**) 28-Jul-2006, 08:39 AM

Open the MDB, in the menu bar select Tools > startup options > there you can
remove the toolbars.

If then you want to open the MDB and see the toolbars, for development
reasons, open the MDB while the shift key is pressed

--
Good Luck
BS"D

"AndyG" wrote:

> Dear Ofer,
> Thank you for your reply. The exit works perfectly.
>
> How do I find a list of what the toolbar names are?
> I would like to turn-off all of the Drop-Down menus (not show them),
> and turn-off all of the toolbars (not show them) - form view, formatting,
> & web
> Where do I find out the names of these, or can I turn-off all of them at
> once?
>
> Thank you,
> Andy
>
> "Ofer Cohen" wrote:
>
> > > 1)To exit application via
> > > Private sub cmdExit ()
> > > ???
> > > End sub
> >
> > ================
> > Docmd.Quit
> > ================
> >
> >
> > > 2) To hide/disable tool bars
> > > Private sub Form_Load ()
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
> > > ???
> > > End sub
> > >
> > ===================
> > DoCmd.ShowToolbar "ToolBarName", acToolbarNo
> >
> > And it better to use the form Activate event then the load event, just
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
> > incase you moving between forms, and this tool bars will be set to yes in
> > other forms
> >
> > ===================

#5 (**permalink**) 28-Jul-2006, 08:39 AM

That does get rid of the toolbars, however it still leaves the Drop-down
menues.
Can I programatically (or otherwise) hide/disable them?

"Ofer Cohen" wrote:

> Open the MDB, in the menu bar select Tools > startup options > there you can
> remove the toolbars.
>
> If then you want to open the MDB and see the toolbars, for development
> reasons, open the MDB while the shift key is pressed
>
> --
> Good Luck
> BS"D
>
>
> "AndyG" wrote:
>
> > Dear Ofer,
> > Thank you for your reply. The exit works perfectly.
> >
> > How do I find a list of what the toolbar names are?
> > I would like to turn-off all of the Drop-Down menus (not show them),
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
> > and turn-off all of the toolbars (not show them) - form view, formatting,
> > & web
> > Where do I find out the names of these, or can I turn-off all of them at
> > once?
> >
> > Thank you,
> > Andy
> >
> > "Ofer Cohen" wrote:
> >
> > > > 1)To exit application via
> > > > Private sub cmdExit ()
> > > > ???
> > > > End sub
> > >
> > > ================
> > > Docmd.Quit
> > > ================
> > >
> > >
> > > > 2) To hide/disable tool bars
> > > > Private sub Form_Load ()
> > > > ???
> > > > End sub
> > > >
> > > ===================
> > > DoCmd.ShowToolbar "ToolBarName", acToolbarNo
> > >
> > > And it better to use the form Activate event then the load event, just
> > > incase you moving between forms, and this tool bars will be set to yes in
> > > other forms
> > >
> > > ===================

#6 (**permalink**) 28-Jul-2006, 08:39 AM

It should hide also the menue bar, unless you didn't uncheck it, or mybe yu
can see the menu of Access and not the MDB.

--
Good Luck
BS"D

"AndyG" wrote:

> That does get rid of the toolbars, however it still leaves the Drop-down
> menues.
> Can I programatically (or otherwise) hide/disable them?
>
> "Ofer Cohen" wrote:
>
> > Open the MDB, in the menu bar select Tools > startup options > there you can
> > remove the toolbars.
> >
> > If then you want to open the MDB and see the toolbars, for development
> > reasons, open the MDB while the shift key is pressed
> >
> > --
> > Good Luck
> > BS"D
> >
> >
> > "AndyG" wrote:
> >
> > > Dear Ofer,
> > > Thank you for your reply. The exit works perfectly.
> > >
> > > How do I find a list of what the toolbar names are?
> > > I would like to turn-off all of the Drop-Down menus (not show them),
> > > and turn-off all of the toolbars (not show them) - form view, formatting,
> > > & web
> > > Where do I find out the names of these, or can I turn-off all of them at
> > > once?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
> > >
> > > Thank you,
> > > Andy
> > >
> > > "Ofer Cohen" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13685
> > >
> > > > > 1)To exit application via
> > > > > Private sub cmdExit ()
> > > > > ???
> > > > > End sub
> > > >
> > > > ================
> > > > Docmd.Quit
> > > > ================
> > > >
> > > >
> > > > > 2) To hide/disable tool bars
> > > > > Private sub Form_Load ()
> > > > > ???
> > > > > End sub
> > > > >
> > > > ===================
> > > > DoCmd.ShowToolbar "ToolBarName", acToolbarNo
> > > >
> > > > And it better to use the form Activate event then the load event, just
> > > > incase you moving between forms, and this tool bars will be set to yes in
> > > > other forms
> > > >
> > > > ===================