Mike & Doris Manning
mikedorism at adelphia.net
Fri Jul 23 10:36:53 CDT 2004
Lookup the CommandBar object in the help files. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Greg Smith Sent: Friday, July 23, 2004 10:29 AM To: 'Access Developers discussion and problem solving' Subject: RE: [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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com