Search results

Respected, I have a table name (fee) which have the following fields: it will only send one message and not send other messges which dues is unpaid...please advised. Fields Of table: GR No: 1, 2,3,4,5,6,7 Name: Aslam,Naveed,Wasif,Altaf etc Date, Month, Year, TutFee, Exam, Comp, Other, Payable...

Please see the attached file.

i have made some changes in that code: please reviewfor example: 30 students fess is unpaid. so after date 10 the message send to all parents whose students fees is unpaid:Private Sub Form_Open(Cancel As Integer)Dim Ins As IntegerOn Error GoTo ErrorHandlerDoCmd.SetWarnings FalseDim StrSQl As...

Respected,I have a table name (fee) which have the following fields:it will only send one message and not send other messges which dues is unpaid...please advised. -----------------------------------------------------------------------GR No: 1, 2,3,4,5,6,7Name: Aslam,Naveed,Wasif,Altaf etcDate...

i will see it would be nice..thx in advane. i will put this code into my database and advised you. Bundles Of Thanks. It works................ regards

Step-1: On Form Load Event Control [Code],Intime,Otime,Dated will be empty. Step-2: When User Put Code in control e.g. 8. it will shows its picture, intime, dated. Otime will be null. Step-3: When user again put the same above code (e.g. 8) in control. it will check its intime,dated(current...

i placed Option Explicit on top of module. now it records only intime and do nothing (not record otime).please check wether the event ocde is correct or not. For code i compare when intime is saved in table with code and next time code will eneter it will compare in the table to find the code...

Here is the code.Please check its event wether is correct or not???? -------------------------------------------------------------- Option Compare Database Dim abc As String Dim p As String Dim aa As String Dim strSQl As String -----------------------------------------------------------------...

i have made some changes which you mention in reply. but in and out time is occur at the same time.When i put a code in "code" textbox it fills the "Me.intime" and "Me.otime" same time.please view at the attached file. i only want the event procedure will check the code in database wether this...

I want to record emp in and out time. i have attached the form with this query. The structure of table is: Code Text Intime Date/Time Otime Date/Time Dated Date ----------------------------------------------------- When i put code (e.g 1569) in code field it will track only intime nd when i put...