S
shriil
I have this Data Entry Form which consists of a Name Field and a
Logical Yes/No Field for the Data Entry Operator to fill in. The
Data-entry Form populates a table which has the Name field and the
'Yes/No' field. As per the existing mode of data entry, the table
may have some records where the 'Yes/No' field remains selected as
'No' owing to overlooking on part of the Data-entry person. Now I
then have a final Make-Table query which has a criteria to select those
records from the original table whose 'Yes/No' field is set as
'Yes'. From here, the problem starts, as the records with 'No'
in the 'Yes/No' field, is absent in the final table. That is why I
feel that the Data entry form needs those modifications such that the
'Yes/No' field is not inadvertently missed out during data entry.
You can say that I can always set the default value of 'Yes/No'
field as 'Yes', which would then eliminate the problem. I have
deliberately kept the default value as 'No' for forcing the Data
entry operator to make it 'Yes' when he enters the name in the
'Name' field... Just to make him aware of the seriousness and the
reliability of the data which he is entering.
For this reason, if I can ensure that the Operator will have to ensure
that all the 'Yes/No' fields have been properly selected before
closing the 'Data Entry form', my mission will be accomplished. For
this, I was thinking of going about it as detailed below:
The moment the user tries to close the form, a query will run on the
data already entered by the user, to search for any record where the
'Yes/No' field has not been made 'Yes'. Accordingly if the query
returns zero records, a pop up message will inform the operator that "
Data entry Successful' and subsequently will close the form.
If the query returns any record, the pop up message will indicate that
"Some records have their Yes/No field unchanged at 'No' " and
accordingly will display those respective records. The closing of the
form will remain inhibited unless and untill the operator corrects
those particular records.
Please enlighten me on how to arrive at the above solution. Thks
Logical Yes/No Field for the Data Entry Operator to fill in. The
Data-entry Form populates a table which has the Name field and the
'Yes/No' field. As per the existing mode of data entry, the table
may have some records where the 'Yes/No' field remains selected as
'No' owing to overlooking on part of the Data-entry person. Now I
then have a final Make-Table query which has a criteria to select those
records from the original table whose 'Yes/No' field is set as
'Yes'. From here, the problem starts, as the records with 'No'
in the 'Yes/No' field, is absent in the final table. That is why I
feel that the Data entry form needs those modifications such that the
'Yes/No' field is not inadvertently missed out during data entry.
You can say that I can always set the default value of 'Yes/No'
field as 'Yes', which would then eliminate the problem. I have
deliberately kept the default value as 'No' for forcing the Data
entry operator to make it 'Yes' when he enters the name in the
'Name' field... Just to make him aware of the seriousness and the
reliability of the data which he is entering.
For this reason, if I can ensure that the Operator will have to ensure
that all the 'Yes/No' fields have been properly selected before
closing the 'Data Entry form', my mission will be accomplished. For
this, I was thinking of going about it as detailed below:
The moment the user tries to close the form, a query will run on the
data already entered by the user, to search for any record where the
'Yes/No' field has not been made 'Yes'. Accordingly if the query
returns zero records, a pop up message will inform the operator that "
Data entry Successful' and subsequently will close the form.
If the query returns any record, the pop up message will indicate that
"Some records have their Yes/No field unchanged at 'No' " and
accordingly will display those respective records. The closing of the
form will remain inhibited unless and untill the operator corrects
those particular records.
Please enlighten me on how to arrive at the above solution. Thks