Recent content by Zurich98

i still can not get this to work. if i already have a code behind the close button as follow: Private Sub cmdExit_Click() On Error GoTo Err_cmdExit_Click DoCmd.Close Exit_cmdExit_Click: Exit Sub Err_cmdExit_Click: MsgBox Err.Description Resume Exit_cmdExit_Click End...

you are absolutely right. i make a mistake naming the label instead of the check box. i right click on the check box (has green check in the middle) and select properties and change the Name to chkClose. now when i click close button, nothing happen. form not close. what else can i try. thanks

the error is run-time error: '438' : Object doesn't support this property or method. just point to a different line. i just try isnull(me.chkClose) = True then... no error. however, when i click close button, i get this message: Object does not support this property or method. the...

now the error point to If Me.chkClose <> -1 Then

Keith, Thanks for a quick response. i did what you suggested and i receive this message: run-time error: '438' : Object doesn't support this property or metho. i click debug and this line of code is highlighted: me.chkClose=True

I've the following validation code on a data entry form Private Sub CboCommCode_Exit(Cancel As Integer) If IsNull(Me.CboCommCode) Or Me.CboCommCode = "" Then MsgBox "Community is required! Enter community or select from list!" Me.Undo Cancel = True End If End Sub after the user...

I figure it out how to assign the values the user enter in the msgbox. MsgBox " " & strSQLCriteria & " already exists". Thanks for all your helps.

Matt, Thank you very much for your response. It is working great!!! If it is not too much trouble, how can I display the values of the 4 fields that the user enters to tell them that it is already exists? for example: Msgbox = strSQLCriteria & "already exists" of course i try this and it...

I'm using Access 2003 form as front end connecting to sql server 2000 backend via DSN to enter data to one table tblActivity. I need to validate four fields on the form to ensure that the user does not enter duplicate info into tblActivity. the columns are Community, Building, Unit, and Task...