ISLOADED

[Trudye]

Back in the day (I've been coding VB about 6 months now) when I was coding VBA we used the func IsLoaded. Does VB have a comparable func?

Thanks much
Trudye

 

[SonOfEmidec1100]

Yes, but it only refers to AccessObjects, I know nothing about it, other than whats in MSDN help.

Quote - "You can use the IsLoaded property to determine if an AccessObject is currently loaded. Read-only Boolean."

 

[Trudye]

Thanks so much fo responding. I was hoping their was a command I could use to conserve RAM and increase processing.

Be well,
Trudye

 

[SonOfEmidec1100]

Dont we all !!!!


If you you want to check for loaded forms

Dim frm As Form

For Each frm In Forms

debug.print frm.name & " is loaded"

Next

 

[petevick]

Is there also a DataReport collection similar to the Forms collection for checking on loaded or shown reports, I've had a quick look but I'm thinkng that there isn't.

 

[Trudye]

SonOfEmidec:

Thanks a lot, I got that to work. But here is the grabber, what does VB's unload command look like? frm.unload or frm.name.unload do not work. Is there a VB unload command?

Thanks
Trudye

 

[andylec]

Unload frmYourForm

rgds
Andy

 

[Trudye]

There in lies my problem because I cannot do an isloaded ck, I don't know if a form is loaded or not. One option is to close them all (by looping thru the form collection), and then opening the one the client selected.

Unless someone has another idea.

Thanks Andy for responding.
Trudye

 

[johnwm]

Just put together the Forms collection from SonofEmidec's post and the Unload Form code from andylec and you get:

Dim f As Form
For Each f In Forms
If f.Name = "Form3" Then Unload f
Next


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[Trudye]

Thanks.