[AccessD] Delete Table from report

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.
 
Tim

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Thursday, May 01, 2003 2:28 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Delete Table from report


Tim,
 
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.

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

-----Original Message-----
From: Swisher, Timothy B. [mailto:tswisher at GFNET.com] 
Sent: Thursday 2003 May 01 13:11
To: accessd at databaseadvisors.com
Subject: [AccessD] Delete Table from report




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.

Tim 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030501/47ede631/attachment-0001.html>