[AccessD] Delete Table from report

Heenan, Lambert Lambert.Heenan at aig.com
Thu May 1 14:44:14 CDT 2003


Just a thought...

In your report's OnClose event could you call an external routine that looks
something like this pseudo code...

Sub DeleteTempTable
Dim sName as String
	On Error Resume Next
	' wait until the report closes
	While Err.Number = 0
		sName = Reports("YourReportName").Name
	Wend
	' then delete your temp table
End Sub

Lambert

> -----Original Message-----
> From:	Swisher, Timothy B. [SMTP:tswisher at gfnet.com]
> Sent:	Thursday, May 01, 2003 3:13 PM
> To:	'accessd at databaseadvisors.com'
> Subject:	RE: [AccessD] Delete Table from report
> 
> 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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list