[AccessD] Toolbar/Menubar Locking

Charlotte Foust cfoust at infostatsystems.com
Thu Jul 22 13:04:12 CDT 2004


One of the properties of the individual toolbar/menubars is Allow
Customizing and another is Allow Moving.  If both of those are turned
off for each toolbar/menubar that should stop the users from shooting
themselves in the foot, at least in your application.  

Charlotte Foust

-----Original Message-----
From: Greg Smith [mailto:GregSmith at starband.net] 
Sent: Thursday, July 22, 2004 8:01 AM
To: accessd at databaseadvisors.com
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



More information about the AccessD mailing list