Hello,
I am an extremely new to using Access, and have very limited knowledge, so any help is greatly appreciated!
I am trying to create a form that will allow the individuals in our department to enter their time in 30 minute increments, based on specific project numbers that they select (these come from a seperate table). I've set the form up so that the user can select their name from a combo box and and then enter the current date into a text box. Then I would like several combo boxes (10 or so) going down that will allow a user to select a specific project number and seperate boxes tied to each of the combo boxes where they will record the number of hours spent on each project that they selecy.
So if an individual spend 4 hours on project 123, 2 hours on project 456, and 2 hours on project 789, I would like for three seperate records to be created in a table that shows name, date, project, and hours.
I have no idea where to start. The only thing I can figure out is to have a form with only one project box and one hours box, and have the user fill out and clear the form for each individual project. I know there's got to be a way to do it all at once though.
Another thing, I have never used any sort of code in Access, so if that's what I need to do, could you please dumb it down as much as possible? I wouldn't even know where to go to enter the code! Thank you again for any help, I really appreciate it!