By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Deleting a table - timing conflicts

P: n/a
I created a report to display all the tables/fields in a db, and all the
code is in the report's module - for easy one-chunk portability to other
apps. In the OnOpen, I create a temp table, fill it from the tabledefs
collection, then open the report. Works fine. In the OnClose, I want to
delete the table, but the report still has hold of it. I've tried a number
of ways to delay the delete (DoEvents, empty For loop, dummy MsgBox), but no
luck. I don't know what other event to hang this on. I was able to *empty*
the table onClose, but I really like to delete it for a clean exit. Ideas?

Thanks,

Armando
Aug 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Why not cheat and open a hidden form and then close it when the report
closes. Then you can clear the table when the hidden form closes.

Aug 23 '06 #2

P: n/a
I've thought along similar lines, but would really like it all to be in one
piece, just the report I can drop into any app and it's ready to go out of
the box. I forgot to mention I also tried changing the report's record
source to "" before deleting the table, but I'm not allowed to do that after
the report is open. Funny, I used to do that in the past - open a report,
THEN tell it what its record source is (same report reused from several
places) - not sure why I can't do that anymore.

Thanks! Armando

<pi********@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Why not cheat and open a hidden form and then close it when the report
closes. Then you can clear the table when the hidden form closes.

Aug 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.