If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Making Check Boxes
I am using the Student form for (obviously) a list for students. I had to add
check boxes through the design view, but when I click on the check boxes for each contact, it clicks it for ALL of the students. How do I make the check boxes check for each individual contact without it checking all of them? Thanks. |
#2
|
|||
|
|||
Making Check Boxes
The checkbox needs to be bound to a field in the table so the record will
store the information. -- KARL DEWEY Build a little - Test a little "Jami B." wrote: I am using the Student form for (obviously) a list for students. I had to add check boxes through the design view, but when I click on the check boxes for each contact, it clicks it for ALL of the students. How do I make the check boxes check for each individual contact without it checking all of them? Thanks. |
#3
|
|||
|
|||
Making Check Boxes
How do I go about binding the field to the record? Is it in properties?
"KARL DEWEY" wrote: The checkbox needs to be bound to a field in the table so the record will store the information. -- KARL DEWEY Build a little - Test a little "Jami B." wrote: I am using the Student form for (obviously) a list for students. I had to add check boxes through the design view, but when I click on the check boxes for each contact, it clicks it for ALL of the students. How do I make the check boxes check for each individual contact without it checking all of them? Thanks. |
#4
|
|||
|
|||
Making Check Boxes
On Wed, 1 Oct 2008 07:24:00 -0700, Jami B. Jami
wrote: I am using the Student form for (obviously) a list for students. I had to add check boxes through the design view, but when I click on the check boxes for each contact, it clicks it for ALL of the students. How do I make the check boxes check for each individual contact without it checking all of them? Thanks. STOP. It sounds like you're starting with the Form. That's like assembling a house's windowframes before you've poured the foundation! Data is NOT stored in forms, but only in Tables. What is the structure of your tables? What table field is the checkbox bound to? If it's not bound to a table field then it's not stored anywhere and not related to any student. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Making Check Boxes
First read John W. Vinson's response.
I assume your form uses a query to pull records from your table. Open the form in design view. Right click the form and select Properties. Click on the checkbox and then click in the Control Source property to select your field. -- KARL DEWEY Build a little - Test a little "Jami B." wrote: How do I go about binding the field to the record? Is it in properties? "KARL DEWEY" wrote: The checkbox needs to be bound to a field in the table so the record will store the information. -- KARL DEWEY Build a little - Test a little "Jami B." wrote: I am using the Student form for (obviously) a list for students. I had to add check boxes through the design view, but when I click on the check boxes for each contact, it clicks it for ALL of the students. How do I make the check boxes check for each individual contact without it checking all of them? Thanks. |
#6
|
|||
|
|||
Making Check Boxes
Unfortunately, I do not know how to bind any fields to any particular
contact, and it would be too much to ask for a detailed "how-to" but is there a quick way to explain how to bind the information so my check boxes work properly? I am somewhat new to creating new forms and tables with Access, so forgive me if I seem naive on the Access lingo. Thanks so much for your time! "John W. Vinson" wrote: On Wed, 1 Oct 2008 07:24:00 -0700, Jami B. Jami wrote: I am using the Student form for (obviously) a list for students. I had to add check boxes through the design view, but when I click on the check boxes for each contact, it clicks it for ALL of the students. How do I make the check boxes check for each individual contact without it checking all of them? Thanks. STOP. It sounds like you're starting with the Form. That's like assembling a house's windowframes before you've poured the foundation! Data is NOT stored in forms, but only in Tables. What is the structure of your tables? What table field is the checkbox bound to? If it's not bound to a table field then it's not stored anywhere and not related to any student. -- John W. Vinson [MVP] |
#7
|
|||
|
|||
Making Check Boxes
Access 2007 may be different, but I could not find the Control Source option.
Any other suggestions? "KARL DEWEY" wrote: First read John W. Vinson's response. I assume your form uses a query to pull records from your table. Open the form in design view. Right click the form and select Properties. Click on the checkbox and then click in the Control Source property to select your field. -- KARL DEWEY Build a little - Test a little "Jami B." wrote: How do I go about binding the field to the record? Is it in properties? "KARL DEWEY" wrote: The checkbox needs to be bound to a field in the table so the record will store the information. -- KARL DEWEY Build a little - Test a little "Jami B." wrote: I am using the Student form for (obviously) a list for students. I had to add check boxes through the design view, but when I click on the check boxes for each contact, it clicks it for ALL of the students. How do I make the check boxes check for each individual contact without it checking all of them? Thanks. |
#8
|
|||
|
|||
Making Check Boxes
Hello Jami B.
If you will forgive the directness which is an attempt to be helpful. The foundation of everything that Access does is storage of information in tables. Everything else is just an "interface" to the tables. It sounds like you do not understand this or possibly that you do not even understand what tables are. You're going to have to start by learning that before you will be able to do any design work with Access. Sincerely, Fred |
#9
|
|||
|
|||
Making Check Boxes
Ok- thank you. I will start with the basics. And thank you for your honesty-
I may have jumped the gun with something I do not quite understand. Thanks again. "Fred" wrote: Hello Jami B. If you will forgive the directness which is an attempt to be helpful. The foundation of everything that Access does is storage of information in tables. Everything else is just an "interface" to the tables. It sounds like you do not understand this or possibly that you do not even understand what tables are. You're going to have to start by learning that before you will be able to do any design work with Access. Sincerely, Fred |
#10
|
|||
|
|||
Making Check Boxes
On Wed, 1 Oct 2008 13:04:01 -0700, Jami B.
wrote: Unfortunately, I do not know how to bind any fields to any particular contact, and it would be too much to ask for a detailed "how-to" but is there a quick way to explain how to bind the information so my check boxes work properly? I am somewhat new to creating new forms and tables with Access, so forgive me if I seem naive on the Access lingo. Thanks so much for your time! Again: *Start with the Tables*. Don't even OPEN the forms window until you have tables with all of the fields needed to store the information that you want to record. This would include a Yes/No field in the appropriate table (which I can't really identify based on what you've posted). Once you have your tables set up, with all the needed fields and relationships, *then* create your Form. You might want to look at some of the tutorials and sample databases available: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|