<html><div style='background-color:'><DIV>
<P><BR>Oh you mean DROP not Delete. Well then, how about creating a snapshot from the report, if you're dropping the table, odds are the data is not gonna change in the report.<BR>_D</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'" <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Delete Table from report
<DIV></DIV>>Date: Thu, 1 May 2003 14:39:43 -0400
<DIV></DIV>>
<DIV></DIV>>Mark, way to tease me with a solution then not provide one! I was trying
<DIV></DIV>>to delete the table completely so as to only have a report. We are going to
<DIV></DIV>>use this report in a bunch of our databases and I wanted it to be just a
<DIV></DIV>>single object. Thanks.
<DIV></DIV>>
<DIV></DIV>>Tim
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: Mark Whittinghill [mailto:mwhittinghill@symphonyinfo.com]
<DIV></DIV>>Sent: Thursday, May 01, 2003 3:28 PM
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: Re: [AccessD] Delete Table from report
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>I had done something like this OnClose in the past that worked, but I don't
<DIV></DIV>>have that handy anymore. Another option would be, rather than creating a
<DIV></DIV>>table on open, you could append to your table, and delete all records on
<DIV></DIV>>close.
<DIV></DIV>>
<DIV></DIV>>Mark Whittinghill
<DIV></DIV>>Symphony Information Services
<DIV></DIV>>612-333-1311
<DIV></DIV>>mwhittinghill@symphonyinfo.com <mailto:mwhittinghill@symphonyinfo.com>
<DIV></DIV>>
<DIV></DIV>>----- Original Message -----
<DIV></DIV>>From: Swisher, <mailto:tswisher@gfnet.com>Timothy B.
<DIV></DIV>>To: accessd@databaseadvisors.com <mailto:accessd@databaseadvisors.com>
<DIV></DIV>>Sent: Thursday, May 01, 2003 12:10 PM
<DIV></DIV>>Subject: [AccessD] Delete Table from report
<DIV></DIV>>
<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>>
<DIV></DIV>>
<DIV></DIV>> _____
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<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></DIV>>
<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></mailto:accessd@databaseadvisors.com></mailto:tswisher@gfnet.com></mailto:mwhittinghill@symphonyinfo.com></div><br clear=all><hr>STOP MORE SPAM with <a href="http://g.msn.com/8HMMENUS/2728">the new MSN 8</a> and get 2 months FREE*</html>