Search results

Thanks a ton. I got the error, i was uning monthname function instead of month.

No, Getting error as "Data Type Mismatch in criteria Expression" Both YR and MN is being extraxted from Date Field

No, Getting error as "Data Type Mismatch in criteria Expression" Both YR and MN is being extraxted from Date Field

I want to count the no of records in QPENSIONER_NEW TBL WHERE YR IS YEAR AND MN IN NAME OF MONTH BUT I AM GETTING ERROR Me.TXTCASE.value = DCount("REC_ID", "QPENSIONER_NEW", "YR = Forms!SERVICE_FORM!CYEAR " And MN = Forms!SERVICE_FORM!CMONTH)

I am using a command button and in the click event i have the followind code: DoCmd.SetWarnings False DoCmd.OpenQuery "QUPDATE_ELR" DoCmd.SetWarnings True QUPDATE_ELR is the query SQL is UPDATE MEMBERS SET MEMBERS.EL = [EL]-[FORMS]![LEAVE_UPDATE]![TXTNOD] WHERE...

My qudate query is not running showing error : key violation. Although when i tries to run the query directly is doesnot show any error and it is updating the records. But when i am trying to run it from the form, due to LOCK violation table not updated. my SQL is UPDATE MEMBERS SET...

[Forms]![EMPLOYEE_LEAVE_MASTER]![TXTFROM] and [Forms]!...![TXTTO] are date type and TXTAC is a numeric.

Hi Sir/Madam I am usimg the forlloing SQL, but the records are not updating. UPDATE MEMBERS SET MEMBERS.EL = [EL]+(DateDiff("d",[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTFROM],[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTTO])+1) WHERE ((([FORMS]![EMPLOYEE_LEAVE_MASTER]![TXLV])="EL") AND...

Hello Sir/Madam Is there any method to check if the same value is already taken in the Data base. I mean suppose a person have taken leave from 12-09-23 to 25-09-23. (two Date fields). If some body tries to enter the value for leave from 13-09-23 to 14-09-23 for the same person, it should flash...

Yes, I want to append the records from the value in the form, if there are three records it is adding three times , why?please guide me

INSERT INTO CREDIT_MASTER ( LEAVE_TYPE, CREDIT_DT ) SELECT [FORMS]![LEAVE_CREDIT]![TEL] AS Expr1, [FORMS]![LEAVE_CREDIT]![TDT] AS Expr2 FROM CREDIT_MASTER;

I need you help in another situation. I am having two fileds of leave sanction i.e. From and To, I want to put a validation check, while applying any othrr leave, to see if the Period is is inbetween the leave already sanctioned. how can I resolve this issue.

I have use the Me! refrence and it works fine

Thanks its working now....

If TXTLV.value = "CML" And txtfrom.value >= TXTDSAN.value Then MsgBox "Commuted Leave can't be presanctioned, Please check!!!!", vbOKOnly + vbCritical, "Hello !! Information incomplete" Me.TXTDSAN.SetFocus Exit Sub End If is there any mistake in code, any value i am putting it flases the...

i HAVE ALREDAY SENT THE FILE IN YOU MAIL THANKS

the code is not working , even no error is there, records gets updated with duplicate date?- Please Help anyone Dim NewDt As Date Dim stLinkCriteria As String NewDt = Me.txtfrom.value stLinkCriteria = "[FROM] = " & NewID If Me.txtfrom = DLookup("[FROM]", "[REPORT_LEAVE]", stLinkCriteria) Then...

i have two date field DT1 and DT2 which may lies in two different months

Yes i have done the tblcalendar, now how to use the SQL

Hi Sir/madam I want to get the no of days for each Month between two dates , for eg From 23-Sep-23 to 03-Oct-23. Result I want month wise i.e. Sept -8 Days Oct-3 days (Both days are inclusive) is there any method , in query Can any body help