Search results for query: *

This is the macro that I converted to VB. I only pasted 3 recipients...13 was way to much to post. Anyway, It basically opens and sends the 1st recipient. But, after that it only opens and closes the rest. Function EmailSupervisorsSAVE() DoCmd.RunMacro...

I am trying to email a report to different recipients. The report has different data according to the recipient. I've created a macro to open the report and in the "where condition" I put in the criteria. Which all works. After it opens, the next step in the macro is to Sendobject...

I appreciate your help! I can't believe that I've been chasing my tail. When you gave the last thread...I'd already had that... I was thinking that I had to manipulate the table to get a true hour calculation... After your last thread I went back to the original table, ran the original...

Thank you for your help... I did forget to state what I wanted as an end result, sorry~ What I need is the In and Out for one day to be on one row. If the employee has one in and one out I need to calculate the total time for each in and out. In at 8a.m. Out at 12p.m. Will be 4 hrs. total...

Here goes~ I am trying to build a table containing EmpNo Name TimeIn TimeOut TimeStamp Date The employee clocks in, a record is created and has a timestamp. The employee clocks out, a record is created and has a timestamp. They can clock in and out several times during the day. The main...