<!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.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=635553618-01052003><FONT face=Arial size=2>Mark, way to
tease me with a solution then not provide one! I was trying to delete
the table completely so as to only have a report. We are going to use this
report in a bunch of our databases and I wanted it to be just a single
object. Thanks.</FONT></SPAN></DIV>
<DIV><SPAN class=635553618-01052003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=635553618-01052003><FONT face=Arial
size=2>Tim</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> Mark
Whittinghill [mailto:mwhittinghill@symphonyinfo.com] <BR><B>Sent:</B>
Thursday, May 01, 2003 3:28 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Delete Table
from report<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>