Recent content by Andyleone

  1. A

    get button name on 5 differ form

    ..Thank guy for advise, i just modified the vba code.. by assign the value to case "" it fixed.
  2. A

    get button name on 5 differ form

    Hello everyone, pardon me, if i make some mistake, because i still on learning curve. anyway.. after searching on multiple forum i still had no answer how to get xform value because it on 5 differ forms. so what i was looking for is a way to get the button name when button find on 5 different...
  3. A

    question How to manipulating textbox control source

    Hello, i would like some advice/suggestion I have 1 cbobox and 1 text box and table named as client with field named as job first name as cbojob cbocox value list is job1, job2, job3, other if "other" selected in cbojob then the user had to type the job name in jobtxt. there is some...
  4. A

    Compare between 2 age value

    Got it worked just re edit code and corrected data type in the field and it work..
  5. A

    Compare between 2 age value

    If Me.TxtAgeFrom2 > "" Then varWhere = varWhere & "[Age] >= " & tmp & Me.TxtAgeFrom2 & tmp & " AND " End If If Me.TxtAgeTo2 > "" Then varWhere = varWhere & "[Age] <= " & tmp & Me.TxtAgeTo2 & tmp & " AND " End If For this field it was number..
  6. A

    Compare between 2 age value

    Private Function BuildFilter() As Variant Dim varWhere As Variant Dim tmp As String tmp = """" varWhere = Null If Me.TxtGender2 > "" Then varWhere = varWhere & "[Gender] like " & tmp & Me.TxtGender2 & tmp & " AND " End If If Me.TxtICD2 >...
  7. A

    Hi hello user from Singapore

    hi im andy new to the the access. most of my work are excel based. origin from singapore but now reside at malaysia. work as clerck. Still new to access. Any Advice is welcomed.
See more
Top Bottom