Second enter data in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'd like to have my data entered twice by two separate people to ensure
accuracy. Is there an easy way to do this sort of double entry in Access?

Thanks,
-JJ
 
Hello,

I'd like to have my data entered twice by two separate people to ensure
accuracy. Is there an easy way to do this sort of double entry in Access?

Thanks,
-JJ
Click to expand...

Not easy, but possible: you'ld have two forms. The first form would
enter data into a "scratchpad" table; the second form would use the
BeforeUpdate event of each form control to compare the data being
entered with the data in the scratch table. If they match, write it to
the production table; if they don't, bonk the user.

In practice, with a well designed system (making copious use of
limit-to-list combo boxes or listboxes, field validation, etc.) such
double data entry is often unnecessary. It doesn't catch all the
errors (two clerks can misread the bad handwriting in the same way),
takes WELL more than double the time (counting the time spent
resolving discrepancies), and leads to frustration for the data entry
people. Your call though.

John W. Vinson[MVP]
 
Thanks John! This is a big help!

John Vinson said:
Not easy, but possible: you'ld have two forms. The first form would
enter data into a "scratchpad" table; the second form would use the
BeforeUpdate event of each form control to compare the data being
entered with the data in the scratch table. If they match, write it to
the production table; if they don't, bonk the user.

In practice, with a well designed system (making copious use of
limit-to-list combo boxes or listboxes, field validation, etc.) such
double data entry is often unnecessary. It doesn't catch all the
errors (two clerks can misread the bad handwriting in the same way),
takes WELL more than double the time (counting the time spent
resolving discrepancies), and leads to frustration for the data entry
people. Your call though.

John W. Vinson[MVP]
Click to expand...
 
Hello JJ

Were you able to solve your problem with John's suggestion. If so, is it
possible for you to show me with an example(codewise) as to how you did it. I
am very new to access programming and I have been struggling to do this, but
in vain.
Your help will be really appreciated.
Thanks
bhl
 
Back
Top