I am getting a write conflict and I need some trouble shooting help. There are a series of forms that are used to enter payables and print a backup sheet for the invoice.
Here is the process
form1
1.enter in price per unit
2.enter in ticket # (primary key)
3.click button(runs update query to update price by ticket#)
reduce form because form2 uses ticket # on form 1 for datasource query as criteria.
open form2
1.enter invoice#, invoice date,Invoice amount
2.press button for print backup(saves,runs query to update invoice number,date,and amount,and reduce form2,open report)
backup report
1.print report
2.close report
("on close"of report has close form2 and restore form1)
That's it.
Where is the write conflict. There is no one else using the dbase at the time. Only one user is using it. I try to recreate the error on my computer and it will not happen. I sit with her and watch her do it and she is doing it correctly. She only gets the error when she closes the report. All information records into the table fine with the exception of the invoice amount which is a claculated field in the soruce query of form2, it will not recorde when she gets the error. The error does not happen every time either. This is really bugging me if any one has ever had this problem some input would be nice. Thanks
This is the error we are getting:
Write Conflict
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made...
rbe
RBE
Are you 100% sure of where you are going.
Here is the process
form1
1.enter in price per unit
2.enter in ticket # (primary key)
3.click button(runs update query to update price by ticket#)
reduce form because form2 uses ticket # on form 1 for datasource query as criteria.
open form2
1.enter invoice#, invoice date,Invoice amount
2.press button for print backup(saves,runs query to update invoice number,date,and amount,and reduce form2,open report)
backup report
1.print report
2.close report
("on close"of report has close form2 and restore form1)
That's it.
Where is the write conflict. There is no one else using the dbase at the time. Only one user is using it. I try to recreate the error on my computer and it will not happen. I sit with her and watch her do it and she is doing it correctly. She only gets the error when she closes the report. All information records into the table fine with the exception of the invoice amount which is a claculated field in the soruce query of form2, it will not recorde when she gets the error. The error does not happen every time either. This is really bugging me if any one has ever had this problem some input would be nice. Thanks
This is the error we are getting:
Write Conflict
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made...
rbe
RBE
Are you 100% sure of where you are going.