Search results

thanks.. i try the code you gave me its working but is possible to add new record after the automatic insert of today's date. what im trying to do is i have a previous record with salary start and salary end.. and i want to add new record but insert first the todays date in the previous record...

Help.. I just want to ask how to add code in a form that will automatically finds the open record and insert today's date? Thanks hope someone can help me..

thanks.. how can i ask this in forms forum? can you teach me how to code this?

hi again.. thank you very much i already got the logic on how to make a salary history.. i just want to ask regarding the salary end is it possible to make this automatic when i add new record and put the salary start the value will goto to the salary end of the previous salary.. so that I...

i attach the sample database i follow what you said i have two table the tblemployee and tblsalaries.. i still dont understand on how to make a salary history sorry because im newbie in ms access.. can u make me an example based on the sample i attached.. thanks again..

attach is the sample database what im doing the problem is in the update salary. for example i want to update the current salary because the employee got his increment but the problem is when i edit the salary it will update easily but the old salary will gone.. and i want a history for that to...

i need to make an update of the current salary and store the old salary to the table so that i can check when was the last increment and effective date of each employee and display the updated salary to the main employee salary table.. thanks

thanks po the reply... ok i will make another table for that how about the relationship salary table to salary history. and do i need to make a query? sori im stuck to this situation i dont know what to do..

Hi everyone.. just want to ask on how to make a history like for example i have a table of salary of all the employee.. i just want to know how to update the salary of each employee but store the old salary for tracking purposes.. do i need to make a separate table for the old record? thanks in...

thanks you for the reply.. i found and code and modify a little bit.. it will generate a one workbook with many sheet but the problem is it will show only 1 record for each worksheet.. but i have many records in the field with equal of the tenderproject field.. and also the code makes infinite...

Hi everyone just want to ask if anybody know how to export ms access table into excel workbook with separate sheet based on a value of field? For Example: I have One Table with three fields Name Address Company Steve a Apple John b Apple Josh c Dell Pete d Dell Pat e HP Jacob f HP Output...