MS access multi users : Determine which form is open

[Amine]

Hello,
I'm sharing a ms access project over network with multiple users.
I want to know which form is already opened by the other users in their computer.
for that, i have a form called "dashboard" containing two buttons , each button open a different form (docmd ...) the first button open the form "Form1", the second button open the form "Form2".
The idea is that buttons in "Dashboard" changes their colors (caption.forecolor) when they opened by a user.
I used the code :

 Private Sub FormsCtl()
If CurrentProject.AllForms("Form1").IsLoaded = True Then
Me.Commande0.ForeColor = RGB(255, 0, 0)
Else:
Me.Commande0.ForeColor = RGB(51, 204, 51)
End If
If CurrentProject.AllForms("Form2").IsLoaded = True Then
Me.Commande1.ForeColor = RGB(255, 0, 0)
Else:
Me.Commande1.ForeColor = RGB(51, 204, 51)
End If
End Sub

Private Sub Form_Open(Cancel As Integer)
FormsCtl
End Sub


Private Sub Form_Timer()
FormsCtl
End Sub

When I open a form (Form1 or Form2) in my computer , I get the code working perfectly (Buttons colors changed) .


But when an other user open the same forms in his own computer, Colors of buttons don't change in my computer.

[ranman256]

you should NOT share a db frontend with many users.
each user should get their own copy of the FE.

[Amine]

thanks for your fast reply, but before distribuating frontend copies, i should make a working code.

[Gicu]

That kind of code will not work on two different machines. To implement something like this you will need to create a table in the back-end where you would add a record containing the user name and the form name then delete that when that same user closes the form. Then you would use a dLookup or dCount in that table to check if any current user has the form open. Might be something that you think might be "pretty" but too much hassle for the limited benefits it offers in my humble opinion.

Cheers,

[Micron]

Assuming you could get a working code, when you split the db into back and front ends it would never work to show anything on your fe copy. What is the point of wanting to know who has a form open in a stand-alone db?

If you must do this, IMO you will have to store the facts (user name, form, etc.) in a table that is in the back end and you could check it from your fe. However, you would have to also remove a record every time the form closes, and the whole process will be somewhat unreliable.