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 philipmck

  1. philipmck

    EXCEL FORMULA

    Thank you all.
  2. philipmck

    RUN TIME ERROR 459

    Yes thats the conclustion i was coming to. Originally it was obtaining data through PHD_HOST and this worked perfectly up until last friday. I then changed it to MKVPHDSS (this is like a historical server as far as i know) and it was able to obtain data from it but now it gets nothing. Would you...
  3. philipmck

    RUN TIME ERROR 459

    when the error msg appears i can only end it. i cannot choose debug and the find the line
  4. philipmck

    EXCEL FORMULA

    IF(A2287<>"",IF(Raw_Data!B2287-Raw_Data!B2286>=0,(Raw_Data!B2287-Raw_Data!B2286) * 0.22,F2286),"") What the above formula is doing is finding if 2287 - 2286 is >= 0. if so thanks ok if not use the previous cell (2286) i was given if (x1 > x2, = x2 + (limit-x1),x2-x1) and then i have to make...
  5. philipmck

    RUN TIME ERROR 459

    When i try to run uniperformance to obtain data from the PHD it brings up run time error 459 stating that the object or class does not support the set of events. this is strange as the spreadsheet was working perfectly well yesterday and I have no idea what could be wrong. I have included the...
  6. philipmck

    EXCEL FORMULA

    this is still not working correctly for whatever strange reason. this is the formula which it currently uses: =IF(A2287<>"",IF(Raw_Data!B2287-Raw_Data!B2286>=0,(Raw_Data!B2287-Raw_Data!B2286) * 0.22,F2286),"") but what i need to change it for is because i need to add in limits ie the 500000...
  7. philipmck

    EXCEL FORMULA

    The *0.22 is because it comes in as m3 in raw_data and in formatted data it needs to be mgal. this converts it. what it is meant to do is find out if the cell that it is inserting into the database is greater in size that the one previous which is already there. if this is the case it then...
  8. philipmck

    EXCEL FORMULA

    it should read about 100-200 or something around that
  9. philipmck

    EXCEL FORMULA

    I have also noticed that when i used my number it was minus approx 40000 and now using glenns formula it is down to approx 5000 but it should be positive
  10. philipmck

    EXCEL FORMULA

    They are values that come in from PHD. One for instance i think is 193.88 or a number like that but they most definately shouldnt appear in negative. I know that for a fact. Its just getting the correct formula is the problem. \\FORMULA//...
  11. philipmck

    RUN TIME ERROR (2185)

    i need to create a query that reads what is in text43 (name of text field) and searches the database for the information that is contained in the field
  12. philipmck

    RUN TIME ERROR (2185)

    Thanks that has worked. Also I wonder if you could help me with this. I have 3 combo boxes. the user selects information out of all 3 but depending on what you click in for instance combo 1 depends what is seen on combo 2. the idea is that when the user clicks on the "search" button that it...
  13. philipmck

    EXCEL FORMULA

    Yes I am having a problem with that as when i run the formula it is bringing back a minus figure, something it is not meant to do. Would you know why this is and i am using the formula that GlennUK suppled. Thanks for your help (xlbo & glennuk)
  14. philipmck

    RUN TIME ERROR (2185)

    When i run the program i get a run time error "2185" for the below code. error message: you cant reference a property or method for a control unless the control has the focus \\VB CODE// If Me.ProcessCombo.Text = "...." & Me.Option1Combo.Text = "...." & Me.Option2Combo.Text = "..." Then...
  15. philipmck

    EXCEL FORMULA

    = IF (A2288<>"", IF (RAW_DATA!B2288 > RAW_DATA!B2287, (RAW_DATA!B2287 + (50000–RAW_DATA!B2288), (RAW_DATA!B2288 – RAW_DATA!B2287) * 0.22)),"") I have this formula in my database to do a calculation but it brings up an error box stating that " the formula i typed contains an error". What i am...
See more

Part and Inventory Search

Back
Top