G
Guest
I want to create a form that will show only incomplete records. Once the
record is complete, I'd like it to disappear from view. Any suggestions?
record is complete, I'd like it to disappear from view. Any suggestions?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Larry Linson
Larissa25 said:I want to create a form that will show only incomplete records. Once the
record is complete, I'd like it to disappear from view. Any suggestions?
Not Null in the criteria of every Field in the Query you use as Record
Source for the Report should do it, if having a value in every Field is what
you want. If not, please clarify
Larry Linson
Microsoft Access MVP
G
Guest
I work in a hospital and we have an informal patient database with records
that are completed over the course of the patient's hospital stay (e.g.
"hospital discharge date" will be null until the patient discharges). Right
now, this data is in Excel. People who have strong points other than data
entry are putting the data into this table, and most of the records are left
blank. When a patient discharges from the hospital, the record for the
patient is moved from the Active sheet (usually shows no more than 10
patients) to a Discharged sheet (many, many records of former patients).
We're trying to make the database better and we want to eliminate blank
fields. I need to create a form that will just show the active patients (and
there is a column that is only filled out once the patient is finished, so if
this field is null then the patient is still "Active"). I can't create a
table with every field required, because the data isn't filled out all at
once, but day-by-day.
I think I need to list every column as "Not required" and leave the "Allow
Zero Length" as Yes. If I create a query where I show any records that have
blank fields in certain columns, then create a form based off of that, I
should still be able to add new records while still showing the other
"Active" patients. And all the data will still be kept in a master table.
I'm going to try that and see if I can work out the bugs that pop up, too.
Thanks for your response. I guess I just had to ruminate on it for a while.
-Larissa
that are completed over the course of the patient's hospital stay (e.g.
"hospital discharge date" will be null until the patient discharges). Right
now, this data is in Excel. People who have strong points other than data
entry are putting the data into this table, and most of the records are left
blank. When a patient discharges from the hospital, the record for the
patient is moved from the Active sheet (usually shows no more than 10
patients) to a Discharged sheet (many, many records of former patients).
We're trying to make the database better and we want to eliminate blank
fields. I need to create a form that will just show the active patients (and
there is a column that is only filled out once the patient is finished, so if
this field is null then the patient is still "Active"). I can't create a
table with every field required, because the data isn't filled out all at
once, but day-by-day.
I think I need to list every column as "Not required" and leave the "Allow
Zero Length" as Yes. If I create a query where I show any records that have
blank fields in certain columns, then create a form based off of that, I
should still be able to add new records while still showing the other
"Active" patients. And all the data will still be kept in a master table.
I'm going to try that and see if I can work out the bugs that pop up, too.
Thanks for your response. I guess I just had to ruminate on it for a while.
-Larissa
J
John Vinson
I want to create a form that will show only incomplete records. Once the
record is complete, I'd like it to disappear from view. Any suggestions?
What constitutes a record being "complete"? No NULL fields, or what?
You could base the Form on a Query with criteria to select only
incomplete records, frex by putting
IS NOT NULL
on the Criteria line under each field, using a new criteria line for
each so it uses OR logic.
John W. Vinson[MVP]