Access 2007 toolbars

G

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Toolbars Hide 2
Run-time error 3
tool bars / ribbons 2007 3
ToolBAR QUESTION 1
Programmatically Hide all custom toolbars 6
2007 Ribbon: minimize using code 2
Hide ribbon event not working 11
Toolbar Errors 2

Top