Toolbar

[Milandra]

Is there anyway that we can create our own toolbars to
open each different forms we want(shorcut) and shut down
regular toolbar.

Thanks in advance,
Milandra

 

[Mattias Jonsson]

Milandra,
Here's some code that might be helpful. Create a toolbar and have its name
start with "WSU" (or alter the code to fit what you do name it).

*** code start ***
'Remove all commandbars that don't start with "WSU"
For Each itm In Application.CommandBars
If itm.Type = 0 Or itm.Type = 1 Then
itm.Visible = Left(itm.Name, 3) = "WSU"
End If
Next
*** code end ***

Thanks,
Mattias Jonsson

 

[Milandra]

Jonsson,
Could you please guide me a simple way to create toolbar.
I want it to look the same way as regular toolbar
attatched to the Menubar that I created.

Thanks,
Milandra

 

[Jeff Conrad]

This link should help a lot:

http://www.microsoft.com/Accessdev/articles/bapp97/chapters/ba01_6.htm

It's written for Access 97, but the principles are the same for later versions.

Jeff Conrad
Access Junkie
Bend, Oregon

 

[Mattias Jonsson]

Milandra,
Jeff's post has got more detail on how to actually create the toolbar and
having it do something useful. My post was geared towards hiding the Access
built-in toolbars and displaying your toolbar(s) once you have it/them set
up.

Thanks,
Mattias Jonsson

 

[Malindra]

Jeff,
It's very big help. Thanks a lot.
Malindra

-----Original Message-----
This link should help a lot:

http://www.microsoft.com/Accessdev/articles/bapp97/chapte rs/ba01_6.htm

It's written for Access 97, but the principles are the same for later versions.

Jeff Conrad
Access Junkie
Bend, Oregon




.

 

[Jeff Conrad]

You're welcome.
Have fun with it!