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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete temporary table on report close

Status
Not open for further replies.
weckels

weckels

MIS
Joined
May 9, 2002
Messages
26
Location
US
I have a report that gets its data from a table. When I close the report I want to delete the table. If I use DoCmd.DeleteObject acTable, TableName in the report close or deactivate event it tells me I can't lock the table because it is in use. Any thoughts? Thank you!

Will
 
Sort by date Sort by votes
I assume a form calls the report. After returning from the report call, then do your delete. Something to consider is to keep the database table and just do a delete *.

htwh Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

Chester County, PA Residents
Please Show Your Support...
 
Upvote 0 Downvote
Steve,
Thanks for the reply. Yes, the report runs from a form with a DoCmd. There is a button with a click event that opens the report. If I put the deleteobject after the open report command it tries to delete the table right away after the report loads. On what form event should I put the docmd.deleteobject? I tried using the gotfocus event on the form and nothing happened. Some background info - I use a make-table query to make the table and the NOW function to name the table so the name is always different. I store the name in an invisible field on the form. This is to allow multiple users to have the report open at the same time.
Thanks,

Will
 
Upvote 0 Downvote
Ok... what about on the close event or unload event of the form? Once the form is being cloded, the report file is no longer needed I assume. Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

Chester County, PA Residents
Please Show Your Support...
 
Upvote 0 Downvote
Steve,
The form has other buttons that do the same thing. There could be six tables or more that need deleted. I could add more invisible fields to store the other table names and do if-thens to delete them with the close event. This could get ugly when I add more reports to the form but this might be the only way.
Thanks,
Will
 
Upvote 0 Downvote
Not a big fan of invisible fields, but they must be used in some cases...

Consider having a database table that stores the user name (assuming u have a login page) and the list of temporary tables that are created. Then on the Unload/Close event, loop through that table and clear all the temp tables associated with that user. just a thought. Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

Chester County, PA Residents
Please Show Your Support...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

telephoto
  • Locked
  • Question Question
Report waiting for printer before displaying results
Replies
3
Views
668
dhookom
dhookom
JimStrand
  • Locked
  • Question Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
1K
dhookom
dhookom
caykamanj1966
  • Locked
  • Question Question
Open Report based on selection from a pull-down menu
Replies
12
Views
2K
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question Question
Print multiple copies of report data
Replies
5
Views
1K
dhookom
dhookom
SamuelR
  • Locked
  • Question Question
Dlookup in a report
Replies
13
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top