no idea how to do this

[ravi_day]

hello everyone

im very confused how i will do this. actually i have to make a vb6 project on payroll and my computer instructor give me a tough problem to solve. i have to make financial year like april 2010 to march 2011 in my vb6 project. once it go to april 2011 then the project automatically make new financial year and save the old financial year so that later the financial year can be retrive and all the employee details must go to new financial year but other details like attendance and other things become zero or something like that so that the project starts from new financial year. also he told me to register daily attendance of all employee in my ms access file. these are two problems which i dont know how to solve because i have never did these kind of problem before. i made tables in my access file to store employee details but dont know how to do financial year or daily addendance. so i need the help on how to do these. any help or idea or suggestion will be greatly appreciated because i will get qualified only after i submit this project.

[Hack]

What does "daily attendence" mean?

If I show up for work and stay for one hour then leave, do I get credit for attending that day?

[ravi_day]

yes its something like that so that when generating slip it show how many days the person came to work and must not register sunday as absent. i thought of few ways to do attandance but the financial year is something i have no idea how it is done in the access file. the only thing i can thought is to make multiple access files but again i will get a another problem of transfering data to new year. so can you please tell me is it possible to transfer employee names, address etc. to a new access file from the old file without changing anything in the project. if possible then tell me what i should do and thank you for replying me always.

[amrita]

Here is just an idea...I don't if it will work out for you.

1. In access have a table called [tblFinance2010].
2.Save all details such as EmpName, Address, Other Details , Attendance and Year .
3. Check when Datetime.Now reaches April 2011 then create another table in Access [tblFinance2011].
4. Insert all values from tblFinance2010 to tblFinance2011, with attendance as 0 and Year as 2011.

[ravi_day]

Here is just an idea...I don't if it will work out for you.

1. In access have a table called [tblFinance2010].
2.Save all details such as EmpName, Address, Other Details , Attendance and Year .
3. Check when Datetime.Now reaches April 2011 then create another table in Access [tblFinance2011].
4. Insert all values from tblFinance2010 to tblFinance2011, with attendance as 0 and Year as 2011.

than you for briliant idea however the problem is there is more tables to move to new table

[Hack]

than you for briliant idea however the problem is there is more tables to move to new table

So? What is the problem with that?

[ravi_day]

the problem is i have multiple tables and i dont know how to move multiple tables to new year because i store employee names, addres etc in 1 table and 2nd table have salary details, 3rd table is how many working days, 4th is to save the percent of tax deduction, 5th is for company details, 6th is designation, department etc. so it making me very confused beside i have no idea how to move table with tax and employee detail to new year cause i am only a beigner so do you think i need to change my tables of i need to change then what changes i need to do in my tables and in my project. please help me

[Hack]

What are your table names?

[ravi_day]

my table names are
1) Attendance
2) Department
3) Designation
4) EmployeeDetail
5) Loan
6) PayTrans10_11
7) SalaryDetails

only PayTrans10_11 and attendance table need to move to new year but the old table rocords must not be gone also. another problem is how i will save daily attendance.

[ravi_day]

What are your table names?

thank u for replying. after reading this forum many times, i manage to solve the problems except 1. now the problem im facing is how i will copy records from one table to another when change the year. what i mean is i have salary records of 2010-2011 but when change to 2011-2012 then i need to copy the employee code and names to new salary table but must not copy the old salary details like gross, net etc of 2010-2011 to the new table 2011-2012. please help me on this last problem. how i can do this using vb6 codes.