Human Resources (hr) Database
Thank you for taking the time to report an issue.
What's wrong... Please write below.
What I would like to happen, is to have a button to clock in, clock out, break in/out and lunch. When the button is clicked I would like to have the text box below the button display the date and time and time.
Eventually i would like a form where it has the activity listed in the top half and the resources listed in the bottom half and some buttons where you would click on them to add the resource to the activity. This would then calculate the cost of the all the resources for each activity.
There are 3 areas to this:
I want the Unit Prices to be formulated in a form, with a sub-form to show the build-up of resources in the unit price...
If the user selected 3 resources for this visit, the code will add to the table 3 records where the id, date and term are the same and what changes in each row would be the resources.
So later the user has the option of updating the resources for this visit, so the code is supposed to find a match in the id, date and term and then update the resource id in the table by replacing it with the one now being selected.
Where I am stuck is: the table might have more resources already than the ones I am selecting now, so the extra rows have to be deleted. Or the table might have less rows than the ones I am selecting now, in this case we would have to add a row with the corresponding info.
While playing with the code I noticed if I take out the "AND" in the bold line above. The error is removed within Access 2010; however, it creates the same error in Access 2007, 2003. We still have a couple users that utilize Access 2007 and need it to function properly in both instances.
This is a program that I have inherited and my programming skills are minimal at best.
I have worked on this for several hours already, or 2007; however, not in both.
First: The form will record the users name, E-mail address, and the User type (Human Resources, Security, etc.)
Second: It also takes the current date and the current time and inputs them into two seperate text boxes.
My question is this, How do I take the information garnered from the Date and Time boxes and, when I push a button, the two are saved to a different Table for recording those specific things.
All previous information, name/e-mail are to be saved to a user table seperatly.