Search results for query: *

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

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

ok...I'm at a loss with this one. I have my report with multiple subreports. I can print the report and all subreports show up. I have a mainframe form that gives the user an option to select one patient record and print the report. This prints all subreports. BUT!! I also added a print...

ok..I've normalized! :0) I have: Main table: txplandata PK - key (autonumber) subtable: dx PK - pkdx (autonumber) FK - keytx field 1: primedx (combo box) field 2: second dx (combo box) So, any patient can have multiple prime dx's and multiple second dx. I linked the tables via a...

I have a field yes/no field for a test. Then I have combo boxes for all the possible outcomes if the test is positive. On the report...I made a text box with: =iif([cervical_extension]=true,"The patient demonstrated"&" "&[cervext1]&,& &" " &[cervext2]& "upon cervical extension.","") Which...

Hello, I have had much help with this forum..so here we go again! I have a yes/no field titled "Froment's Paper Sign." If the patient is negtive for the test, then do not print and do not check box. If patient is positive for the test, I want the user to 'check' the check box and on the...

Please help!! I have a main form and a subform with a relationship link. I used a button with the openform command and built the following code: Private Sub HPIComplaint1_Click() On Error GoTo Err_HPIComplaint1_Click Dim stDocName As String Dim stLinkCriteria As String stDocName...

I have a main form with a autopopulated primary key titled "key". I then created a second table and form (my subform) with a field entry entitled "key" for a foriegn key. (I did not set a primary key on my subform) I opened up the relationships and linked both tables with a bold line via "key"...

Hello, I am new here and new to using Access, so please be patient... I am creating an program to print and track treament outcomes at my office. I made the table and then created a main form that outlines data such as patient name, complaint, ID #, etc.. THen in that same form there are (2)...