Results 1 to 2 of 2
  1. #1
    U5113499 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2014
    Posts
    2

    plus three value in textbox

    i wanna plus three value in textbox and when the amount is over 100, system will pop up message box telling exceeding amount


    Public Sub ADD_Click()
    If ([CHK_PER] + [LCL_EFT_PER] + [INTL_EFT1_PER] + [INTL_EFT2_PER] > 100) Then


    MsgBox "You over percentage for this allocation"
    End If
    End Sub


    Please help

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    Move the paren BEFORE the 100...
    If ([CHK_PER] + [LCL_EFT_PER] + [INTL_EFT1_PER] + [INTL_EFT2_PER]) > 100 Then

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 04-30-2015, 01:50 AM
  2. Replies: 2
    Last Post: 01-08-2014, 05:18 PM
  3. Replies: 2
    Last Post: 04-20-2013, 03:37 AM
  4. Replies: 8
    Last Post: 04-12-2013, 08:59 PM
  5. Replies: 17
    Last Post: 02-08-2012, 10:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums