custom toolbars as defaults

[lscheer]

I have designed several custom toolbars which I hope to use to limit the functionality of the database based on user's status (in addition to User-Level security). What I have basically is an "Admins" toolbar and several "users" toolbars that pertain to queries, reports, etc.

First of all, is it possible to show/hide the Admins toolbars based on the CurrentUser() function, and where would I put it?

Secondly, is it possible to assign, for instance, the queries toolbar to be shown whenever queries are opened (in either datasheet or design view) and hidden when queries are not open (similar to the built-in toolbars, but I don't want to use the built-in toolbars)?

I tried setting the toolbar property in my reports to the appropriate toolbar, but it opens a floating toolbar (not the end of the world, but it would be ideal to dock it at the top with the rest) and only in print preview mode, when I switch to design mode, the toolbar disappears, which makes it useless.

Any help would be great. Thanks!

 

[DBL]

If you open the properties for your custom toolbar, you can set the Docking to Can't Change - just remember to position it where you want to go first!