Search results

Thanx.. Yep this has worked, I found the problem the ItemID column was not numeric. Thanx for all your help, reguarding another issue... is there a piece of vba code to clear a text field after the update query has been done? Thanx in advance. Johnty:D

No Luck... I have had no luck with getting this to work. It is basically to update a specific record in tblStock with a new value that is in a calculated field in a form. On the form it has the key field ItemID that is unique to every record. The calculated field is called Restock and the...

Hey all, I have a problem with my update query (SQL), The situation where it is used: The SQL code is as a command on a button on a form. It is used to take the value in the text box(Name: Restock) and update it to the Quantity field in the table. (tblStock) The problem is that the...

Hey all, I have a problem with my update SQL, The situation where it is used: The SQL code is as a command on a button on a form. It is used to take the value in the text box(Name: Restock) and update it to the Quantity field in the table. (tblStock) The problem is that the Update...