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!

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

Search results for query: *

  1. SoLost1

    Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query

    I'm brand new to Access so I may be doing this completely wrong, but I have a separate query object I wrote and I am trying to only include records based on the deals that were multiselected on the form SELECT tblIRRCashflow.DealName, tblIRRCashflow.Payment, vtblIRRCashflow.IRRDate FROM...
  2. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    Oh for sure, I wasn't looking for support, rather just curious because somehow MajorP had magically appeared on each thread with questions about his tool, so I was wondering if there was some forum function that I was missing in my typical fashion. I hope he's just taking a break from the forum...
  3. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    The Access column type is Date/Time on Access 365, can I define beyond that? Maybe I will try changing the XIRR_Wrapper() to Dates() AS Date and see if that resolves. Is there any way to msg specific users on this forum? Combo, you have been immense help(can't stress how grateful I am) and...
  4. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    It's interesting the MajorP's XIRR_Wrapper() calling Excel has Dates defined as String, Public Function XIRR_Wrapper(Payments() As Currency, Dates() As String, Optional GuessRate As Double = 0.9) but MajorP's homebaked has Dates() as Date Public Function MyXIRR(Payments() As Currency, Dates()...
  5. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    Well clearly that was facetious sarcasm because I couldn't hack my way out of a cardboard box, even with all the kings horses and all the kings men spoon feeding me help it seems. Passed it a Access column name per MajorP's instructions in another thread, so it should recognize as an array. I...
  6. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    When I try to use the XIRR_Wrapper() option I get a "Compile error: Type mismatch: array or user-defined type expected" on the "Dates" parameter of the XIRR_Wrapper function? Any thoughts? I tried testing the MyXIRR() option because I am a super smart next level international hacker/coder, and...
  7. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    Ahhhh I see. Thank you for the prompt response and patience with me, combo; as you can see I am a total noob when it comes to code. Now that you have pointed it out I am like "unagi" and I can see the forest that I couldn't see for all the trees in the way. I will give it a go, I imagine it...
  8. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    Combo, Thanks for the response. If you are using the excel library you need parts of the third section? I thought the third section is only MajP's proprietary code. Any thought on the GetGoodGuess() function part? Thanks.
  9. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    I still have not been able to get it to work. Can anyone please help this poor moron?
  10. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    Andy, Thank you for the prompt and helpful response, although I might need some time to digest because I am slow on the uptake, but if I use the early binding and activate the reference checkbox is that sufficient or do I need to add code to create an Xcel object? Any thoughts on the...
  11. SoLost1

    XIRR in Access HELP A NOOB PLOX!!

    I am brand new to Access and have only basic VBA experience coding macros in Excel, so apologies if I am being obtuse, but I am really struggling trying to get this(https://www.tek-tips.com/viewthread.cfm?qid=1789559) to work. Can I paste the code exactly as written for the two functions and it...

Part and Inventory Search

Back
Top