Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
On Close Report
- Thread starter lowman42
- Start date
I'm assuming that deleting a table is justified and your not just doing it because you don't know a better way
(i.e. the first attempt was a query that was too complex, it has to get done and the 'temp' table is in a front end which is local; or some equally good story).
You can't delete the data source for the report on it's close event... The table could also be open by another object.
If it is the data source for the report, chances are you should delete the table just before you usually create it...
otherwise open a form on your form's close event with an on timer event
(i.e. the first attempt was a query that was too complex, it has to get done and the 'temp' table is in a front end which is local; or some equally good story).
You can't delete the data source for the report on it's close event... The table could also be open by another object.
If it is the data source for the report, chances are you should delete the table just before you usually create it...
otherwise open a form on your form's close event with an on timer event
- Status
Similar threads
- Locked
- Question
- Locked
- Question