Recent content by wolfwrz

I have a command button that I want to display a warning before it functions. I want it to pop up a are you sure warning. then proccess only if the yes/ok is pressed or exit function if cancel/no is pressed. Thanks in advance

Thanks

Solved My own problem but got new one.... I need to know how to clear multiple check boxes from the same table with one button.. IE similar proceedure but multiple check boxes

Here is the code that I am trying to run via a button press.... Dim dbs As Database Dim sql As String Set dbs = CurrentDb sql = "Update Master set EKG REQUIRED = 0" dbs.Execute (sql) Master is the Table EKG REQIRED is the Check Box. I am still getting the Syntax Error in...

Fixed that problem now I am getting a sytax error from my lines sql = "Update Master set IMMUNIZATION(S) = 0" dbs.Execute [sql] Master is the table and imm is the checkbox Thanks

I am getting a User defined type not defined error also. It hangs on the first line. Thanks

Check Boxes Wayne Thanks.... This will clear the entire table right... What if the form when opened filters the table to a subset and I want to just clear the subset... Thanks in advance

Help please... I have a form that pulls records out of a table... It is a repeated form. I want to clear all the checkboxes of a certain type IE the following command. ME.Checkbox.Value = "no" This command works but only for the selected record on the form. I cant clear all the checkboxes of...