User Profile

Collapse

Profile Sidebar

Collapse
piper09
piper09
Last Activity: Mar 5 '13, 09:19 AM
Joined: Feb 19 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • piper09
    started a topic How to sort total?

    How to sort total?

    Total
    72
    86
    75
    10
    80

    I wanna sort this numbers from the highest value to lowest and I don't know how to arrange it by using array formula.I will be thankful for the code.

    Thank You....
    See more | Go to post

  • piper09
    started a topic Call Function ?

    Call Function ?

    Code:
    Private Sub I1_Click()
    TotalI = Val(I1) + Val(I2) + Val(I3) + Val(I4)
    WgtI = TotalI / 40 * 30
    T1.Cls
    W1.Cls
    TotalW.Cls
    T1.Print TotalI
    W1.Print WgtI
    TotalWgt = WgtI + WgtII + WgtIII
    TotalW.Print TotalWgt
    End Sub
    
    Private Sub I2_Click()
    TotalI = Val(I1) + Val(I2) + Val(I3) + Val(I4)
    WgtI = TotalI / 40 * 30
    T1.Cls
    W1.Cls
    TotalW.Cls
    T1.Print TotalI
    ...
    See more | Go to post
    Last edited by Meetee; Feb 21 '13, 09:08 AM. Reason: Use code tags [/CODE] around code

  • piper09
    started a topic Round up the wgt ?

    Round up the wgt ?

    TotalII = Val(II1) + Val(II2) + Val(II3) + Val(II4)
    WgtII = TotalII / 40 * 50

    After I total up II1-4

    Then I will be getting the answers in round up number but for wgt II I getting in decimal place ?
    See more | Go to post

  • piper09
    started a topic How to display the year on printer ?

    How to display the year on printer ?

    I got the code for auto year generate on the form but I can't display the year on printed paper ?

    This is the code for display an auto year

    tyy = LTrim(Str(DateP art("yyyy", Date)))
    TCYY.Cls
    TCYY.Print tyy
    tyy = tyy - 1
    tyy = LTrim(tyy)
    TPYY.Cls
    TPYY.Print tyy

    And the code for printer

    Printer.Current X = 70
    Printer.Current Y = 15...
    See more | Go to post

  • How to convert Decimal place to round number ?

    I need to display 26.25 as 26 what is the format i need to use in vb 6.0.
    See more | Go to post

  • I want to auto generate this Year 2011/2012 to 2012/2013....this thing is in a form and it will be reused again...and its done in a commandbox in VB6.
    See more | Go to post

    Leave a comment:


  • How to generate an automatic label Year ?

    I can't manage to find the code for Year as stated above in the title. Can u guyz help me with it. I already attach the image of the file .

    Thank Tou....
    See more | Go to post
No activity results to display
Show More
Working...