Recent content by joshirohany

Thanks for the reply. But can someone help in designing. Since i dont know VBA. Also how to send in bulk?

Hello Experts, I have a database where i am suppose to email individual payslip to employee around 900 a month . But challenge is, can we do it without ms outlook. I want Access should directly use SMTP and send email without using outlook. I have folder where all payslip are...

Sure LarryE....

Hello LarryE, Have you been able to convert your Sheet1 imported table information into an ACCESS relational design? I do it manually Is anyone allowed to enter data into your application that has NOT been imported from an EXCEL file? I import logs manually How are you selecting "weeks" to...

Yes. Super thanks to all.

Team, Sorry was out of town so, couldn't reply. Its just one employee as sample, there are many employee. a. I can see First in and Last out of the employee. b. The Sheet 1, which is created was more of horizontal since there are many employee and different months attendance to...

Ok, that works, but how to this value in Form, since there are many employees.

Dear Experts, I have a log from Biometric Attendance Machine. The same are imported in Access. I want the form should consider only First In and Last Out and Difference in hours based on date. Your help is already appreciated.

Its exactly what is required. Thanks sir and all once again.

Hello MajP, I downloaded your demo. Its showing below details.

Firstly thanks to all of you. All i am trying, is to generate In/Out time for employees. I have attached the excel sheet that i am currently using. Need the same in Access.

I am able to generate Random in number(integer) but not in date. i am using Int ((200 - 150 + 1) * Rnd + 150)

Dear Experts, I am trying to generate Random time between two time range format hh:mm:ss. i am able to do in excel can you guide how it can be done in Ms Access. Thanks and your help is appreciated.

where am i going wrong?

yes i deleted and recreated still no luck.