Recent content by MajP

Even if you fix the subform reference, this will not work. No idea what you are trying, but it makes no sense. As far as the reference. Forms is a collection or the open forms. A collection has items in it. An item is not a property. However controls on a form are both properties and items...

No. Imagine it returns 2 fields. AssociateID and 2017. The count is 2 the index you care about is 1. So If rs.fields.count > 1 then Me!txtYear1 = rs(1).Name Me!txtValue1 = rs(1).value then on your next when you need to check if if rs.fields.count > 2 Me!txtYear2 = rs(2).Name...

you just need to check the count of the fields. if you are looking for RS(1) you need more than one field (2 fields) if RS.fields.count > yourIndex then But I can shorten all of your code with that logic Do Until rs.EOF = True for I = 1 to rs.fields.count - 1...

http://www.cpearson.com/excel/vbaarrays.htm

After reviewing this, I think my XIRR function handles the negative rates of return OK. I think where it bombs out are rates with a large magnitude over 100%. I think what happens is in the code you do Payments(i) / ((1 + Rate) ^ TimeInvested). Since time is in days and a large number, if the...

FYI, on my version code I get a solution for your data. However, the solution is -0.699 no -.66. I did it in Excel and that is the correct number. So do not know what the issue is.

There are two different things here. The first time I wrote the code for Access was simply to allow you to store your data in Access and run the XIRR excel function. So it creates a recordset for a specific cashflow and puts the dates and payments into arrays. Then it simply calls the Excel...

Are you referring to this thread705-1740838 thread705-1778232 If so, there could be lots of reasons. I do not know how the Excel function really works. I coded the solution by using Newtons method to find the roots of the polynomial. When I wrote the code I had never heard of the XIRR or...

TblEmployee EmployeeID 'PK other employee fields tblFunctionalArea FunctionalAreaID ' PK Other functional Area Fields tblClassification ClassificationID ' PK Other classification fields 'I am assuming that there are shared classifications per function so that it is many to many...

Are you sure you have done this before? AFAIK that is not possible. I do not have Access here to verify. You can put a subform on a tab with a tab control in the subform thus giving the appearance and potentially achieving the same results. What are you trying to do? That sounds like a very...

My work was mainly on the calendar control and year form. Oxicottin did the work on the other forms and reports. When he opens the form to edit/add an employees bought vacation he opens to that employee. The problem is there is nothing to set the employee id for new records. One solution is...

In the Year View calendar, I set the label of the 12 subform instances sFrmJan.LblMonth.Caption = "January" sFrmFeb.LblMonth.Caption = "February" sFrmMar.LblMonth.Caption = "March" sFrmApr.LblMonth.Caption = "April" sFrmMay.LblMonth.Caption = "May"...

I wrote this code. When I wrote it I was thinking a US format. MM/DD/YYYY. I did not account for European format DD/MM/YYYY. That tends to be the biggest issue.

Not sure what that means. Can you take a screen shot?

Is there an error message? Does qryAddSequence contain all of the records? Does it hang or just kick out?