Search results

Dear all, i have the following codes: enter_date = Format(txt_date, "dd/mm/yyyy") Set db = CurrentDb() Set rs = db.OpenRecordset("select * from [entered_date] where Date = # " & enter_date & " # ") If Not rs.RecordCount = 0 Then DoCmd.Beep Msgbox "Selected Date's report already been created"...