Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-access > #10905

Form in library database

From "Phil" <phil@stantonfamily.co.uk>
Newsgroups comp.databases.ms-access
Subject Form in library database
Date 2015-07-03 17:32 +0100
Organization Aioe.org NNTP Server
Message-ID <mn6dfl$odv$1@speranza.aioe.org> (permalink)

Show all headers | View raw


I have a form in a referenced library database ClsMeterRainbow which is a
type of progress meter and shows, among other things, how many records in the
main database have been read and processed. Obviously this is done using a Do
Until .EOF ……..  Loop All works perfectly.

I now want to terminate the loop (Exit Do) if the ClsMeterRainbow form has
been closed. What I thought would work is just before updating the progress
meter, I would check that it is still loaded, and if so, continue the loop
and if not, Exit the loop. I assumed
CodeProject.AllForms(“ClsmeterRainbow”).IsLoaded would give me the required
information, but I get an error 2467 … object closed or doesn’t exist.

CodeProject.AllForms(“ClsmeterRainbow”).Name        gives a similar error
Any ideas how to check if a form in a referenced database library is loaded?

Thanks

Phil

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar | Unroll thread


Thread

Form in library database "Phil" <phil@stantonfamily.co.uk> - 2015-07-03 17:32 +0100
  Re: Form in library database "Phil" <phil@stantonfamily.co.uk> - 2015-07-04 17:21 +0100

csiph-web