Search results

I can't find what is wrong in the following code: DoCmd.RunSQL "UPDATE Table1" & _ "SET Table1.Checkbox1 = False" & _ "WHERE Table1.Checkbox1 = True;" Can anyone help me out? Thank you.

Thank you for your help. Before I try it out: are you aware of a more efficient way to do what I am trying to do? (I'm quite new to Access and VBA)

The checkbox is indeed bound to the table. The form is not a continuous form. What kind of query should I use? Or how els can I solve the problem. I'm puzzled here.

Hi, I have a form based on a query. On the query is a button to print a report. Since a user may not want to print all records, I have added a checkbox on the form. The default value of the checkbox is false. The report filters on the checkbox being true. All is fine, when the user marks...

Thank you. That did it for me!

Hi, I have the following problem. I've made a form with a textbox Keywords. To ensure the integrity of my data, I have made a listbox with keywords. The form with the textbox keywords has a button. When the button is pressed, a small form pops up with the listbox with keywords. What I...