Recent content by kc112

Yes, I knew that answer of normalization was coming, but I do not think that it would be user friendly. If I added a table with 3 fields pktest - autonumber fkpatient - number selecttest -combobox with test options selectresult - combobox with positive, negative, didnotperform You are correct...

If at all possible, I would like to avoid the use of comboboxes here. There are over 30 tests and 30 combo boxes means a lot of room on one form and 30 table references. Is there any way to reference specific text in a textbox to trigger different text. I was hoping....if I set the triple...

Can I still use a checkbox with that? If yes, I am confused as to how to get it to print on the report. I am assuming something like: if fieldname = 1 then "Patient tested positive..." if fieldname = 0 then "patient tested negative..." is this correct?

First, I have been reading about this triple state checkbox a lot (which there is limited information) and apparently there is a large debate as to whether or not it should exist or if users should even incorporate it. So if someone has a better idea, I'm open to it! I originally set my fields...

Thank you..Thank you...THANK YOU ALL!!! It works! It works! Halleujah it works!!! :))))))))) I changed to: concatenate("SELECT cervflex FROM cervorthoexamnormal WHERE keycervexam =" & [keycervexam] & "") AND IT WORKS!!! Thank you so much, I couldn't have done this without your help!

I changed the keycervexam to 10 instead of 3 and got DATA MISMATCH error. I troubleshooted the ?pstrSQL statement and received this: ?pstrsql SELECT cervflex FROM cervorthoexamnormal WHERE keycervexam ='10' It does the same thing for whatever I make keycervexam for. If I change it to...

SQL: SELECT cervorthoexamnormal.keycervexam, concatenate("SELECT cervflex FROM cervorthoexamnormal WHERE keycervexam ='" & [keycervexam] & "'") AS Cervflex FROM [Cervical Exam Findings] INNER JOIN cervorthoexamnormal ON [Cervical Exam Findings].pkcervexam = cervorthoexamnormal.keycervexam...

I deleted everything but the following from my table, there are no NULL values: pkcervorthoexam keycervexam cervflex 17 3 left inferior thoracic 18 3 central superior cervical 19 3 central inferior cervical 15 3 left superior cervical...

OMG! That works! but why wont it work in the query then??? when I hit Enter I receive: ?concatenate ("SELECT cervflex FROM cervorthoexamnormal WHERE keycervexam = 3") left superior cervical, central superior cervical But, when I go to run my query, I get the error: DATA TYPE MISMATCH...

I think I messed up somewhere...:( I opened database, hit (control + g) and opened debug window. On the bottom is another window titled "immediate." I pasted your code in this window (i made sure I had a key record for #3) and went to DEBUG -> COMPILE and nothing happens! THen compile gets...

My apologies, I thought you just wanted to know which access version. I opened tools - references from the code window and checked: Microsoft DAO 3.51 Object Library Compiled and received: DATA TYPE MISMATCH and it highlights: Set rs = db.OpenRecordset(pstrSQL)

I have microsoft access 2000. I uncommented the correct lines per your post above. I compiled again and am still receiving the same error: USER DEFINED TYPE NOT DEFINED and it highlights: db As DAO.Database

okay...I ran debug-compile with the following code. (I commented out some and uncommented others, I attempted to follow directions per the code using DAO :) ) Function Concatenate(pstrSQL As String, _ Optional pstrDelim As String = ", ") _ As String 'Created by Duane Hookom...

Thank you so much for chiming in Duane! I was hoping you would :) table: cervorthoexamnormal key: keycervexam - autonumber field1: cervflex - text combo box I replaced mine with: Cervflex: concatenate ("SELECT cervflex FROM cervorthoexamnormal WHERE keycervexam ='" & [keycervexam] & "'")...

scratch that...I right clicked and added ' module' and pasted d.hookums code in its entire form. Now, I am receiving a syntax error and its highlighting CERVFLEX after SELECT in my code. Not sure why since that is the correct field name. Cervflex: concatenate (“SELECT cervflex FROM...