Update Employees Payroll Data
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Update Employees Payroll Data
Here is a screenshot of the tables used doing this. The payroll data is entered on the employees form and using 3 other subforms for payroll data.
The payroll data is looked up on the payroll data entry form when a employee is selected to write a payroll check.
Any suggestions?
Temporarily Shelved Until I Calculate some code.
Thanks,
You do not have the required permissions to view the files attached to this post.
Last edited by burrina on 01 Feb 2017, 22:56, edited 1 time in total.
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Update Employees Payroll Data
It's not clear to me what is being updated to what. Can you provide more specific information?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: Update Employees Payroll Data
On my Employees form is where the Payroll data is entered for each employee. Their PayRate,Single/Married Status,Number of Allowances taken.
This needs to be updated every year with the latest data entered. For instance a employees pay rate may have been 10hr in 2015 but 11hr in 2016 as wells their single/married status and their number of allowances taken.
This needs to be updated every year with the latest data entered. For instance a employees pay rate may have been 10hr in 2015 but 11hr in 2016 as wells their single/married status and their number of allowances taken.
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Update Employees Payroll Data
Do you want to update tblEmployees with the most recent values in TPayRate, TNoAllow and TSinMar?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: Update Employees Payroll Data
No. That's the thing, there is no single table that needs to be updated. Instead 3 tables need to be updated for each employee.
TPayRate
TNoAllow
TSinMar
All 3 tables above need to be updated for each employees payroll data. New record for each employee with the latest data.
1 main form, 3 subforms.
frmEmployees
FNoAllowSub
FPayRateSub
FSinMarSub
TPayRate
TNoAllow
TSinMar
All 3 tables above need to be updated for each employees payroll data. New record for each employee with the latest data.
1 main form, 3 subforms.
frmEmployees
FNoAllowSub
FPayRateSub
FSinMarSub
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Update Employees Payroll Data
Are these subforms bound to the corresponding tables (i.e. FNoAllowSub to TNoAllow etc.)?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: Update Employees Payroll Data
YES. Via EmployeeID and EmpID
Master/Child
Master/Child
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Update Employees Payroll Data
I'd say you don't need an append query. Simply create a new record in each of the subforms. The new records will automatically be saved in the underlying tables.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: Update Employees Payroll Data
No. I need the old/latest data to be put into a new record (Subforms) for each employee if it is January 1 of the current year and if they have not been already entered.
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Update Employees Payroll Data
Do you mean that you want to duplicate the most recent record for each employee?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: Update Employees Payroll Data
The EffDate of course needs to be updated to the latest date for TPayRate table and then the latest data from the other 2 tables added to the other tables with the latest data. Sorry for my bad explanations.
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Update Employees Payroll Data
I don't see the point. For example, if the pay rate changes, you add a new record. You would do that in the pay rate subform, and it would automatically be added to TPayRate. If it doesn't change compared to last year, there is no need to add a new record - the most recent pay rate will still be valid.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: Update Employees Payroll Data
BUT, it is more complex than that. Those forms are linked to the tax tables. Anyway, it would take a long time to do this if there were very many employees.
Hence the automation needed. I realize this may not make a whole lot of sense without going into the nuts and bolts of the db. It is VERY complex.
Thanks,
It is best to helve this for now until I can think more about this.
Thanks so much for the help.
Hence the automation needed. I realize this may not make a whole lot of sense without going into the nuts and bolts of the db. It is VERY complex.
Thanks,
It is best to helve this for now until I can think more about this.
Thanks so much for the help.
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Update Employees Payroll Data
The subforms are NOT linked to TNoAllow, TPayRate and TSinMar? I'm lost...
Best wishes,
Hans
Hans