Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kc112
  • Content: Threads
  • Order by date
  1. kc112

    triple state checkbox on report help

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

    concatenate records in a query help

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

    subreports not printing

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

    Normalization and adding multiple records

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

    text box control source on report help

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

    if then statement on checkbox to print text on report?

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

    Open child form with button?

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

    Autopopulate Foriegn key not working!

    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"...
  9. kc112

    Omit empty fields on my report???

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

Part and Inventory Search

Back
Top