Guest User

Untitled

a guest
Jul 17th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. Option Compare Database
  2. Function MyVal(lnIn As Long)
  3. If Len(Me.entry) > 1 Then
  4. Me.entry = Replace(Me.entry, ".", "") & lnIn
  5. 'Me.entry = Left(Me.entry, Len(Me.entry)) & "." & Right(Me.entry)
  6. Else
  7. Me.entry = Me.entry & lnIn
  8. End If
  9. End Function
  10. Private Sub calc_Click()
  11. Me.Balance = Me.Balance - (-(Me.entry))
  12. Me.entry = ""
  13. End Sub
  14. Private Sub clear_Click()
  15. Me.entry = ""
  16. End Sub
  17.  
  18. Private Sub Command16_Click()
  19. Dim MyBalance As Currency
  20. MyBalance = Me.Balance
  21. DoCmd.Close
  22. Forms!frmHours.Form.SetFocus
  23. Forms!frmHours.Form.Balance = MyBalance
  24. End Sub
  25.  
  26. Private Sub Form_Open(Cancel As Integer)
  27. Me.Balance = OpenArgs
  28. End Sub
Add Comment
Please, Sign In to add comment