Recent content by mstephen

Thank You it's working.

I have added the second delete query and it's working fine now. There is one how to:; I have turned off or unchecked the confirmation message box that you get when you run the updat/delete query (tools/options/edit find/action query) is there any code to run in the module ONLY thus allowing me...

I'm running an update query in a macro/module and want to add "delete record" to it. Keying off of tlb-field name-text in field. I added a delete query to the macro/module and that didn't work. It seem to override the existing update query that's in the module. So I'm looking for the delete...

It does up to a period, what it doesn't do is give a start & end period together, which gives you the cumulative version of ipmt. I a little stuck on the suggestion of calling the excel functions to access.

Still searching for answer. Does anyone know if there is a way to add the excel financial function "cumipmt" to access? If so what is the process? I've checked the excel object library 11.0 in the references and still nothing. I've tried a number of formulas/equations. The only accurate...

=Sum(IPmt([intrt]*0.01/12,("1"-"5"),[term],-[lnamt])) this is an expression that should work but the 1-5 is a problem and it's not working. The 1-5 represents the start month & end month.

I've tried the reference library earlier "microsoft excel 11.0 object library" and did a browser check for cumipmt and nothing. I'll try again though. Thanks

Looking to use cumipmt function or code in access form. Have searched high and low for the correct code or possible reference library. What I have tried x=cumipmt(rate,term,lnamt,start,end) and not working. Anyone have the answer. Thanks