 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / March 2008Closeing Access 97
Hi, I use a macro to update a table with data from several sources. after runing it I can close the data base but I can't close access itself. any sugestions MarkS >I use a macro to update a table with data from several sources. after runing >it I can close the data base but I can't close access itself. That usually happens because an object variable was not closed/cleared. Check to make sure that you close what you open and set every object variable to Nothing when you are done using it. There was also a bug in code like: If checkbox Then that would leave the checkbox object hanging around. This had several simple workarounds: If checkbox.Value Then or If checkbox = True Then or If (checkbox) Then  SignatureMarsh MVP [MS Access] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.