Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ptw78
  • Order by date
  1. ptw78

    code help

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

    code help

    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.
  3. ptw78

    code help

    ok, i think i got it., thx
  4. ptw78

    code help

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

    code help

    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???
  6. ptw78

    code help

    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...
  7. ptw78

    VBA & Rumba

    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
  8. ptw78

    VBA & Rumba

    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
  9. ptw78

    VBA to Write to Website

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

    VBA to Write to Website

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

    Excel Vlookup & Hyperlink

    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...
  12. ptw78

    Excel Vlookup & Hyperlink

    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...
  13. ptw78

    Nested IIF stament in Calculate field

    Ok, thx for the tip.
  14. ptw78

    Nested IIF stament in Calculate field

    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?
  15. ptw78

    Nested IIF stament in Calculate field

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

    Nested IIF stament in Calculate field

    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.
  17. ptw78

    Nested IIF stament in Calculate field

    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.
  18. ptw78

    Nested IIF stament in Calculate field

    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.
  19. ptw78

    Nested IIF stament in Calculate field

    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.
  20. ptw78

    Nested IIF stament in Calculate field

    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...

Part and Inventory Search

Back
Top