Swisher, Timothy B.
tswisher at GFNET.com
Thu May 1 14:12:57 CDT 2003
Charles, Your missing the point. The temp table is absolutely needed. I am cycling through the .AllForms and .AllReports collection grabbing certain data and populating a temp table. Unless you know of a way to query this info, the temp table is absolutely needed. Tim -----Original Message----- From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] Sent: Thursday, May 01, 2003 2:57 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Delete Table from report Tim, You miss the point, don't use a temp table unless absolutely needed. Use queries instead to build up the data for the final select query that is used at 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:37 To: 'accessd at databaseadvisors.com' Subject: RE: [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 -----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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com