Search results

Hi all, I'm trying to use an update query, but somehow, it doesn't store anything in my database. This is my code: sql = "UPDATE CONSTRUCTIEF SET ConstructiefScore = " & strGebouwConsScore & " AND ConstructiefCommentaar = '" & strGebouwConsOmschrijving & "' WHERE ConstructiefID = " &...

Hi guys, If I use an update query in my VBA code (for example, when I click a button), a pop up window is shown to the user. Can you omit showing this pop up window? I don't want to bother my end user with that window. Freek

Hi, I try to input data in table 1 with a form that is based on a join from table 1 and table 2. I do a right join, so if there are no records for the join condition in table 1, null values are created. My idea is to change these null values, so 'real' values exist in table 1. Can anybody...

Hi, I have a problem just executing a select statement. I want the value of a textbox to be determined by a simple select query. I tried to use the Expression Builder but I don't know how to put arguments when using queries in it. For example, you want to select a field 'algemeenid' based on...