<html><div style='background-color:'><DIV>
<P><BR>How about if you bind the report to a SQL statement? Then delete what you want. <BR></P></DIV>
<DIV></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Swisher, Timothy B." <TSWISHER@GFNET.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: [AccessD] Delete Table from report
<DIV></DIV>>Date: Thu, 1 May 2003 14:10:58 -0400
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Hi group, I have a report that on open builds a temp table, populates the
<DIV></DIV>>table, then displays the info in the report. I would like to delete the
<DIV></DIV>>table when the report closes, but since the report is bound to the table, it
<DIV></DIV>>will not let me delete the table. This is a standalone report, it is not
<DIV></DIV>>being called from a form or anything so I can't put the code there. I open
<DIV></DIV>>the report from the db window, do the processing, then I want to delete the
<DIV></DIV>>table. A2K by the way. Any ideas? TIA.
<DIV></DIV>>
<DIV></DIV>>Tim
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>Help STOP SPAM with <a href="http://g.msn.com/8HMMENUS/2731">the new MSN 8 </a> and get 2 months FREE*</html>