[AccessD] Toolbar/Menubar Locking

Hi Darren.  Thanks for responding. 

What you said is along the line of what I want to do, however, I want to be
able to control the toolbars' properties based on the security.  That is, if
I login as the developer, I want the toolbars 'loose', so I can do what I
want with them.  However, when the "public" signs in, I want the toolbars
"locked" so they can't mess with them.  

The only way I know to do this is through code, but I don't know (or can
find) the syntax of the code to do it.  

Or is this type of control not possible?

Thanks!

Greg Smith
gregsmith at starband.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Thursday, July 22, 2004 6:28 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Toolbar/Menubar Locking

Hi Greg
You can "AllowMoving" "allowCustomising" "allowShow/Hide" and other things
when you create the toolbars.
Those properties stay with the toolbar and thus the app (of course) when you
move your app from machine to machine. 

Click View|Toolbars|Customise.  Select the first Tab then the relevant
toolbar from the list then
click on the properties button to the right Set what you want don't want
from there

Hope this helps

Darren

----- Original Message ----- 
From: "Greg Smith" <GregSmith at starband.net>
To: <accessd at databaseadvisors.com>
Sent: Friday, July 23, 2004 2:01 AM
Subject: [AccessD] Toolbar/Menubar Locking


> Hi everyone!
> 
> I'm not sure how to do this, or if it can even be done.  Currently using
> Access 97 on WinXP.
> 
> The application is a secured (through access workgroup/users) database
> front end.  At this point, I have no customized toolbars or menus, just
> using the standard ones.  The client has found that some of the users have
> messed with the toolbars (dragged them off to who knows where...) and
> afterwards can't get to them when they really do need them.
> 
> I eventually plan to have customized toolbars and menubars for them, but
> this question will apply to them as well, even though they're not ready
> yet.
> 
> Is there a way to lock the menubar and toolbar in place using vb code or
> some other way of automatically locking them?  I know it can be done in
> Access on each workstation, but these pc's are all over the place and I
> don't want to tell their MIS that he has to go around to each computer and
> lock the toolbars in place.  That would gain me MORE than just a dirty
> look.  Explicit hand signals might be involved....
> 
> Any help would be greatly appreciated.
> 
> TIA!
> 
> Greg Smith
> gregsmith at starband.net
> 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com