<!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></HEAD>
<BODY>
<DIV><SPAN class=232173518-01052003><FONT face=Arial size=2>Actually it is a
select statement, but that still has an open connection to the table, so I can't
delete the table. I also tried to reset the recordsource, but after the
report opens, I can't change it. Thanks.</FONT></SPAN></DIV>
<DIV><SPAN class=232173518-01052003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=232173518-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> Wortz, Charles
[mailto:CWortz@tea.state.tx.us] <BR><B>Sent:</B> Thursday, May 01, 2003 2:28
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Delete Table from report<BR><BR></FONT></DIV>
<DIV><SPAN class=888262418-01052003><FONT color=#0000ff
size=2>Tim,</FONT></SPAN></DIV>
<DIV><SPAN class=888262418-01052003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=888262418-01052003><FONT color=#0000ff size=2>Instead of the
temp table, why not use a query? Probably everything you did to get the
data into the temp table can also be done to create a select query to use as
the datasource for the report.</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas
Education Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701
N. Congress Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin,
TX 78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Swisher, Timothy
B. [mailto:tswisher@GFNET.com] <BR><B>Sent:</B> Thursday 2003 May 01
13:11<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Delete Table from report<BR><BR></FONT></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></BLOCKQUOTE></BODY></HTML>