Enter critical data twice in forms

  • Thread starter Thread starter Ladi
  • Start date Start date
L

Ladi

Hi guys,

I'm wondering to know how can we make it possible to enter critical data
twice in datafields in form (i.e: Invoice date, Invoice number)?

This would help to prevent entering of data by mistake.

Thanks,
Ladi
 
A well designed table structure eliminates the need for duplicating anything
but the key in the related table. In the case of an Invoice number, using a
bound subform linked on that number (as the key) will automatically add it
for new records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Ladi,

Most data-entry people I know would happily cook your intestines in white
wine sauce if you made them duplicate fields on a regular basis. It
undermines their confidence, and doubles the data-entry process, which is
counter productive.

Instead, why not check the invoice number another way, by relating it to an
order or something...

DubboPete
 
Dear Arvin

What I'm trying to say is: wether we can force the user on the propriate
event to enter twice date and number for the invoice becouse this way we
make sure that he has entered the correct data. If not the app will notify
him by telling that the values of the first round and the second round
didn't match. It's not a matter of dublicates.

Sceanario A: First Round
No: 11
Date: 12/22/2005

Second Round
No: 11
Date: 12/22/2005

On scenario A, Every thing ok!

Sceanario B: First Round
No: 11
Date: 12/22/2005

Second Round
No: 12
Date: 12/22/2005

On scenario B, the program should prompt for mismatch of values beetween
first and second round! (For the same record)

Thanks a lot
Ladi
 
Ladi,
This is "basically" what you'll need. Please adjust to suit....

I'd hide the Second round until First round had both values entered.
If Not IsNull(Round1No) or Not IsNull(Round1Date) Then
Round2No.Visible = True
Round2Date.Visible = True
Else
Round2No.Visible = False
Round2Date.Visible = False
End If

Both the First and Second fields can be unbound, and update bound fields
if they pass.

If Round2No = Round1No And Round2Date = Round1Date Then
[TheRealNoField] = Round2No
[TheRealDateField] = Round2Date
' message here... You Passed
Else
' message here.... You Failed
End If
hth
Al Camp
 
Dear Al

Thanks for your advise.

Ladi

Al Camp said:
Ladi,
This is "basically" what you'll need. Please adjust to suit....

I'd hide the Second round until First round had both values entered.
If Not IsNull(Round1No) or Not IsNull(Round1Date) Then
Round2No.Visible = True
Round2Date.Visible = True
Else
Round2No.Visible = False
Round2Date.Visible = False
End If

Both the First and Second fields can be unbound, and update bound fields
if they pass.

If Round2No = Round1No And Round2Date = Round1Date Then
[TheRealNoField] = Round2No
[TheRealDateField] = Round2Date
' message here... You Passed
Else
' message here.... You Failed
End If
hth
Al Camp

Ladi said:
Dear Arvin

What I'm trying to say is: wether we can force the user on the propriate
event to enter twice date and number for the invoice becouse this way we
make sure that he has entered the correct data. If not the app will
notify him by telling that the values of the first round and the second
round didn't match. It's not a matter of dublicates.

Sceanario A: First Round
No: 11
Date: 12/22/2005

Second Round
No: 11
Date: 12/22/2005

On scenario A, Every thing ok!

Sceanario B: First Round
No: 11
Date: 12/22/2005

Second Round
No: 12
Date: 12/22/2005

On scenario B, the program should prompt for mismatch of values beetween
first and second round! (For the same record)

Thanks a lot
Ladi
Click to expand...
Click to expand...
 
Back
Top