Mark Whittinghill
mwhittinghill at symphonyinfo.com
Thu May 1 14:27:45 CDT 2003
Delete Table from reportI 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 ----- Original Message ----- From: Swisher, Timothy B. To: 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/961be8c0/attachment-0001.html>