data entry: preventing certain decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The database I am developing contains working hours and the hours are always
rounded up or down to the nearest quarter.

What I need is a message which alerts the user when they enter anything
other than X.25hrs, X.5hrs, X.75hrs or X.00hrs (where X is any other number).

Based on the knowledge I have I guess I would use the "after update" event.

thanks in advance.
 
The After Update event is too late. Use the Before Update event so you can
cancel the update if the entry is incorrect.

If (Me.txtHours - Int(Me.txtHour))*100 mod 25 <> 0 Then
"Must be .00, .26, .5, or .75"
Cancel = True
End If
 
just what I needed.

Cheers


Klatuu said:
The After Update event is too late. Use the Before Update event so you can
cancel the update if the entry is incorrect.

If (Me.txtHours - Int(Me.txtHour))*100 mod 25 <> 0 Then
"Must be .00, .26, .5, or .75"
Cancel = True
End If
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to write a formula to round up and/or down 1
Adding up time in decimal value 2
how do i operate on the decimal portion of a number 3
Progressive Calculations 2
Round time to nearest 15 minutes in decimal format 4
add data in column related to cell in another column - see full de 1
Rounding to the nearest quarter (decimal) in a Pivot table 3
Controlling Decimal Precision at Time of Data Entry? 3

Back
Top