Access 2007 toolbars

[gdonald20]

Access 2007 Toolbars

I am drowning in Access 2007 Hell

IN Access 2003 I have a nice little application where, on open of the main
menu, the toolbars disappear for all users except Owner:
(N.B. THere are no Custom toolbars)


If CurrentUser() = "Owner" Then

DoCmd.ShowToolbar "Menu Bar", acToolbarWhereApprop
DoCmd.ShowToolbar "Form View", acToolbarWhereApprop
DoCmd.ShowToolbar "Database", acToolbarWhereApprop
DoCmd.ShowToolbar "Web", acToolbarNo

Else

DoCmd.ShowToolbar "Menu Bar", acToolbarNo
DoCmd.ShowToolbar "Form View", acToolbarNo
DoCmd.ShowToolbar "Database", acToolbarNo
DoCmd.ShowToolbar "Web", acToolbarNo

End If

I am tearing my hair out trying to put this in code in Access 2007.

I can see from various previous threads that this "kind of" thing has been
used before but not this nice simple on/off version.

Can someome please help me.

Thanks

 

[ruralguy via AccessMonster.com]

See if this link helps a little: http://accessjunkie.com/faq_31.aspx

 

[gdonald20]

Hi

Thanks, i had already looked at that website.

My problem is that i haven't created any custom toolbars.

All my code does in access 2002 is hide or unhide the standard toolbars,
like the design bar etc dependant on the user. I'm not sure if these even
exist in access 2007 anymore or if they've been renamed.

Gillian