<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=821290213-06082003><FONT face=Arial color=#008080
size=2>Andy,</FONT></SPAN></DIV>
<DIV><SPAN class=821290213-06082003><FONT face=Arial color=#008080 size=2>Solved
- works great - just needed to find the right way in....</FONT></SPAN></DIV>
<DIV><SPAN class=821290213-06082003><FONT face=Arial color=#008080
size=2>Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=821290213-06082003><FONT face=Arial color=#008080 size=2>Robin
</FONT></SPAN></DIV>
<DIV><SPAN class=821290213-06082003><FONT face=Arial color=#008080
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Andy
Lacey<BR><B>Sent:</B> 06 August 2003 12:05<BR><B>To:</B> 'Access Developers
discussion and problem solving'<BR><B>Subject:</B> RE: [AccessD] Disable
Office links?<BR><BR></FONT></DIV>Robin<BR>Try<BR><BR>Docmd.ShowToolBar,
"toolbarname",acToolBarNo<BR><BR>and (to put back
on)<BR><BR>Docmd.ShowToolBar,
"toolbarname",acToolbarWhereApprop<BR><BR>--<BR>Andy
Lacey<BR>http://www.minstersystems.co.uk<BR><BR><BR><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">--------- Original Message --------<BR>From:
"Robin Lawrence" <rgilimited@btconnect.com><BR>To: "'Access Developers
discussion and problem solving'"
<accessd@databaseadvisors.com><BR>Subject: RE: [AccessD] Disable
Office links?<BR>Date: 06/08/03 09:56<BR><BR>
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<DIV><SPAN class=759353809-06082003><FONT face=Arial color=#008080
size=2>Andy,</FONT></SPAN></DIV>
<DIV><SPAN class=759353809-06082003><FONT face=Arial color=#008080
size=2>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 </FONT></SPAN></DIV>
<DIV><SPAN class=759353809-06082003><FONT face=Arial color=#008080
size=2>Unfortunately it appears the Office link is</FONT></SPAN><SPAN
class=759353809-06082003><FONT face=Arial color=#008080 size=2> on a
database custom toolbar as it still displays below my test
toolbar.</FONT></SPAN></DIV>
<DIV><SPAN class=759353809-06082003><FONT face=Arial color=#008080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=759353809-06082003><FONT face=Arial color=#008080
size=2>Any ideas how I can get to that for this form
only?</FONT></SPAN></DIV>
<DIV><SPAN class=759353809-06082003></SPAN> </DIV>
<DIV><SPAN class=759353809-06082003><FONT face=Arial color=#008080
size=2>Rgds</FONT></SPAN></DIV>
<DIV><SPAN class=759353809-06082003></SPAN> </DIV>
<DIV><SPAN class=759353809-06082003><FONT face=Arial color=#008080
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Andy
Lacey<BR><B>Sent:</B> 06 August 2003 09:53<BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Disable
Office links?<BR><BR></FONT></DIV>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.<BR><BR>--<BR>Andy
Lacey<BR>http://www.minstersystems.co.uk<BR><BR><BR><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">--------- Original Message
--------<BR>From: "Robin Lawrence"
<rgilimited@btconnect.com><BR>To: "AccessD@databaseadvisors.com"
<AccessD@databaseadvisors.com><BR>Subject: [AccessD] Disable
Office links?<BR>Date: 06/08/03 08:27<BR><BR>
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<DIV><FONT face=Arial size=2><SPAN class=111421408-06082003>Greetings
all......</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=111421408-06082003>Is it
possible to disable the built in Office Links (Export to Excel/Word...)
toolbar for a particular form only??</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=111421408-06082003></SPAN></FONT> </DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial><FONT size=2><SPAN
class=111421408-06082003>Tia & </SPAN>Regards</FONT></FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Robin Lawrence</FONT></DIV>
<DIV align=left><FONT face=Arial
size=2>robin@rolledgold.co.uk</FONT></DIV>
<DIV> </DIV><BR><BR>
<HR>
<BR><FONT face="Courier New"
size=2>_______________________________________________<BR>AccessD
mailing list<BR><A class=autolink
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
class=autolink
href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A class=autolink href="http://www.databaseadvisors.com/"
target=_blank>http://www.databaseadvisors.com</A><BR></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE><BR><BR>
<HR>
<BR><FONT face="Courier New"
size=2>_______________________________________________<BR>AccessD mailing
list<BR><A class=autolink
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
class=autolink href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A class=autolink href="http://www.databaseadvisors.com/"
target=_blank>http://www.databaseadvisors.com</A><BR></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>