Loanamt
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 12 articles for 0.302 sec
I need to do this: 1. Loop though each record and if a match is found end the loop Else 2. Run though the loop again and if a partial match is found then open a form. I have to loop through the entire set of records FIRST because there are full matches and partial matches in each row. A full match can be automatically posted but the partials need to have a form opened so that I can     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Loanamt in microsoft.public.access.modulesdaovba
Author: Stephen Lynch
Date: Aug 24, 2008 20:22

Disregard Found it "Stephen Lynch" <raider1raidospam@yahoo.com> wrote in message news:%%235w0zGgBJHA.3828@TK2MSFTNGP06.phx.gbl... Can someone check my code. I keep getting a "loop without Do" error. If I add another end if it just keeps running. Thanks ***************************************************** Private Sub LstboxLoansPending_DblClick(Cancel As Integer)
Show full article (2.74Kb)
Can someone check my code. I keep getting a "loop without Do" error. If I add another end if it just keeps running. Thanks ***************************************************** Private Sub LstboxLoansPending_DblClick(Cancel As Integer) Dim rs As DAO.Recordset Dim StrSQL As String Dim strEmployeeIDContFile As String Dim strEmployeeContAmt As Currency EmployeeID = Me!LstboxLoansPending     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Loanamt in microsoft.public.access.modulesdaovba
Author: Stephen Lynch
Date: Aug 24, 2008 09:19

<gensicki@gmail.com> wrote in message news:66d6d75c-8461-4714-82e4-0cbf5c517ba0@a35g2000prf.googlegroups.com... On Nov 28, 12:07 pm, "Ken Snell \(MVP\)" <kthsneisll...@ncoomcastt.renaetl> wrote: I need to see the entire SQL statement. Open your query in Design view, click on "query view" icon at far left of toolbar, select "SQL View", and copy all the text that you see in that next
Show full article (1.79Kb) · Show article thread
On Nov 28, 12:07 pm, "Ken Snell \(MVP\)" <kthsneisll...@ncoomcastt.renaetl> wrote: > I need to see the entire SQL statement. Open your query in Design view, > click on "query view" icon at far left of toolbar, select "SQL View", and > copy all the text that you see in that next window. Paste that text into > your post here. Do for all queries involved in the "outstanding balance" > query. >     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Loanamt in microsoft.public.access.modulesdaovba
Author: Stephen Lynch
Date: Aug 24, 2008 08:54

I need to see the entire SQL statement. Open your query in Design view, click on "query view" icon at far left of toolbar, select "SQL View", and copy all the text that you see in that next window. Paste that text into your post here. Do for all queries involved in the "outstanding balance" query. -- Ken Snell <MS ACCESS <gensicki@gmail.com> wrote in message news
Show full article (1.56Kb)
On Nov 27, 6:32 pm, "Ken Snell \(MVP\)" <kthsneisll...@ncoomcastt.renaetl> wrote: > To do the calculation, you'll need to use the Outstanding balance query to > get the current balance. I am assuming that this query will return a balance > amount even if no payments have been made by the customer yet? Or does it > depend upon the presence of at least one payment by the customer? > > For the     

Group: microsoft.public.access.forms · Group Profile · Search for Loanamt in microsoft.public.access.forms
Author: Ken Snell (MVP)
Date: Nov 30, 2007 12:25

On May 25, 2:22 pm, Serina <Ser...@discussions.microsoft.com> wrote: i am trying to put in this equation into my formula box: -pmt(rate/12,12*years,loan_amt and it says that it is susposed to be a minus sign (-) instead of an equal sign (=) when i push enter it just adds the equal sign(=) right in there so then it doesnt do what i want it to do To my knowledge, Excel formulas
Show full article (6.93Kb) · Show article thread
On May 25, 2:22 pm, Serina <Ser...@discussions.microsoft.com> wrote: > i am trying to put in this equation into my formula box: > -pmt(rate/12,12*years,loan_amt > and it says that it is susposed to be a minus sign (-) instead of an > equal sign (=) when i push enter it just adds the equal sign(=) right > in there so then it doesnt do what i want it to do What does it do differently     

Group: microsoft.public.access.forms · Group Profile · Search for Loanamt in microsoft.public.access.forms
Author: gensicki
Date: Nov 28, 2007 13:29

Hello, I want to thank both of you guys for answering my question. Correct, I realize storing the calculations in the table is a no,no so that is why I was trying to figure out how to get in the report through a query. I did put the formula in the Field rather than the Criteria of the query and that was it. Just a bad rookie mistake on my part, I should have better. I will however save
Show full article (4.79Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Loanamt in microsoft.public.access.forms
Author: Ken Snell (MVP)
Date: Nov 28, 2007 12:07

Show full article (3.91Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Loanamt in microsoft.public.access.forms
Author: gensicki
Date: Nov 28, 2007 11:31

Show full article (3.28Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Loanamt in microsoft.public.excel.misc
Author: joeu2004
Date: May 31, 2007 18:45

Show full article (1.27Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Loanamt in microsoft.public.excel.misc
Author: joeu2004
Date: May 25, 2007 15:15

Show full article (1.49Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Loanamt in microsoft.public.access.formscoding
Author: Doug_C
Date: Jul 20, 2006 07:45

Show full article (3.04Kb)
1 · 2 · next