Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Weilon Sung

  1. Weilon Sung

    XIRR in VBA Access

    a question at least. How can i start the query under a macro, my macro tells me he doesn`t know the VBA-macro?
  2. Weilon Sung

    XIRR in VBA Access

    Hey guys, IT WORKS, after I summate the values single day before the code starts. Then I just have per day one value and the ordering works now. Thank u for your Inputs. Data Inputs:
  3. Weilon Sung

    XIRR in VBA Access

    Hi I am on work today. @Combo: Thats what makes matter I think. The first Payment for XIRR must be negative, therefore the code doesn`t work with the automatic. But how comes the Code changes position of my table value?? I just use the pick up method from MajP as like: Do While Not rs.EOF...
  4. Weilon Sung

    XIRR in VBA Access

    Hi Combo, I don't know why, but it works with this date Format. I grap the immediate window for the variables which works: and i get the correctly result for controll2 = 0,0495...But that Payment Array Comes from stupid typing..In normal way, I will declare the Array as a variant, then it...
  5. Weilon Sung

    XIRR in VBA Access

    Hi, i am back from Tests. @Combo: I tried your way and sadly it doesn´t bring me to result. After that, I tried with manually Inputs and IT WORKS. Furthermore, I noticed it doesn`t make difference in Dates when I write it manually or from code. It is the Payments that makes error... But what...
  6. Weilon Sung

    XIRR in VBA Access

    Hi Guys, I build my macro according to the thread http://www.tek-tips.com/viewthread.cfm?qid=1740838 and don't get any results but Errors. I googled since 2 days for some Inputs. At least the Problem can come from some data Settings. I tried all the ways I know but it just didnt work... my...
See more

Part and Inventory Search

Back
Top