fIsLoaded function

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

Guest

Good afternoon,
I found the fIsLoaded function on the AccessWeb website. Looks to be pretty straightforward. My only question is this:

Does it check to see if the form is open by ANYONE, or only for the front end it's running on?

I want to check to see if a window is open on a particular user's screen as opposed to checking to see if 0 copies are open or more than 0.

Does my question make sense?

Thank you!
Derek
 
Only for the front end it's running in. There's no way that I'm aware of to
check other users' screens.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Derek Wittman said:
Good afternoon,
I found the fIsLoaded function on the AccessWeb website. Looks to be
pretty straightforward. My only question is this:
Does it check to see if the form is open by ANYONE, or only for the front end it's running on?

I want to check to see if a window is open on a particular user's screen
as opposed to checking to see if 0 copies are open or more than 0.
 
Derek,

Can I assume by the way you asked the question that you
have a single copy of the FE and it is being used by more
than one person at the same time?

Rob

-----Original Message-----
Good afternoon,
I found the fIsLoaded function on the AccessWeb website.
Looks to be pretty straightforward. My only question is
this:
Does it check to see if the form is open by ANYONE, or
only for the front end it's running on?
I want to check to see if a window is open on a
particular user's screen as opposed to checking to see if
0 copies are open or more than 0.
 
Actually, Rob, there is 1 FE for each user (there are about 10 users for this application). What I'm thinking might work is that whenever a user types a message to another user (all FEs are running an OnTimer which checks) the message contains a YES in a Yes/No field. If the recipient's userID matches the fOSUserName() function (from Dev Ashish), then he or she gets a docmd.beep, the Messenger form opens AND the YES is SQL updated to NO.

The OnTimer event fires when the timer loops hits 60000 (10 seconds). This event is part of my hidden copyright form that prevents anyone from QUITting Access without using the QUIT command button on the Switchboard form.

Finally, to clarify, each user's FE will be running the OnTimer event in its own instance.

Does this help?

Thank you!
Derek
 
Back
Top