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>