473,320 Members | 1,694 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Preventing users from Switching Forms AccXP

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
Nov 12 '05 #1
4 1864
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
Nov 12 '05 #2
rkc

"Baz'noid" <ba***@rtd.uk..com> wrote in message
news:bo**********@hercules.btinternet.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?
Nov 12 '05 #3
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
Nov 12 '05 #4
Thanks all,

Much appreciated - works a treat!!

Cheers again,

Barry
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Bruce | last post by:
I have a number of forms that do significant work based on variables POSTed from the form. What is the common method of detecting and preventing this work from being done when the form is POSTed as...
1
by: ano1optimist | last post by:
We've got users sharing a database where the front end apps reside on the local PC while the backend app is on the network. We have repeated problems where certain users lock the database causing...
2
by: Johann Blake | last post by:
The following is a bug I have discovered using tab pages and threads and I am looking for a workaround. Create a new Windows Forms application and add a tab control with two tab pages. Add a...
5
by: fbwhite | last post by:
I know this issue has been brought up many times, but I have tried many of the solutions to no avail. I wanted to give my specific case to see if someone could be of any help. We are using the...
10
by: et | last post by:
I have an asp.net program that uses a connection string, using integrated security to connect to a sql database. It runs fine on one server, but the other server gives me the error that "Login...
3
by: Simon Verona | last post by:
I have a parent form which contains a toolbar. The toolbar controls the loading and switching to of MDI child forms. The code for the toolbar click event and one of the subroutines that loads...
9
by: christinamasalha | last post by:
Hello all, I am wondering if anybody can help me with a question I have. I am planning to create an Access database application, this application will be used to keep simple records and stored...
1
by: gomzi | last post by:
hi, Is there any way for preventing the users from entering html code in the form fields? thanks, gomzi.
8
by: mark_aok | last post by:
Hi all, I have a split database. Both the forms, and the tables are stored on a shared network drive (this is Access 2003). The users use the forms, and the tables on the network drive, there...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.