I'm using Me.Hwnd in forms. It's how I keep track of certain things.
One use is to place it in my record locking table, so if there are two FormCustomer running,
one instance of a form can't start editing the record that another instance is currently editing (and has locked).
The problem happens when there is an Access crash, and the lock doesn't get cleared.
As part of the routine, I delete the lock record if it's the same user trying to get back into the record,
but to work properly, I need to know if the Hwnd is currently active in another instance, in which case I don't want to delete the lock.
(Not all forms are instanced, but I would need to check the Hwnd anyways, so one routine handles both situations.)
Is there a way to see if Access (or Windows) has a certain Long Hwnd active?
(my search in Google wasn't productive for this question)