Locking a form for other users if already opened

[Megz]

I have a multi-user database on a network. We use a packing slip form for data entry. I need to stop other users opening this form if someone has it open already, as the Data gets mixed up

HELP

 

[RobFMS]

One (simple) suggestion would be to create a table that tracks if the form
is opened or closed.
When a request is made (by clicking a button or by other means) to open the
form, check the value of the field in the table. Depending on the value of
the field will determine if the user can open the form.

Table: tblLock
Field: IsLocked (yes/no)

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I have a multi-user database on a network. We use a packing slip form for

data entry. I need to stop other users opening this form if someone has it
open already, as the Data gets mixed up.

 

[Megz]

Thanks
Thats how i currently have it. Except when a user enters the form and gets allocated a unique id from looking up the previous record they may get sidetracked (then the table hasnt picked up any data being entered yet). then another user enters getting the same unique id and thats when i get a mixed up record...

 

[RobFMS]

Megz

I'm a bit confused by the 'UniqueID' information....

As I mentioned previously, the goal is to look at the field to determine "is
someone using the form now or is the form available", which is why I
indicated it to be a YES/NO field.

How does the UniqueID come into play?

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Thanks.
Thats how i currently have it. Except when a user enters the form and

gets allocated a unique id from looking up the previous record they may get
sidetracked (then the table hasnt picked up any data being entered yet).
then another user enters getting the same unique id and thats when i get a
mixed up record....

 

[Megz]

Each packing slip record has a unique number given to it when opened. Previous packing slip + 1

 

[RobFMS]

I'm confused why the second user would get in if the first person is already
in? That is why I suggested the table that tracks if a user is already in
the table. Any additional users wanting to get into the form would be
stopped b/c the first user has not exited out (and thus changed the lock
status in the table).

This process (above) is independent of the unique id.

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Thanks.
Thats how i currently have it. Except when a user enters the form and

gets allocated a unique id from looking up the previous record they may get
sidetracked (then the table hasnt picked up any data being entered yet).
then another user enters getting the same unique id and thats when i get a
mixed up record....