Search results
-
P
Update Query gives error
They do have primary keys...this does not fix the problem however. -
P
Update Query gives error
Its based on a table, there are no linked tables in this particular database. -
P
Update Query gives error
Does anyone know why I get the error "Operation must use an updateable query" when I run this query. UPDATE Food_Table SET Food_Table.Delivery_Size = (SELECT Delivery_Size FROM Delivery_Table WHERE ((Delivery_Table.Region=Forms.Formulation_Combo.Region_Combo) AND... -
P
Append if Record Doesnt Exist, Else Update
I have a table that is filled based on selections that a user makes in combo boxes on a form. I am having trouble trying to figure out the best way to prevent duplicates from being inserted in the table when I do the append query part. Since the table is filled based on the various selections... -
P
Syntax Question
I have an update query that updates a table based on a form I created. It currently works but I want to switch the column that is displayed in the table. For example: I have the field names Food and Food ID. "Sandwich" falls under Food and its ID is "1". When I put "Forms.Food_Form.Food" in the...