48
I have frmMain that takes in data about a particular event. Payroll information needs to be automatically calculated from this, but is stored in a different table. So, I included a subform frmPay, to remain hidden (as the user shouldn't be able to access it directly).
When the user puts in the length of time into frmMain, I can round it to the nearest 15 minutes just fine for frmPay. Now, when I want to multiply those hours by their hourly rate, I have two problems:
1) converting time into a multipliable number. I'm currently using this (keep in mind it's accessing a subform):
myTime (as double) = Hour(Me![frmPay].Form.[TotalHours]) + (Minute(Me![Payroll subform].Form.[TotalHours]) / 60)
This works, but I'm wondering if there's an easier way I'm missing.
2) The *rate* value that I need to multiply it by is stored in a completely different table, related by employee. I have no clue how to access the rate in tblEmployee given the employeeID in frmPay with VBA. I know I can just make another subofrm linked by employee that contains the rate, but this seems *really* wrong. Advice?
Also, I'm using the BeforeUpdate event to do the data transfer between frmMain and frmPay and for calculations. If anyone has any advice as to how to make this more efficient, and especially how to address #2 above, please let me know.
As always, I am greatly appreciative of everyone putting in time here to help others.
