Robin Lawrence
rgilimited at btconnect.com
Wed Aug 6 08:04:00 CDT 2003
Andy, Solved - works great - just needed to find the right way in.... Thanks Robin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: 06 August 2003 12:05 To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Disable Office links? Robin Try Docmd.ShowToolBar, "toolbarname",acToolBarNo and (to put back on) Docmd.ShowToolBar, "toolbarname",acToolbarWhereApprop -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Robin Lawrence" <rgilimited at btconnect.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: RE: [AccessD] Disable Office links? Date: 06/08/03 09:56 Andy, I've successfully replaced the standard bar as you suggested by using me.toolbar = "test" (a quick test toolbar) in the OnLoad property of the form Unfortunately it appears the Office link is on a database custom toolbar as it still displays below my test toolbar. Any ideas how I can get to that for this form only? Rgds -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: 06 August 2003 09:53 To: AccessD at databaseadvisors.com Subject: Re: [AccessD] Disable Office links? Robin, I think you'd have to build your own custom toolbar without the links, and attach that to the form. If necessary you can also then close the standard one in the form's OnOpen and reopen it in the OnClose. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Robin Lawrence" <rgilimited at btconnect.com> To: "AccessD at databaseadvisors.com" <AccessD at databaseadvisors.com> Subject: [AccessD] Disable Office links? Date: 06/08/03 08:27 Greetings all...... Is it possible to disable the built in Office Links (Export to Excel/Word...) toolbar for a particular form only?? Tia & Regards Robin Lawrence robin at rolledgold.co.uk _____ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> _____ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030806/05758fce/attachment-0001.html>