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
|
|||
|
|||
100 YES/NO fields
I want to design a table to store data on labtest aquisitions, to
print out labels later. It will be a list with 100 different tests, every test with its own checkbox which you can select. Is it possible to store only the "Yes" values and discard the "NO's ? |
#2
|
|||
|
|||
100 YES/NO fields
If your table is properly normalized, you could save only the Yes values
(records). Can you change your table structure so that each text score becomes a record rather than a field? tblAquisitionHeader ============== AquID autonumber primary key AquDate Date of AquOtherFields other fields tblAquisitionDetails ============== AqDID autonumber primary key AquID link to tblAquisitionHeader.AquID AquTestID what was the test (formerly a field name) AquResult Yes/No (apparently you don't need to store records with "no" values) -- Duane Hookom MS Access MVP -- "TonyTOCA" wrote in message m... I want to design a table to store data on labtest aquisitions, to print out labels later. It will be a list with 100 different tests, every test with its own checkbox which you can select. Is it possible to store only the "Yes" values and discard the "NO's ? |
#3
|
|||
|
|||
100 YES/NO fields
Thx Duane, that's what i had in mind and i 've tried it, but the
problem was: how do i get all the 100 test visible on a form if each text score is a record? "Duane Hookom" wrote in message ... If your table is properly normalized, you could save only the Yes values (records). Can you change your table structure so that each text score becomes a record rather than a field? tblAquisitionHeader ============== AquID autonumber primary key AquDate Date of AquOtherFields other fields tblAquisitionDetails ============== AqDID autonumber primary key AquID link to tblAquisitionHeader.AquID AquTestID what was the test (formerly a field name) AquResult Yes/No (apparently you don't need to store records with "no" values) -- Duane Hookom MS Access MVP |
#4
|
|||
|
|||
100 YES/NO fields
You could use a continuous form that the user could scroll up and down. If
that doesn't work then you can use an unbound form with 100 check boxes. Your code can load the values from a record and save the values to a record. I try to never let a form's desired appearance drive my table structure decisions. -- Duane Hookom MS Access MVP "TonyTOCA" wrote in message m... Thx Duane, that's what i had in mind and i 've tried it, but the problem was: how do i get all the 100 test visible on a form if each text score is a record? "Duane Hookom" wrote in message ... If your table is properly normalized, you could save only the Yes values (records). Can you change your table structure so that each text score becomes a record rather than a field? tblAquisitionHeader ============== AquID autonumber primary key AquDate Date of AquOtherFields other fields tblAquisitionDetails ============== AqDID autonumber primary key AquID link to tblAquisitionHeader.AquID AquTestID what was the test (formerly a field name) AquResult Yes/No (apparently you don't need to store records with "no" values) -- Duane Hookom MS Access MVP |
#5
|
|||
|
|||
100 YES/NO fields
Okay...an unbound form....but that means i have to put code behind
every checkbox? Or not. "Duane Hookom" wrote in message ... You could use a continuous form that the user could scroll up and down. If that doesn't work then you can use an unbound form with 100 check boxes. Your code can load the values from a record and save the values to a record. I try to never let a form's desired appearance drive my table structure decisions. -- Duane Hookom MS Access MVP "TonyTOCA" wrote in message m... Thx Duane, that's what i had in mind and i 've tried it, but the problem was: how do i get all the 100 test visible on a form if each text score is a record? "Duane Hookom" wrote in message ... If your table is properly normalized, you could save only the Yes values (records). Can you change your table structure so that each text score becomes a record rather than a field? tblAquisitionHeader ============== AquID autonumber primary key AquDate Date of AquOtherFields other fields tblAquisitionDetails ============== AqDID autonumber primary key AquID link to tblAquisitionHeader.AquID AquTestID what was the test (formerly a field name) AquResult Yes/No (apparently you don't need to store records with "no" values) -- Duane Hookom MS Access MVP |
#6
|
|||
|
|||
100 YES/NO fields
Not really. You use a decent naming convention and possibly set the tag
property of each check box and then have your code loop through the controls on the form and update your table. -- Duane Hookom MS Access MVP "TonyTOCA" wrote in message om... Okay...an unbound form....but that means i have to put code behind every checkbox? Or not. "Duane Hookom" wrote in message ... You could use a continuous form that the user could scroll up and down. If that doesn't work then you can use an unbound form with 100 check boxes. Your code can load the values from a record and save the values to a record. I try to never let a form's desired appearance drive my table structure decisions. -- Duane Hookom MS Access MVP "TonyTOCA" wrote in message m... Thx Duane, that's what i had in mind and i 've tried it, but the problem was: how do i get all the 100 test visible on a form if each text score is a record? "Duane Hookom" wrote in message ... If your table is properly normalized, you could save only the Yes values (records). Can you change your table structure so that each text score becomes a record rather than a field? tblAquisitionHeader ============== AquID autonumber primary key AquDate Date of AquOtherFields other fields tblAquisitionDetails ============== AqDID autonumber primary key AquID link to tblAquisitionHeader.AquID AquTestID what was the test (formerly a field name) AquResult Yes/No (apparently you don't need to store records with "no" values) -- Duane Hookom MS Access MVP |
#7
|
|||
|
|||
100 YES/NO fields
Well, i'm no VBA-wizard but i'll give it a try and check out
formscoding for some pointers. Got some reading to do....I'll get back to you when i have the code..Many thx "Duane Hookom" wrote in message ... Not really. You use a decent naming convention and possibly set the tag property of each check box and then have your code loop through the controls on the form and update your table. -- Duane Hookom MS Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"UNION" Query with different fields in the two tables | Dkline | Running & Setting Up Queries | 5 | July 30th, 2004 09:05 PM |
Resetting Yes/No fields | John Lawrence | Running & Setting Up Queries | 1 | June 5th, 2004 07:56 PM |
Lost text fields in merge | CGiannini | General Discussion | 5 | June 4th, 2004 10:23 PM |
Lookup fields on label report | Howard | Setting Up & Running Reports | 1 | June 3rd, 2004 02:43 AM |
Yes/No boxes in forms | Stephen Glynn | New Users | 14 | May 30th, 2004 07:25 PM |