twychopen22
Registered User.
- Local time
- Today, 12:49
- Joined
- Jul 31, 2006
- Messages
- 101
This I think is going to be difficult. I have a tutorial that I am trying to figure out on how to do this but it is basic. It can be seen here http://www.fontstuff.com/access/acctut08.htm
Anyways, I have a form that I want to use for employee pay. 1. I want to select (from dropdown) the employee position (employeeInfotbl).
2.This brings up the employee names (employeeInfotbl) that hold this position. (from dropdown) and the employee is selected from here.
3. This then shows if that employee is on Wage or Salary (employeeInfotbl). If it is wage then 2 boxes come up, one with their hrly $ and one for how many hours they worked. Depending on which one he/she is on, the final amount will be added to an expense report I have as Fixed Exp. or Variable Exp.
4. Next I have date range txt boxes with calendars to choose the time the payment covers.
5. Next dropdown boxes with employee Metrics (their performance records) (employeemetricperformancetbl) for that time period show up and can be selected. Along with this is a text box for the "goal" to be set. i.e. if the boss says reach 10, that number goes in this text box. The Metric is selected and the form automatically sees if it is < or > 10. If it is, then an amount is added to their hourly wage.
6. After all this is filled in, another date box comes up so the payment amount can be put in the expense records for that date.
Anyways, I don't really have an idea of how to do this. I know I need to build the comboboxes w/o the wizard, and there needs to be queries behind each one. I just don't knwo how to get it to work with different tables. I am sure more explanation is needed so just ask if there is confusion.
Thanks all!
Anyways, I have a form that I want to use for employee pay. 1. I want to select (from dropdown) the employee position (employeeInfotbl).
2.This brings up the employee names (employeeInfotbl) that hold this position. (from dropdown) and the employee is selected from here.
3. This then shows if that employee is on Wage or Salary (employeeInfotbl). If it is wage then 2 boxes come up, one with their hrly $ and one for how many hours they worked. Depending on which one he/she is on, the final amount will be added to an expense report I have as Fixed Exp. or Variable Exp.
4. Next I have date range txt boxes with calendars to choose the time the payment covers.
5. Next dropdown boxes with employee Metrics (their performance records) (employeemetricperformancetbl) for that time period show up and can be selected. Along with this is a text box for the "goal" to be set. i.e. if the boss says reach 10, that number goes in this text box. The Metric is selected and the form automatically sees if it is < or > 10. If it is, then an amount is added to their hourly wage.
6. After all this is filled in, another date box comes up so the payment amount can be put in the expense records for that date.
Anyways, I don't really have an idea of how to do this. I know I need to build the comboboxes w/o the wizard, and there needs to be queries behind each one. I just don't knwo how to get it to work with different tables. I am sure more explanation is needed so just ask if there is confusion.
Thanks all!
