Toolbars

K

kbreiss

Registered User.

Local time

Today, 04:01

Joined

Oct 1, 2002

Messages

228

• Feb 20, 2003

• #1

In my AUTOEXEC macro I run the ShowToolbar command. When I open this database it includes the toolbar I selected correctly.

What I'm trying to accomplish is a way to turn off the form view toolbar. I will be having several users using this database and I would like to take away the ability to alter the database design.

Any advice would be appreciated.

Thanks,
Kacy
________
MOTORCYCLE TIRES

 

Last edited: Apr 29, 2011

jfgambit

Kinetic Card Dealer

Local time

Today, 04:01

Joined

Jul 18, 2002

Messages

798

• Feb 20, 2003

• #2

The follwoing commands will hide the toolbars and open your customized one. You can add any combination opf these to the OnLoad Event of your main switchboard or Form:

DoCmd.ShowToolbar "Menu Bar", acToolbarNo
DoCmd.ShowToolbar "Print Preview", acToolbarNo
DoCmd.ShowToolbar "Database", acToolbarNo
DoCmd.ShowToolbar "Form View", acToolbarNo
DoCmd.ShowToolbar "YourToolbarNameHere", acToolbarYes

To get the Tool Bars to show again, change the last argument to : acToolbarYes


HTH

Jeff

 

ghudson

Registered User.

Local time

Yesterday, 23:01

Joined

Jun 8, 2002

Messages

6,194

• Feb 20, 2003

• #3

check out the showhideenabledisabletoolbarsmenubars.zip sample I posted @
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=42094

HTH

 

K

kbreiss

Registered User.

Local time

Today, 04:01

Joined

Oct 1, 2002

Messages

228

• Feb 21, 2003

• #4

ghudson,
Ok, I looked at that code and I have two questions for you. First, can I put this code in an AUTOEXEC macro so that it will remove the menu bar from every form contained in my database? Secondly, when have the menu bar and toolbars turned off, I saw that you say it also disables the right click function. How do I enable my self to get back in the design view without those options available.

I appreciate your advice,

Kacy
________
Volcano vaporiser review

 

Last edited: Apr 29, 2011

ghudson

Registered User.

Local time

Yesterday, 23:01

Joined

Jun 8, 2002

Messages

6,194

• Feb 21, 2003

• #5

Yes.

Macro/Action/RunCode/ToolbarsOff()

I prefer to run the code from the OnOpen event in my MainMenu form.

Use the ToolbarsOff() & ResetToolbars() functions to hide/unhide the toolbars instead of the code in the EnableDisableAllToolbarsAndMenubars form to use the Right-Click option.

Hold the Shift key when opening the db to bypass the AutoExec macro (and any Startup options)

HTH

 

K

kbreiss

Registered User.

Local time

Today, 04:01

Joined

Oct 1, 2002

Messages

228

• Feb 21, 2003

• #6

Thanks....This is exactly what I needed.

Kacy
________
Jaguar xk120 specifications

 

Last edited: Apr 29, 2011

K

kbreiss

Registered User.

Local time

Today, 04:01

Joined

Oct 1, 2002

Messages

228

• Feb 21, 2003

• #7

ghudson,

When I tried to go to Macro/Action/RunCode/ToolbarsOff() and run it is saying Access can't find the function. Any ideas?

Kacy
________
WENDIE 99

 

Last edited: Apr 29, 2011

ghudson

Registered User.

Local time

Yesterday, 23:01

Joined

Jun 8, 2002

Messages

6,194

• Feb 21, 2003

• #8

Are you addding the RunCode command to your AutoExce macro? My post was listing the steps need to do that. I have attached a picture of what the macro should look like (from the surface).

I do not use macros. VBA has the advantage over macros for numerous reasons.

HTH

 

Attachments

• 
  autoexecmacro.jpg

  12.3 KB · Views: 263

K

kbreiss

Registered User.

Local time

Today, 04:01

Joined

Oct 1, 2002

Messages

228

• Feb 21, 2003

• #9

I am still receiving the error upon opening the database that says, "The expression you entered has a function name that Microsoft Access can't find" I created an AutoExec macro that includes the Action RunCode with the function name ToolbarsOff(). Do I need to declare the function ToolbarsOff() anywhere?

Thanks,

Kacy
________
GANG BANG PUBLIC

 

Last edited: Apr 29, 2011