Search results

Yes it did help, thank you very much. I have been playing around with it today. I have done all of the database, with help form everyone here, either directly or indirectly. This is my first real database, I have played around alittle bit with access but never really made a finished product that...

Thanks again, playing around with it right now...

I've uploaded my work in progress. It is full of rookie mistakes and is no where near being completed. The chemist at work that I am doing this for can not make up his mind and we are designing this on the fly. Niether of us have much for experience in access. I have implemented alot from...

2003 Thanks for your help, this has been bugging me all night

That's more along the lines of what I was thinking cpuSmoker! I am going to try that and see what happens. Thanks!

Thanks for your help!!! I guess when I was imagining this I was hoping it would be simplier than what it appears it will be. Being as dumb as I am when it comes to VB, I was thinking I would be able to just pull the rgb number out of a table and stick that behind the .backcolor =. I guess I...

Here's what I have: Dim rstColor As Recordset Dim strColorSQL As String strColorSQL = "SELECT red, green, blue " & _ "FROM tblColorPref " & _ "WHERE HeaderBox = " & strColorName & ";" Set rstColor = CurrentDb.OpenRecordset(strColorSQL)...

I have kind of a stupid question. Is it possible to have a form that gets it values for the background colors of like textboxes and such from a table? Kind of working like a css in web pages. I kinda played around with it but not able to get it to work, but that could be my shear incompetence in...

Thanks Pierre, that just seems more complicated then it needs to be. But maybe it's just me. I'll attach the db that I have so far. I have the metals test table and a form for Iron. The form is a rough version, I don't have all the calculations on it and just some fake data pluged in. Take a...

Sorry, really busy day, I will look at it tonight and post more tomorrow. Thanks again...

Thanks for the replies. I don't think I have explained this well enough. There is no possible way that I can come up with that would allow me to have just one form. Each test has it's own formulas that use different standards and other data that will be provided on the forms, there is an example...

Thanks for the reply, I already have my tables set up, I ended up with 3 tables, one for metals one for wet test and one for organics. I spent a week going through all of the test we do figuring out what results and such I would need as fields and so on. I included a partial spreadsheet of what...

Hi all. Let me introduce myself, my name is Matt and I am fairly new to access. I am an operator at a wastewater plant in Iowa (insert ewww's here). Since I am the most computer literate at work, and have some experience at access, they gave me the task of creating a database for our lab...