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: philipmck
  • Order by date
  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...
  16. philipmck

    SEARCHING USING COMBO BOXES

    I have the database on the form. That works perfect: Private Sub Form_Load() 'Me.Child27 = Data End Sub What i need the code for is to get the SEARCH button to take 3 pieces of information from 3 combo boxes and then search the database with the selected information ps thanks for your help
  17. philipmck

    RUN TIME ERROR 2185

    Yeh. Basically what happens is the search button takes 3 bits of text from 3 combo boxes. the text selected is obviously what the user has selected in the list. The search button then matches the text up with the bit of code that has the same information it would match .... , ... , ... with the...
  18. philipmck

    RUN TIME ERROR 2185

    I have done that and i got the following pop-up box: Complile error: Method or data member not found I did notice in the list of options that appears when you insert "." the text option was not available. The only place in the list text is mentioned is controltiptext and status bar text \\VB...
  19. philipmck

    RUN TIME ERROR 2185

    When i run the program i get a run time error "2185" for the below code. As far as i know it is to do with the .text function but i dont know what i can replace it with as it is used in conjuction with a text field. \\VB CODE// If Me.ProcessCombo.Text = "...." & Me.Option1Combo.Text = "...." &...
  20. philipmck

    SEARCHING USING COMBO BOXES

    Basically i have a database window showing in the form. At the start all of the records are showing then once a search is completed it just shows the results. And apologies but i didnt mean to shout.

Part and Inventory Search

Back
Top