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