Multiple programs open

[fergmj]

I am looking for help in writing code that will not allow my program to be open in more than one instance.

What I mean is if my app is running, and someone tries to open another instance of the program, I can put up a box that says, the program is already running.

Any ideas?

Thanks

fergmj

 

[dpaulson]

Private Sub Form_Activate()
If App.PrevInstance = True Then
MsgBox "Application already loaded"
Unload Me
End If
End Sub

David Paulson