Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
difference Close and Nothing in query
for example dim db as dao.database ..... ..... db.Close set db = Nothing i want to know that difference of upper 2 code. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
difference Close and Nothing in query
The first closes the actual database file, the second empties the value
assigned to the variable "db". Mike F "x taol" wrote in message ... for example dim db as dao.database .... .... db.Close set db = Nothing i want to know that difference of upper 2 code. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difference application.quit & application.close | Excel Programming | |||
save & close after web query refresh | Excel Discussion (Misc queries) | |||
Auto Open file VBA Refresh MS Query Save Close | Excel Programming | |||
charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |