Recent content by ptw78

yes that is correct 2 is always FHA, 3, 4 alwayas VA

k, i have a small issue, it seems that some of the fields that are "Private" should be FHA or VA, so they have a CD of "B", "L", "M", "N", "S", "W" and a loanType of 2, 3, but I need it to show FHA and it's showing Private.

ok, i think i got it., thx

ok, now on some of the vba, what is Variant? then i see Nz, what is Nz for?

k, i'm not to familiar w/what a reference table is but i looks like you just did a sub in vba and then in the access query you referenced that sub???

I am putting this code into an access query and the last two iif statements give me a #Error result. So it's not recognizing anything for "VA", "FHA", "RISK". Investor2: IIf([MIS.CD] In ('B','L','M','N','S','W'),"PRIVATE",IIf([MIS.CD] In ('C','V'),"FHLMC",IIf([MIS.CD] In...

This would be in excel. Basically i have a list of account numbers in excel, i want to plug that into rumba pull up the info for the acct and extract some data from rumba back to the excel list i have

Is it possible to write vba in an access(or excel file) to or from Rumba? Or is there a forum for this? I couldn't find one. thx

Thx I'll check it out can try some of it out.

No solution yet. I'm not even as far as you are using the Internet controls & HTML library

Yea I finally find out what the issue was. But basically what I have is a link on one sheet(sheet2) can call it "Link A" and on another sheet(sheet1) I have a Vlookup where I want to have the value the Vlookup returns as a link("Link B") which is =HYPERLINK(VLOOKUP(C6,'Investor...

I cannot get this Hyperlink/Vlookup to work. It will show the lookup value as a hyperlink, but when I click on it it says "Cannot open specified file." When I click the link on the source page it does open. Any suggestions on this? thx =HYPERLINK(VLOOKUP(C6,'Investor...

Ok, thx for the tip.

Doing this brings me to another question. If I have a field in a query where I'm going to put a lot of things in the criteria, would doing an inner join like this be the right way to go? And if so is it a similar process as doing it with a calculated field?

Nevermind, looks like I've figured it out. Thanks for the help