[AccessD] Double Data Entry Requirement

Jim Hewson JHewson at karta.com
Wed Apr 20 13:22:13 CDT 2005


That might work.
A tabbed form where the first data entry on tab 0 then second data entry on tab 1, compare data then save.
I'm going to try to change their minds before we end up double data entry.
Thanks.
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bobby Heid
Sent: Wednesday, April 20, 2005 1:10 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Double Data Entry Requirement


I favor #1 the most and #3 the least.

I guess a lot of it depends on how it will be entered.  You might consider
an unbound form where the data is entered twice and compare fields before
writing out the data record.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Wednesday, April 20, 2005 1:52 PM
To: AccessD
Subject: [AccessD] Double Data Entry Requirement


Has anyone done this before?

I am working on a proposal and one criteria is to "provide for the entry
of... data twice to ensure accuracy."
I thought of three methods of doing this.
1. Create a table for the second data entry and then compare the record with
the first table.  Delete the record(s) of the second table when they match.
2.  Use an unbound form for the second data entry and compare the results
with the table to ensure they match then delete the data. 
3.  Recommend the second person print the record and compare the documents
without doing a double data entry.  Suggesting it would take less time and
therefore save money.  There is the issue of paper, printing, etc.....

Thoughts!

Thanks,

Jim


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list