By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,824 Members | 2,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,824 IT Pros & Developers. It's quick & easy.

DB DESIGN FIELD

P: n/a
I created a db using access xp. THe way I did it is by following the
contack management wizard to the point I could create my customized
design. Well, I did it and after I clicked the View button to the
design view I deleted some fields I did not need. And then I tried to
create a check mark field where I can keep track of students courses
they have taken. For example, Math, Social Studies, etc. and next
to the course I isnerted the check mark wich is located in the Toolbar
Options. Well, I changed back to From view and tried the db. I
clicked the check mark it it worked! However, when I created another
record, the check mark was already checked!!!!! and if I unmarked the
check mark, it appears unmarked in every record!!!!

PLEASE I will appreciate you help, how can I fix this prroblem?????
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ismael wrote:
I created a db using access xp. THe way I did it is by following the
contack management wizard to the point I could create my customized
design. Well, I did it and after I clicked the View button to the
design view I deleted some fields I did not need. And then I tried to
create a check mark field where I can keep track of students courses
they have taken. For example, Math, Social Studies, etc. and next
to the course I isnerted the check mark wich is located in the Toolbar
Options. Well, I changed back to From view and tried the db. I
clicked the check mark it it worked! However, when I created another
record, the check mark was already checked!!!!! and if I unmarked the
check mark, it appears unmarked in every record!!!!

PLEASE I will appreciate you help, how can I fix this prroblem?????


Is the Checkmark, Yes/No, a field in the table upon which the form is
bound to? If not (as I suspect), open up the table the form is bound to
and add a Yes/No field to the table.
Nov 13 '05 #2

P: n/a
It sounds as though you have put an unbound control on your form. First add
a new field (boolean) to your table, then select that field in the field
list and drag it onto your form while in design mode. Then you'll have a
checkbox with every record.

HTH Linda

"Ismael" <is**********@verizon.net> wrote in message
news:8a**************************@posting.google.c om...
I created a db using access xp. THe way I did it is by following the
contack management wizard to the point I could create my customized
design. Well, I did it and after I clicked the View button to the
design view I deleted some fields I did not need. And then I tried to
create a check mark field where I can keep track of students courses
they have taken. For example, Math, Social Studies, etc. and next
to the course I isnerted the check mark wich is located in the Toolbar
Options. Well, I changed back to From view and tried the db. I
clicked the check mark it it worked! However, when I created another
record, the check mark was already checked!!!!! and if I unmarked the
check mark, it appears unmarked in every record!!!!

PLEASE I will appreciate you help, how can I fix this prroblem?????

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.