<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Delete Table from report</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2723.2500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I had done something like this OnClose in the past
that worked, but I don't have that handy anymore. Another option would be,
rather than creating a table on open, you could append to your table, and delete
all records on close.</FONT></DIV>
<DIV><FONT face=Arial size=2><BR>Mark Whittinghill<BR>Symphony Information
Services<BR>612-333-1311<BR><A
href="mailto:mwhittinghill@symphonyinfo.com">mwhittinghill@symphonyinfo.com</A></FONT></DIV>
<BLOCKQUOTE
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 ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=tswisher@gfnet.com href="mailto:tswisher@gfnet.com">Swisher, Timothy
B.</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, May 01, 2003 12:10
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Delete Table from
report</DIV>
<DIV><BR></DIV><BR>
<P><FONT face=Arial size=2>Hi group, I have a report that on open builds a
temp table, populates the table, then displays the info in the report. I
would like to delete the table when the report closes, but since the report is
bound to the table, it will not let me delete the table. This is a
standalone report, it is not being called from a form or anything so I can't
put the code there. I open the report from the db window, do the
processing, then I want to delete the table. A2K by the way. Any
ideas? TIA.</FONT></P>
<P><FONT face=Arial size=2>Tim</FONT> </P>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>