Search results for query: *

Thank you all.

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

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

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

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

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

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

it should read about 100-200 or something around that

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

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

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

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

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)

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

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

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

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

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

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 = "...." &...

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.