Default toolbars

[Basil]

I keep having an issue with toolbars that I need help on

You know if you simply open an Access instance, generally the database toolbar is visible right? Well sometimes users don't have this toolbar visible by default - this causes me problems

My mdb has a toolbar saved in it and all the menus etc are disabled from startup options - on opening the db I open a form which in turn displays the toolbar that I created, it then also opens another form (main switchboard)

If the user's PC default is for the database toolbar to not open up by default when an Access instance opens, then the switchboard form does not open in the centre but a little bit higher (I assume because when opening their is no toolbar)

Here is my code for the form ([Unknown User]) that opens on startup

Private Sub Form_Load(
DoCmd.ShowToolbar "RPH Reporting System
LoadUse
If UserStatus <> "Unknown User" Then DoCmd.Clos
DoCmd.OpenForm "Main Switchboard
End Su

Is there a way that I can get round this or make their PC have the database toolbar open on default of an Access instance (obviously because of the startup settings in my mdb it won't open for my db)

PS It is actually quite important as there are other forms that open on top of the main switchboard leaving important elements of the switchboard visible behind it - these are sized very precisely

Thanks loads

Basi

 

[Basil]

This doesn't work

I have another idea... I'll get back if it works

----- losmac wrote: ----

What You need to do is to do that
- Create macro
- add command: ShowToolbar "RPH Reporting System
- add command: Open form "Unknown User
- Change OnLoad() procedure
' DoCmd.ShowToolbar "RPH Reporting System
LoadUse
If UserStatus <> "Unknown User" Then DoCmd.Clos
DoCmd.OpenForm "Main Switchboard
That's all!

 

[Basil]

Nope, having no luck at all

I've changed a few things and have another question, so I'll put up another post now

Ba

----- Basil wrote: ----

This doesn't work

I have another idea... I'll get back if it works

----- losmac wrote: ----

What You need to do is to do that
- Create macro
- add command: ShowToolbar "RPH Reporting System
- add command: Open form "Unknown User
- Change OnLoad() procedure
' DoCmd.ShowToolbar "RPH Reporting System
LoadUse
If UserStatus <> "Unknown User" Then DoCmd.Clos
DoCmd.OpenForm "Main Switchboard
That's all!

 

[Jody Burgess]

Check your options on the Database Startup.