Double Data Entry

[rfrancis via AccessMonster.com]

I need help with a database, which will permit double data entry. The Access
database will have s about 8 to 10 tables . At first ,one person enters data
in the database, followed by another person, who will enter the same data. If
there is any data error, or miss-match between the first entry and the second,
the program must flash a warning, to rectify the errors.

 

[tina]

well, if you only want to end up with one set of correct and verified data,
then you could have the first user enter data that will be stored in the
table. the second user would have to choose the record that s/he intends to
"double-enter" (in a form), so the system knows what to check. then the
second user could enter the data into unbound controls on the form; you
would use code to compare the data field by field and point out unequal
values, and allow the user to choose whether or not to overwrite the
existing data with the new data for that field.

hth

 

[rfrancis via AccessMonster.com]

Thank you very much. I shall post again and ask your help if I dont succeed.
Appreciate your help.

Rfrancis

 

[tina]

you're welcome, good luck!

Thank you very much. I shall post again and ask your help if I dont succeed.
Appreciate your help.

Rfrancis