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

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

Re: Form in library database

Show all headers | View raw

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

Back to comp.databases.ms-access | Previous | Next — Previous 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