Search results

Thank you so very much... I am greatful to you dear friend.... I called you friend coz who stays in hard time is a friend... I am working on it.... My office is close for today... Tomorrow I will write more for development of all forum members... I like this forum very much... It gives me a...

Please have a look Thank you so very much... Calendar table is a new way to add records in my database. I need to design my database to print reports in the format of attached image. will you give a look and let me know how I can manipulate the calendar table to get the report? Thanks and...

Thanks .... Thank you so very much... I will be waiting for your suggession. Best regards. Arif Masum

The Clear Point Thanks a lot for your reply.. I am too sorry for your inconvenience... First, I have attendance data in tblEmpAttendance, by that I can view any employee's attendance record. For holidys tblEmpHoliday contains holiday information. In tblEmpLeave there is record for employee...

Thanks the main point I want to update leave and holiday record in attendance records. Then I want to print the monthly attendance summery. I can do the monthly summery, i wonder how I will add the leave and holidays in attendance. Thanks a lot for your answer and time.....

Hope everybody is fine in this forum. I need help to print Attendance report for each employee. In my attachment there are three tables. tblEmpAttendance Contails Attendance Records, tblEmpHoliday contains holiday Records and tblEmpLeave contains leave records. I need to print monthly...

Waiting to see your success.... Dear Jeff, Thank you very much for your reply. It is much inspiring. I am also developing HRMS for a group of companyies. We have time card machine (which gives text data). I am manipulating that data to get reports. Please let me know about you design...

How can I show each date of month in attendance report. I have two different tables for attendance and holiday. I need to show leave on that report too... pls help. Thanks in advance for time and reply. Arif Masum

More help needed... Thanks for your kind reply. I can join tables. My problem is I want to declare leave only one time and need to allocate thaty specific leave for every employee, how can i do that? Thanks again for your time and reply. Arif Masum

Yes, I need to denote public holidays, then I need to allocate leave for employees. I need to complete the task soon. So many need (lol), but you dont worry. Please help me with some ideas. thanks a lot....

Sorry I forgot to say I have made that attendance table in date and time format. I am able to calculate work time regularly. Hope to hear from you soon. thanks

More questions Yes, the tblAttendance table is created by importing card reader machine data ( fixed length ). It contains both InTime and OutTime for each day. I need to insert Holidays like 04/13/2007 (according to the test data attached) is a holiday in my country Bangladesh. In the...

Dear Readers, Please help me. I am stuck here. I need to get holiday, and leave in employee attendance report. But I can not understand how i can do it. I am attaching employeedate database. Please help me. Thanks with best regards. Arif Masum

How to add leave and holiday Thank you very much for your reply. But I wonder how should I insert the holiday and leave information. My attendance data is pulled from Time attendance card reader machine. So, we don't get any data for holiday and leave from machine. can you please guide me...

I am working with employee attendance database. My problem is I can show only work days in report. But I need to show Holiday and leave information in that report. I have another table for leave information. I wonder how i will allocate holiday for every employee and then show it in each...

Dear All, I am designing a new database for Human Resource. In attendance table I can import and calculate attendance for employee. My problem is I can not understand how I will allocate leaves and Holidays ?... Can anybody give me advice regarding this issue? Any advice will be appriciated...

Well, Thanks a lot guys for your valuable advices. I got your point. It is more logical to import than link. Now I need to know, can i run the query or SQL code without being asked to be sure to delete? Is it possible, how? Thanks in advance for your valuable comments. Arif Masum

Dear all, I am stuck here. I want to delete the blank records from the linked table. Then I want to use that table. But I can not understand how I can delete blank rows from table? Is it possible? When I link table, i get blank rows between every row. Please find the text file attached. If...

Thanks a lot Linq. You made it so easily. I understood. Best regards. Arif Masum

Dear Experts, A am stuck here. I want to show leave report of Every Employee of a department in reports. I need "All" as combo box criteria, but can not understand how I can do it. Will anybody help me out of this issue? Thanks in advance. Arif Masum