Search results

Sir can you please have a look on my attached file, Please...Thank you...

Sir I changed the control name to txtRemarks because the control source is Remarks also, i increased then the Timer to 5000 still ddint work and no message box too. Private Sub Form_Timer() If Me.toberenew = "To Be Renew" Then MsgBox "" Select Case Me.txtRemarks.Visible...

Sir Thanks for the reply. Is the textControlName is the name of the text box field where the result which is "To Be Renew" return? If that then "Remarks" i used.But it is not working sir. Private Sub Form_Timer() If Me.toberenew = "To Be Renew" Then Select Case Me.Remarks.Visible...

Sir as i did researching again i got already the answer on my previous question. What i want next is to have a label blinking. "To Be Renew" is label i want to blink. I changed previous "Expired" to "To Be Renew" Private Sub Form_Timer() Me!ToBeRenew.Visible = Not (ToBeRenew.Visible) End Sub...

As i having hard time finding to put in a new thread, i post it here sir. I want again help from you sir. I have a Table Which have 5 Columns. Table Name- Personnel Details Fields- txtName, txtPosition, StartDate, ExpiryDate and Warning "Warning" field will return the result "Expired" if True...

Good day... I got it. Thanks for advice and the link. It really helps me...

Good day, In my form i have 1 field name "Date Entry" which set to datatype DATE/TIME. Format: Medium Date (as ex. 02-Feb-12) I have also "quick search button" that working fine but the only problem i have if i search according by months there is no value return. I do have on my database...