Creating a database to track work hours. Questions.

[Tesseract]

Good day,



I have been using Excel to keep a daily track of when people are in to work, but the number of persons employed has increased and it is taking too much time to manually input data into the sheet.
I am looking at Access and I would like to know if what I want is possible.

The fields I would need are , Name , Date , Time worked(1 for a full day and 0.5 for a half) , Reason worked, and funded by(inside/outside organization)

Question:

I'm going to describe what I would like, and can you tell me if it's possible.

I would like to make a template of form that has the following options.

1. The ability to select a date (possibly through a calendar selection)
2. Select one or multiple different persons from a list
3. Possibly two check boxes (full/half day) - that when selected input a 1 or 0.5 into the database
4. A text entry for reason worked.
5. Another check box for inside/outside funding that reflects the time worked in step 3 and that can be queried to see how many total days funding was given.

Would this be possible, please if you need something clarified let me know.

Thank you

[apr pillai]

A Sample Form image is attached, with a Calendar Control and with two Combo Boxes for full/half day and inside/outside options.

The Calendar control can be inserted from the ActiveX Controls Button and you need a one line VBA program to insert the selected date into the Date Field: say myDate. Sample Code is given below:

Private Sub Calendar1_Click()
  Me![myDate] = Me.Calendar1.Value


End Sub

You cannot use Check Boxes for full/half day or inside/outside cases because the returned values from checkboxes are TRUE/FALSE (-1/0). Combo Boxes can be set with required values.

For details on Multiselection of Listbox items search the term MULTISELECT in Access Help.

[Tesseract]

Thank you for the information. I will give it a shot.