Recent content by Runutts2

Trying to figure out the RunSum function. Would like have a small db with the RunSum function on a form. Tried the Runsum function with Northwind db but would just get #Name?. Referenced the DAO 3.6 and moved the priority up but still could not get it to work. Thanks in advance

Trying to change this excel code into access. I think I need 3 tables. Header, Tie-in, and Survey then have a relationship for them. But not sure on translating the the code. The stuff like application worksheet, and dialog sheet.

One more try

I appreciate all the help I have received thus far, but what I just can’t figure out is how to have TVD, N / S, E / W give me the sum to that point using the TieTrueVerticalD, TieN/SCoordinates, and TieE/Wcoordinates as the starting point. I can get it to work on the first record using the IIf...

I still can't get what I am looking for, trying to get a running sum of a calculated field on a form. I am going to try and get it to work in the report, but would like to see the answer in the form .

Getting closer, Well I got it to work with a field that is in a table, but can't get to work on a calculated field that was added just to the form. Is there another step that I have to do to get it to work.

I finally got it, I had to place the code in the form module. I had just placed it as a new module before. Thanks again for the help

I still couldn't get that to work, do I need to apply a certain reference.

I copied the following code from the forum, but can't get it to work either. gives #Name? error, Tried =RunSum(Survey,"SurveyID",[SurveyID],"TVD") but it puts the form name in backets like this =RunSum([Survey],"SurveyID",[SurveyID],"TVD" Function RunSum(F As Form, KeyName As String, KeyValue...

I couldn't get that to work, comes up with #Name? error, fld and the field name with a space without a space with the field name in " " with the field name in [ ] couldn't get it to work.

Need help, not sure if I am going about it the right way, and hope I can explain it well enough to make sense. Trying to take an Excel spreadsheet that has calculations in cells that are based on entries that add to the previous cell. And have the running sum to that point appear on each line...

Thanks Travis for the quick reply, that was the ticket. Now it gives me the answer that I was expecting.

Having problems with ACOS worksheet function, when I use the ACOS function is gives me #Name? error. I have the MSowcf.dll file referenced but still did not work. I found another Code which uses the ArcCos function but it returns the wrong value. The code for the ArcCos function is as Follows...