[AccessD] Delete Table from report

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

-----Original Message-----
From: Mark Whittinghill [mailto:mwhittinghill at symphonyinfo.com] 
Sent: Thursday, May 01, 2003 3:28 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Delete Table from report


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.

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com <mailto:mwhittinghill at symphonyinfo.com> 

----- Original Message ----- 
From: Swisher,  <mailto:tswisher at gfnet.com> Timothy B. 
To: accessd at databaseadvisors.com <mailto:accessd at databaseadvisors.com>  
Sent: Thursday, May 01, 2003 12:10 PM
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


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