Search results

I received the message above after executing a stored procedure from my ado code. The error appeared in the recordcount property of the If statement. Here is how my sub routine looks like: Private Sub w_o__history_Click() On Error GoTo Err_w_o_history_Click Dim ret_val As Integer Dim...

write conflict Hello Pat, I really need your help to find the write conflict error. I've been working on it for days/weeks and still not sure how I can fix it. I am using Access 2000 fe and SQL SERVER 7.0 as BE The subform is bound to a table. Could you please look @ my code Sub...

write conflict Thanks so much for your reply. I will look into mine more closely. Thanks!!

write conflict I am in same situation and received the exact error when I update my records. Were you able to fix this error? You posted previously: I have an MS Access database that is running ADO code to work against a SQL back-end. I have a form in which the users can delete records out...

write conflict in main/subform I have the similiar problem with write conflict when going in/out of main/subform. Did you have problem solved?

The syntax you have is correct. I think it's going to work. Thank you very much! Have a good day!

type mismatch These all work DoCmd.OpenForm "shipment_hist_list", , , "[shipped_date] = " & " ' " & bdt & " ' " DoCmd.OpenForm "shipment_hist_list", , , "[shipped_date] ='7/8/2003'" DoCmd.OpenForm "shipment_hist_list", , , "[shipped_date] <= " & " ' " & edt & " ' " but when I combined the...

syntax in openform no, it is still not working. It works with an actual date in this format DoCmd.OpenForm "shipment_hist_list", , , "[shipped_date] ='7/8/2003'" any other suggestions? Thanks

What is the correct syntax for where criteria in the openform method? I would like to compare the shipped date in the form based on a table with the input date. The error occurred in the syntax in input date because I tested with an actual date and is working. I tried various ways but still...

Yes, the subform is bound to a table. In the procedure I ran two stored procedures and they both update the same record in that table I believe that is causing the write conflict error. I believe I might have a solution to the problem. I will see if it will work. Thanks for your reply...

Write Conflict “This Record has been changed by another user since you started editing it. If you save the record you will overwite the changes the other user made. Copying the values into the clipboard will allow you to look at the values the other user entered, and then paste your changes...