Search results for query: *

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

I'm not sure...I followed D.Hookums example at: http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16.html Since you said that, I looked behind his example and he does have a series of code for the function. His is under a MODULE folder. I don't have...

I am trying to concatenate my records from my query to list in one text box with comma seperators on the report. I want it to look like this: THe patient demonstrated pain upon cervical flexion in the following region(s): right inferior cervical, left superior cervical, etc... table...

Thank you both for your helpful answers. I'm going to go and study that website lameid! Thanks again!

Ok...been doing some research on what you said. and found this: Method 2: Add a field from a related table by using the field list In the Navigation Pane, right-click the report you want to modify, and then click Layout View. If the Field List task pane is not already displayed, on the Design...

Yes, my entire report is made up on tables and subreports(which are comprised from tables). How do I join via a record source? I know there is a field for record source on the properties tab, but my table name is there. Also, for the majority of my report I created textboxes to display the...