Multiple Checkbox Options

[Cuteako]

Hi To all,

I'm new here in bytes, I would like to ask for your help on the database the i'm working on. Here are some details

Name: ________                       Covered Date:__________
#    Process   Mon Tue Wed Thur  Fri    Remarks    Description  
1       A      Chekboxes      txtbox
2       B      Chekboxes      txtbox
3       C      Chekboxes      txtbox
4       D      Chekboxes      txtbox
5       E      Chekboxes      txtbox
6       F      Chekboxes      txtbox
7       G      Chekboxes      txtbox

That needs to compute/total the number of checkbox ticked for each process for covered period inputted (weekly basis).
I'm having problem in connecting the checkbox to the tables in access and the codes that will compute the checkboxes.

I will appreciate all the help that I can get.....
Thanks!!!
Skiedg

[NeoPa]

You don't give much detail of your problem and it's not clear what you're having trouble with. Can you clarify the question.

[Cuteako]

My problem is first how to connect multiple checkbox in a table.
How to sum the checkbox that are ticked for the covered period given.
The description of the form is there are task to be completed weekly mon-fri.
then the user will tick the task that she/he have done.

Fields:

a.Employee ID
b.dates covered.
c.checkbox
d.remarks

Thank you very much for your assistance....

[NeoPa]

My problem is first how to connect multiple checkbox in a table.

Each CheckBox is bound to a different (Yes/No) field within the table.

How to sum the checkbox that are ticked for the covered period given.

What defines the period? All fields in a single record? A particular Yes/No (CheckBox) field across all, or even a specified range of, records?

NB. After reading your explanation (which comes after this question) it is clear they should be multiple Yes/No fields in the record. This isn't reflected in your record layout though.

The description of the form is there are task to be completed weekly mon-fri.
then the user will tick the task that she/he have done.

Fields:

a.Employee ID
b.dates covered.
c.checkbox
d.remarks

Ah, some explanation at last, but how can a single CheckBox (c) cover Monday to Friday?

[Cuteako]

-What defines the period? The user will input the covered period. For example
Start Date: 11/3/2008
End Date:11/7/2008

-Each task will have 5 checkboxes to reflect the monday to friday task.

-I did try to connect the checkboxes to the table using yes/no in the properties ''Control Source" however after connecting the checkbox becomes disable.

Thank you again......

[NeoPa]

-What defines the period? The user will input the covered period. For example
Start Date: 11/3/2008
End Date:11/7/2008

I'm thinking more of how it is defined within the form.

-Each task will have 5 checkboxes to reflect the monday to friday task.

This seems contradictory to the statement made in post #3 (quoted in my previous post). This needs to be clarified.
Is it one or the other? It's important (critical) to know this.

-I did try to connect the checkboxes to the table using yes/no in the properties ''Control Source" however after connecting the checkbox becomes disable.

Connecting is done by setting the Control Source property of each CheckBox item to the (or one of the - depending on the actual design) name of the boolean (Yes/No) field in the table.

[Cuteako]

A.I'm thinking more of how it is defined within the form.
- Textbox for Start Date
- Textbox for End Date
This is is for the covered period.
B. This seems contradictory to the statement made in post #3 (quoted in my previous post). This needs to be clarified.
Is it one or the other? It's important (critical) to know this.
- Sorry but I forgot to indicate that each task has multiple checkboxes
-5 to be exact for each task.
C.Connecting is done by setting the Control Source property of each CheckBox item to the (or one of the - depending on the actual design) name of the boolean (Yes/No) field in the table.
-Yes I did create a table with Yes/No field in the table and did try to connect it but the checkbox become unable.

Thank you for your patience and understanding.

[missinglinq]

I've deleted your latest, duplicate thread on this problem. This note will bump this thread back up to the top of the queue. In the future, please don't post duplicate threads. If, after a reasonable time, your problem hasn't been solved, or appears to not be attracting attention, add a note yourself. This will bring it back to the top of the queue, and all of the previous questions/answers will be part of it. Simply reposting your question, as you did, gives no one the benefit of NeoPa's questions or your replies.

Linq ;0)>

Moderator

[Cuteako]

Hi Everyone,

I really need help on this project; I will give more details so you could understand it more.

The database if for task monitoring (weekly). Employees will log every last day of the week to record what task have they done for the week.

Name: Start Date:
Employee ID: End Date:

Task Mon Tue Wed Thur Fri
1 < > < > < > < > < >
2 < > < > < > < > < >
3 < > < > < > < > < >
4 < > < > < > < > < >
5 < > < > < > < > < >

< > = checkbox
I created 3 tables already;
1st is for list of task
2nd is for task completed where in I used yes/no for Mon-Fri.
3rd is for list of employees with their employee ID’s

I already connect the first row of checkbox in the table of task completed however when I try to check the 2nd row of the task the value of the 1st row defaulted and when I try to change it it doesn’t work how do I go about it

And also I need to sum the checkboxes according to task, employee and by dates also.

I hope someone can help me with my office project.
I will really appreciate any help that you could give.

Thank you so much in advance.

[NeoPa]

I'm sorry I've been a little tied up during the last week and haven't had time to look at this problem. I hope to find time shortly to give this some more attention. Thank you for your patience.