473,325 Members | 2,442 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

DB DESIGN FIELD

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
2 1264
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Zack | last post by:
Hi, I am an access newbie and wanted to get a design check to see if I have done the right thing or if there is a better way. I don't like the Yes/No field option in a table. I want to have the...
3
by: James Armstrong | last post by:
Hi all, (warning - long post ahead) I have been tasked with designing a database for my company which will store trade information (it is a financial firm). It will need to export this info...
3
by: Agnes | last post by:
For my company's vfp application. I need to perform same event in .net 1) E.g the user inputs the companycode, system check the companycode, setfocus to that field if the code is invalid, HOWEVER,...
3
by: Steven | last post by:
Hello All, I am relatively new to database design and wanted to ask a few questions to see if I am on the right track regarding design and normalization. I am creating a user entity which is...
5
by: rdemyan via AccessMonster.com | last post by:
I have a need to add another field to all of my tables (over 150). Not data, but an actual field. Can I code this somehow. So the code presumabley would loop through all the tables, open each...
23
by: JohnH | last post by:
I'm just recently come to work for an auto brokerage firm. My position involves performing mysterious rites, rituals and magick in order to get information out of their access database. This is...
2
by: King Ron | last post by:
Ola all. In responding to a recent post requesting help with a search issue, I recommended using a combo box lookup in the table design. "paii, Ron" (no relation) posted this reply: " There are...
8
by: indrawati.yahya | last post by:
In a recent job interview, the interviewer asked me how I'd design classes for the following problem: let's consider a hypothetical firewall, which filters network packets by either IP address,...
7
by: maya | last post by:
hi, I got this unusual design (well, not so unusual anymore, I guess..) for an input text field for a search form in top of page.. http://www.mayacove.com/design/search/search.html I can't...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.