Access doesn't shut down

  • Thread starter Thread starter ceri
  • Start date Start date
C

ceri

Guest
I have a couple of access97 apps which leave an empty access window open when I quit. I thought this might have been due to unresolved references but I can't find any. Any ideas?
 
I used to have the same problem if I used SendKeys with the Find function. Another reason to avoid using SendKeys if you are.

HTH
 
First thing that comes to mind is, do you have an code in either general or class modules that opens a recordset or a new workspace or a file?

If so, you need to make sure that you always close what you open. Otherwise you get into a process rundown state where you can't close anything and can't get rid of anything.
 
Thanks for ideas, I finally tracked down the reason, was due to a reference to another loaded form in the format "Forms!frmOrder.exchangerate" - changed it to Forms!frmOrder!txtExchangeRate ...and wheeehey!...all now shuts down!....can't say I totally understand the reason for this though, except maybe it had opened another instance of the form?
 

Users who are viewing this thread

Back
Top Bottom