Search results

This may seem a basic question but where to I put that code? I think I need to keep the temperatures in different columns as they are being taken from different places. Temps taken at each location at different time points will appear in rows.

Hi, The cold value is out of spec if it is >19. Hot value is out of spec if it is <50. Why is cold 1, cold 2, cold 3 not good?

Hi, Thanks for your response. I'm not entirely sure what you mean but here goes. Temperature Results Building Name, Building Number, Sentinel Cold, Sentinel Hot, Calorifier Out, Calorifer In, Cold 1, Hot 1, Cold 2, Hot 2, Main Building, 101, 10, 66, 10, 66, 66, 55, 10, 66, 10, 66 HSE...

Hi, I am posting in General as i don't know what this comes under. I have a results database that collates information that is collected monthly over numerous locations. It's a temperature result. What I want to be able to do is count the excursions. So temperatures greater than 30 for...

It's lovely if you come when it's not raining! :)

Woo hoo...that is awesome....it works. Thanks very much :)

I've attached my database. Hope you can help.:D

I think the code is in the right place. I'll upload the db in the morning. I'm away from my computer now. I really appreciate your help. I'm on a steep learning curve!

Column count is at 2!

Thanks, I've put this: Me.Building_NameControl = Me.Building_Number.Column(1) but still doesn't want to work. :banghead:

Hi, I am putting together a simple database to do with monitoring maintenace of buildings. I was the building number to automatcially populate when the building name is select. I have got the the point where I have building name and number in the building name combo box but i'm stuck with...

I am using access 2000.

Hi, I have just registered with this forum as i am building an access database and i'm having a few issues. I have a number of drop down menus to select Building Name, Building Number and then Equipment Name and Equipment Number. I want the list to be linked so that when you select the...