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!

Recent content by writersoon

  1. writersoon

    Long,long IIf statement

    I am calling the function as the control source in a form, but i am not getting "test", i tried from a query also, but no luck. I tried changing the Null's to variables that can be tested instead of having an empty value, i cant think of anything else... Thanks
  2. writersoon

    Long,long IIf statement

    I have an argument in the maketable query that i am using to run the function. I have deletd as you have pointed out, but maybe i am not placing calling the function correctly to the query? I have been running the code in diffrent ways... Thanks. Public Function getComment() Dim strType As...
  3. writersoon

    Long,long IIf statement

    Ok, I tried the code a few diffrent ways and i am still recieving the #name# error. Ive adjusted the code to below, can anybody see a mistake in it. Option Compare Database Public Function getComment() Dim strType As String Dim strStock As String Dim strInventory As Integer Dim intLinePt As...
  4. writersoon

    Long,long IIf statement

    When i run the code i dont get any errors, but when the query is ran the entire comments section is #error#. That what i thought when i wrote that it seemed to work, because i didnt recieve an error in vba.
  5. writersoon

    Long,long IIf statement

    I tried the code and it seemed to work, but the comment column is full of #Errors#, but iam not recieving a debugging error in the code.
  6. writersoon

    Long,long IIf statement

    Is the code suppose to say "theType". I understand exactly what you have written, it looks good...
  7. writersoon

    Long,long IIf statement

    Do you have a a code example to go off? All i am trying to do is make one query from an import that inserts the above comments into a column of its own if the criteria meets.
  8. writersoon

    Long,long IIf statement

    Does anyone know how to make these 3 IIf statements into one? I am trying to put it all in one column and i keep recieving errors when i make input all 3 statments into 1 and change the query to a make table query. Thanks in advance... SELECT p.*, IIf([POType]="PO" And [NonStock]="N","NS"...
  9. writersoon

    Confused on a confusing iif statement

    The extra table is what i was trying avoid because i just wanted to use the db to import, filter, and mail an excel file. I adjusted the code from above but it kept counting the comments that i need inserted as PO Types: SELECT IIf([POType] = "DO" AND [NonStock] = "N","NS Direct"...
  10. writersoon

    Confused on a confusing iif statement

    Hey thanks... I made another table, andI tried a few diffrent combinations,but i keep getting error clauses and from errors. From your SQL I refomated the two table as follows: table1(po review) is 5 colums POType NonStock InventoryPos LinePt Availability PO N...
  11. writersoon

    Confused on a confusing iif statement

    Ive tried everything i can think of, but i just would rather one sql statement rather than code, ive tried coding it but i kept getting errors. The db dosent contain tables just the headings because i have a automarco that imports a table from a shared network and loads the query and outputs as...
  12. writersoon

    Confused on a confusing iif statement

    I've created a db with 1 update table and 1 maketable query. I ve created an iif statement but its not long enough for the info i need. The statement works, but where do i fit the rest in? SELECT IIf([PO Type]="BO","Blkt Order",IIf([PO Type]="RM","PORM",IIf([PO Type]="WT","WHS...
See more

Part and Inventory Search

Back
Top