Search results for query: *

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

Is it possible to write this in the design view of the query? I'm not very familiar w/the SQL view and what I have in there now has a lot of SQL code in it that I dont want to mess around with.

OK so tblRefFunction is the name of the table correct? -statusID and strFunction are the name of two fields in the table???? -and put the data in each corresponding column??? never done an inner join, so I'll have to look into that.

Ok, I'm a little confused on how I would do that. I'm guessing you mean to make a table, call it "Function" or whatever name. Then what? I'm a little confused there.

Ok got it, Thanks. Question though. What do you do if the IIF statement is too long? I've never ran into that issue. And I want to make it all one field instead of two.

Any help on why this nested IIF statement isn't working properly? There aren't any errors. It just returns "Processing" for every field. I've checked spelling, etc. but no luck. Function: IIf([dbo_flat_wo]![status]="File Prep" Or "File Process" Or "File Received" Or "File Rev Miss/I" Or "File...