IsOpen or IsLoaded?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to find out if a form is open, and I'm having problems working with
IsOpen and IsLoaded. I can't seem to get the syntax for the arguements
right. Can someone please explain the difference between the two and give a
reference for the syntax used with each?

Thanks - ElizCat
 
I need to find out if a form is open, and I'm having problems working with
IsOpen and IsLoaded. I can't seem to get the syntax for the arguements
right. Can someone please explain the difference between the two and give a
reference for the syntax used with each?

Thanks - ElizCat
Click to expand...

I assume you are not using Access 97 or older.

IsOpen applies to a HTMLProjectItem Object.
IsLoaded applies to an AccessObject.Object.

This sounds like a classroom assignment.
Since VBA help has information and an example of each it might be
helpful to you to refer to it.
 
After looking in the Forms Coding message group, it seems that my confusion
might stem from variations between Access 97 and Access 2002 (the version I
am using). And no, this is not for a class... I'm just a novice and am
working from some books (on Access97, hence my confusion) a colleague loaned
me. I've got the double-whammy of being a novice and not having a background
in CompSci, so I'm having some difficulty translating VB-ese to plain English.

So, here's what I tried (based on the VB Help example)

If CurrentProject.AllForms("FormOfInterest").IsLoaded Then
'do one thing
Else
'do something else
End If

However, this isn't working. VB is not reading IsLoaded = True and doing
the appropriate code. I'll try Ofer's suggestion to call a function to
return True/False, but I wondered where I went wrong.

I appreciate your feedback.

ElizCat


:
 
Thanks for the reference - it worked just fine, once I figured out that I had
to put the Public Function code in the General section of the Form(s) I'm
working in.
 
Back
Top