Locking a form for other users if already opened

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Megz said:
I have a multi-user database on a network. We use a packing slip form for
Click to expand...
data entry. I need to stop other users opening this form if someone has it
open already, as the Data gets mixed up.
 
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

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Megz said:
Thanks.
Thats how i currently have it. Except when a user enters the form and
Click to expand...
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....
 
Each packing slip record has a unique number given to it when opened. Previous packing slip + 1
 
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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Megz said:
Thanks.
Thats how i currently have it. Except when a user enters the form and
Click to expand...
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....
 
Back
Top