Recent content by alh1002

actually reading thru this what I really want is once in a drawdown start multipling the months together and find the max negative %, so the drawdown would be 0.8729721 which is just the percent changes of the last 4 together. In this case the numbers are similar but I was looking and when I...

I have a column of dates and monthly percentages. To find the maximum drawdown I would (in excel) make another column of numbers which is the running total of percentages and then I would locate anywhere the running total goes down. The largest drawdown would be measured from running total...

ok, I am debugging this, but I am incorrectly setting the RS for the form NAV_bound I have Set Me.Recordset = rsNAV1 'Me.OpenArgs Dim strDate As String strDate = Me.OpenArgs Debug.Print strDate and the correct date (from Form3) is coming out...

where does the Me.OpenArgs go? I get an error when I put it with the set that it is invalid use of property Set Me.Recordset = rsNAV1 Me.OpenArgs 'then everything else I want to set

I have one form (Form3)which has the following code Private Sub ladder_date_DblClick(Cancel As Integer) DoCmd.OpenForm "NAV_bound", , , "ladder_date = " & [Forms]![FORM3]![ladder_date] End Sub where ladder_date is the date on the form. I then want it to open the form NAV_bound...

when i double click I am opening the form but the date has no effect it is just opening the new form at the beginning, is this because how the form is set up? so what I want: Form1 has a summary table in the form of a list. Then a second form NAV_bound, has details of that record. What I want...

I saw something like that, but I have a list box, which isn't a record set. Can/should I just change the data source to record set and make the record set the SQL query? When I look at the properties of a listbox I don't see any option which makes me believe it comes from a record set. How...

I have a form, which simply a list of dates and information from a query (which is simply a restatement of a table except for one criteria). I want to be able to click on given record and then another form opens up which has all the info in the table for that date. At the moment I have each...

that gives the same multi step error as listed above I inserting a variable to make it simplier, and still get the multi step operation error Dim temp As String temp = "Modified " & Now Me.comments = temp & Me.comments

rsNAV!notes is the record set and on the table the column is notes. by inserting the code suggested I get an run time error '-2147217887 (8004e21)' Multipe-step operation generated errors. Check each status value. So the base code, which works but doesn't do the automatic appending of the...

I have a field that I want to time stamp everytime there is a change. But I don't want to erase what was there. So I can't simply put Me.comment= date & time, I tried the below code but it breaks. How can I just append something witht the date and time? Private Sub cmdSaveAll_Click()...

the change did the job, I thought I tried that and it didn't work. but must have been something else. Thanks again.

I changed it a bit to test but the answer doesn't make sense to me for example the data percent 1.08832365210684 1.00899205638114 1.17818411583782 1.06316304589373 0.997640825063864 0.985738046552014 1.00239727437619 1.06028349738827 1.12160930620503 1.10432671400852 0.925754515406271...

My DB has monthly percentages. I want to compare sequential percentages and if they are negative multiple together to find max consecutive negative months. I can do this in multiple steps in excel, by doing an if statement and making all positive values =1 and then doing another column of ifs...

I copied a table, just using copy paste, and renamed the old table tblPerformance_old and renamed the new one I copied just tblPerformance. I did this as I am testing some new data used for calculations. Anyway, when i run the vba code in excel which calls the table, I get an error box...