Recent content by batowiise

Hi, I have installed ClickYes to automate the clicking of yes for me. However, it does not stop. How do i stop it when it gets to the end of the file? This is the code: Function SendMyEmail() Dim MySet As ADODB.Recordset Set MySet = New ADODB.Recordset MySet.Open "qryEmailAddress"...

Hi, I did try outputting the report in pdf format but it was not possible. I would like the body of email to pick the name of the employee and the salary month. This is what i am trying to implement: Dear <EMPLOYEE NAME> Please find attached herewith your salary advice for <SALARY MONTH>...

Thanks, it did work. Can i have the report send in pdf formart?

I will do as much as possible to refrain from double posting. Now am implementing similar thing. But this time the user will select the employee and i expect the email field should be populated automatically. I have started by placing two unbound text boxes on a form. I have been able to do...

That was great, it worked like magic.

I have two unbound text fields namely txtStartDate and txtEndDate on a form. I want to verify that txtEndDate is not less (earlier) than txtStartDate and when this condition is met, a message pops up notifying the user. I have tried using the following code but am not getting the desired...

Hi Everyone, I have two unbound text fields namely txtStartDate and txtEndDate on a form. I want to verify that txtEndDate is not less (earlier) than txtStartDate and when this condition is met, a message pops up notifying the user. I have tried using the following code but am not getting the...

Hi Everyone, I have two unbound text fields namely txtStartDate and txtEndDate on a form. I want to verify that txtEndDate is not less (earlier) than txtStartDate and when this condition is met, a message pops up notifying the user. I have tried using the following code but am not getting the...

Thanks soo soo much, every thing is now OK. You guys are very great keep it up.

I will be very grateful if you could implement that for me since you have the FILE. I am i little bit confuse. Thanks

I changed the DoCmd.SendObject to rather refer to a Query instead of a Report and put in a criteria that is [Forms]![Form1].[qIndexNumber]. It is now working perfectly. The date range keeps coming up after every loop. I want it to come one. Thanks

Its already FALSE

Thanks very much, that was what i was fighting with. I however have some error. I did enter two emails for the first two employees. As usual, it starts by prompting with the DATE RANGE that is from the PaySlips Report. After filling in the date range another dialog/window pop-up for me to click...

Please find the attached file Thanks

I have watched the video and it looks similar to what i wanted to implement. I however encounter error when i try debugging. This is the code: Function SendMyEmail() 'Declare variables Dim MySet As ADODB.Recordset Set MySet = New ADODB.Recordset MySet.Open "qryEmailAddress"...