Verify entry before save using double entry 1

[katiekat]

I'm entering keycodes for software into a database. We have such a huge volume that when a key gets entered incorrectly, it's a super time consuming job to find the error.

I need to verify the keycode, and the easiest way is to have the person entering the key do it twice.

Here's what I was thinking: Enter the key into the form once, enter the key into a unbound textbox and compare the two. What I'm not sure on is the logistics.

Any ideas where to start?

Thanks all!
Kate

Holy tek-tips batman!:-0

 

[SeeWard]

Hello there,
I had been dealing with a very similiar situation and found this site very useful:

http://www.microsoft-accesssolutions.co.uk/duplicates.htm

.........

 

[SeeWard]

Wrong advice sorry......

 

[TheAceMan1]

How are ya katiekat . . . . .

Do a comaprison in the forms [blue]BeforeUpdate[/blue] Event. If it passes the record is saved. If it fails, saving can be rolled back with the [blue]Cancel[/blue] Property, along with a message, as well as setting the focus. Something like:

[blue]   If Me!Textbox1 <> Me!Textbox2 Then
      MsgBox "Your Message"
      Me!Textbox1.SetFocus
      Cancel = True
   End If[/blue]

See Ya! . . . . . .

 

[katiekat]

Thanks guys! I'm out for the day, but I'll look into it on Monday!

Thanks again for the help!

Holy tek-tips batman!:-0

 

[BaudKarma]

I've handled similar situations in the past. I don't know about the logistics of your situation are, or how the data is set up, but you'll get much better accuracy if you have two different people each enter the data once, then run a query to compare the entries against each other. If a person misreads or miskeys a number once, they're likely to make the same mistake the second time, especially if the first number is fresh in their memory. Also, depending on how long the keys are, some people would be very tempted to just copy and paste to fill in the second field.

I try not to let my ignorance prevent me from offering a strong opinion.

 

[katiekat]

Gracias Ace!! Works like a charm.

Karma, I agree that though two seperate entries would assure accuracy, it would involve a lot more manpower than we have to give it. The copy/paste issue is a good thing to think about as well, I'll caution folks to resist the urge.

Thanks again all for another swift, accurate and kindly put answer to my problem! Having been hiking and riding horses for jobs (or non jobs as the case may be) i've been away from Access for too long, I'm rusty.

Thanks again!

Kate

Holy tek-tips batman!:-0