how do you prevent openning a form if already open by another user

[Celene]

I am creating a database to be used by multi users. how do you prevent
openning a form if already open by another user?

 

[Jerry Whittle]

You don't. Now you could lock the records that the form is looking at so
others couldn't modify them.

Why do you you wish to do this?

 

[mscertified]

What are you trying to accomplish? Tell us that and we will advise you the
best way to do it.

-Dorian

 

[Sophie]

Hi, any luck with this?
I am having a similar problem. When a user re-opens a form which is already
open the screen turns black and they have to close all the forms and start
again. How can I get around this? Can anyone help?

 

[Evi]

Your database should be split into a Front End and Back End so that each
user has their own copy of the Front End forms while the Back End tables
remain on your server. Is this what you have, Sophie?
There are a few tips here although they don't mention screens turning black!
http://msdn2.microsoft.com/en-us/library/aa167840(office.11).aspx
Evi

 

[George Nicholson]

In your code, use some variation of IsLoaded to check if the form is already
open. If it is, don't issue the 2nd DoCmd.OpenForm.

IsLoaded function is in Northwind and a variation can also be found
http://mvps.org/access/forms/frm0002.htm