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????? 2 1267
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.
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**********@v erizon.net> wrote in message
news:8a******** *************** ***@posting.goo gle.com... 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????? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
actual Yes or No data in a text box. To accomplish this, I created a
new table with one field. There are just two records in the table,
Yes and...
|
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 into an excel file while converting some of the data
into an export format (example - we use B for buy, the firm we export
to uses BY). Eventually,...
|
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, user can press
'Unsave' button to cancel this invoice or press 'upper arrow' to pass away
that field.
Question, in .net if i set .focus .the cursor...
|
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 made up of 4 tables:
User(UserID(PK), EmpID, CountryID, PostCodeID)
Employee(EmployeeID(PK), EmployeeType)
|
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 table in design mode and then add the new field and set its
properties.
Thanks.
--
| |
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 due to
the fact that the "designer" they hired had an unfortunate ability to
tink around with a program far beyond her reach. She had no concept
of...
|
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 many posts in this group explaining the pitfalls of using
the
lookup feature in tables. Best practice appears to be, keep the
lookup in
the forms...
|
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, port
number, or both. How should we design the classes to represent these
filters?
My answer was:
class FilterRule
{
|
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 get it to work, have tried lots of things.. have spent lots of
time already on it... tried to glean from apple.com, where they have
same kind of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |