Preventing users from Switching Forms AccXP

[Baz'noid]

Hi all,

As the size of my database and the number of users grows, i've found a
horrible bug in the system with a very simple solution (but i don't know how
to implement it)...

If two people are accessing the database simultaneously (literally at the
same time), things slow down a little. No problem. The problem becomes if
one user switches from one form to another from a customer's record (in this
case, having the details open as the main form, and payments form, order
detail form) and edits it. If someone else is editing a record at the same
time, access instantly confuses itself and corrupts the data in the field
trying to be edited.

This has caused unbelievable problems, especially since we lost over 200
customer records as a result at one point!!! I have figured out the
solution is to ensure each user can only have two forms open at a time, and
being forced to close the form they are leaving when going to another one,
thus ensuring the data is saved correctly.

For example:

Orders by Customer form open (always is)
Order Details form open

User finishes entering data on the order details form, and wants to open the
Payments form. I want to force the user to close the order details form
before allowing the payments form to open.

Any suggestions on the coding to do this?

Thanks,

Barry W

[Jim Allensworth]

On Mon, 3 Nov 2003 16:11:19 +0000 (UTC), "Baz'noid"
<ba***@rtd.uk.. com> wrote:

Hi all,

As the size of my database and the number of users grows, i've found a
horrible bug in the system with a very simple solution (but i don't know how
to implement it)...

If two people are accessing the database simultaneously (literally at the
same time), things slow down a little. No problem. The problem becomes if
one user switches from one form to another from a customer's record (in this
case, having the details open as the main form, and payments form, order
detail form) and edits it. If someone else is editing a record at the same
time, access instantly confuses itself and corrupts the data in the field
trying to be edited.

This has caused unbelievable problems, especially since we lost over 200
customer records as a result at one point!!! I have figured out the
solution is to ensure each user can only have two forms open at a time, and
being forced to close the form they are leaving when going to another one,
thus ensuring the data is saved correctly.

For example:

Orders by Customer form open (always is)
Order Details form open

User finishes entering data on the order details form, and wants to open the
Payments form. I want to force the user to close the order details form
before allowing the payments form to open.

Any suggestions on the coding to do this?

Ooh, you need to split this into frontend and backend - the frontend
for the code and the backend for the data. There is even a wizard for
this if you need.

That should deal with all of the issues you mention.

- Jim

[rkc]

"Baz'noid" <ba***@rtd.uk.. com> wrote in message
news:bo******** **@hercules.bti nternet.com...

<snip>

User finishes entering data on the order details form, and wants to open the Payments form. I want to force the user to close the order details form
before allowing the payments form to open.

Any suggestions on the coding to do this?

Set the form's modal property to true?

[Albert D. Kallal]

Just make your forms model. (it is a setting in the other tab). Use of
"model" forms is for exactly what you need. (i.e.: you must close the
current form to return to previous forms). I would say that about 98% of my
forms are model.
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
No************@ msn.com
http://www.attcanada.net/~kallal.msn

[Baz'noid]

Thanks all,

Much appreciated - works a treat!!

Cheers again,

Barry