Search results

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.

can you make changes in my sample and reshare it. since i tried and it still not working.

Dear all, Thanks For helping at first. i am trying to update List box based on selection of Combo box. i am using below code for updating in AFTER UPDATE of combobox. UG added Code Tags ..... Option Compare Database Private Sub Combo14_AfterUpdate() Dim ListFilter As String...

Hello Pat, I am new to access. I have to update record based on Employee Code. like vlookup in excel. currently i have the update query which is working. but i need that query should look up on form for input and then run. your advice will help if i am going wrong anywhere.

yes the Field names are same. i did some what like this. please guide me on VBA part. UPDATE EmployeeDetails INNER JOIN Sheet1 ON EmployeeDetails.CODE = Sheet1.CODE SET; in me.combobox do i have to write lable name.

Ok, can this help, if yes, let me know to use it, Do you want to use VBA? Something like: CurrentDb.Execute "UPDATE EmployeeDetails Set [" & Me.combobox & "] = '" & Me.textbox & "'"