InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 11:27:22 GMT20http://www.sqlservercentral.com/Forums/Topic501120-145-1.aspxYou need to go find an MS Access forum for this type of question. This has nothing to do with SQL Server.I think your DCount function is wrong.I think it should be:DCount("[EMP_CODE]", "[ATT_IMPMST]", "[att_emp_code] = [EMP_CODE] and [att_date] = #02/05/2008#")You would also be better off using a "SELECT COUNT([EMP_CODE])" T-SQL statement. I think DCount creates a cursor and loops through it.Thu, 15 May 2008 06:02:20 GMTMichael Earl-395764http://www.sqlservercentral.com/Forums/Topic501120-145-1.aspxDear all Gurus / MastersI do have another problem as followsI am trying to loop in the record set of one table, my code is as followsThe following code is on a click event of a push button on a form-- code starts hereDim Conn As ADODB.ConnectionSet Conn = New ADODB.ConnectionConn.Provider = "Microsoft.jet.OLEDB 4.0"Conn.Open "C:\Study\STUDY_PAYROLL.mdb"Dim MyTableRs As ADODB.RecordsetSet MyTableRs = ADODB.RecordsetMyTableRs.Open "COM_EMPMST", Conn, adOpenDynamic, adLockPessimisticMyTableRs.MoveFirstDo Until MyTableRs.EOF mychk = DCount("[EMP_CODE]", [ATT_IMPMST], "[att_emp_code] = [EMP_CODE] and [att_date] = #02/05/2008#") If mychk = 0 Then MsgBox ("Employee Not Found in Attendance") Else MsgBox ("Employee found in attendance") End IfLoopMyTableRs.CloseSet MyTableRs.ActiveConnection = NothingConn.CloseSet Conn = Nothing-- code endsNow, when I run this code I am getting error "Method or Data Member Not Found" Please help me, I don't know why I am getting this errorb rgdssunil joshiThu, 15 May 2008 03:15:18 GMTsunnyjoshibombay