Search results

Hi, I have an issue with a subform that I am enabling or disabling depending on the status shown on the main form. I have an event occurring at "On Current" on the subform that checks the status of the main form and if it is new record or status "open" set allow additions/edits/deletions to...

Okay, but can you see any issue with the query?

Hi, I'm trying to duplicate the records in a subform to a new form but keep getting a too few parameters error. Can anyone spot my issue? I've been staring at it all day. strSql = "INSERT INTO [OrderDetailT] ( OrderID, ProductID, Quantity, DiscountPercentage ) " & _ "SELECT " & lngID & "...

Hi, This is going to seem so easy but I cannot get this simple update query to work. UpdateProcess = "UPDATE OrderDetailT SET DepSubCompl =" & Date & " WHERE ID=" & Forms![JobCardandSignoffF]![ID] CurrentDb.Execute UpdateProcess If I run the debug over it UpdateProcess comes out...