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

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

Form in library database

Back to article view | Back to comp.databases.ms-access

Contents

  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

#10905 — Form in library database

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

[toc] | [next] | [standalone]

#10906

On 03/07/2015 17:32:47, "Phil" wrote:
> 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
> 

Ah - solved it.
I now get a success or failure flag when I update the Progress meter.
If I get success, I continue with the loop: 
If failure because the Progress Meter is closed I can exit the loop

Phil

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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web