Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Location
    Covington, LA
    Posts
    46

    Question Unanswered: list selected checkboxes in report

    i have a table (tblChart) that stores the Patients Chart information, when we print the daily activity report, it would be VERY helpful to have the checkboxes in the chart table list only the selected checkboxes. so, instead of listing all ow the check box field below, it just says "FS, OR, EKG, LAB, BillStatement" instead of showing all the fields, just list the ones that are checked. does anyone know what i'm getting at, and know a way to get it? let me know please. as you can see, listing all of the following options on a report takes up more space on a piece of paper than we'd like.

    FS
    DS
    HP
    OR
    PR
    EKG
    LAB
    CARD
    CONSULT
    CN
    Other
    Microfilm
    AbstractChart
    EntireChart
    BillStatement
    StartDate
    EndDate

    thanks again.
    Unique like everyone else,
    Clark
    -------------------------------------------
    POSTING IS THE TERRIBLE SECRET OF SPACE!

  2. #2
    Join Date
    Jul 2002
    Posts
    9
    Sounds doable but am not entirely clear on what u want to achieve -0 give a bit more explanation and I'll try and fix you up

  3. #3
    Join Date
    Mar 2002
    Location
    Covington, LA
    Posts
    46
    well, i have a kind of example of what i want. i added a text box to the chart subform. and then added this code to it's gotfocus event.

    Private Sub Text38_GotFocus()
    Text38 = "" 'clear the textbox
    If FS = True Then Text38 = Text38 & ", FS"
    If DS = True Then Text38 = Text38 & ", DS"
    If HP = True Then Text38 = Text38 & ", HP"
    If OR1 = True Then Text38 = Text38 & ", OR"
    If PR = True Then Text38 = Text38 & ", PR"
    If EKG = True Then Text38 = Text38 & ", EKG"
    If LAB = True Then Text38 = Text38 & ", LAB"
    If CARD = True Then Text38 = Text38 & ", CARD"
    If CONSULT = True Then Text38 = Text38 & ", CONSULT"
    If CN = True Then Text38 = Text38 & ", CN"
    If Other = True Then Text38 = Text38 & ", Other"
    If Microfilm = True Then Text38 = Text38 & ", Microfilm"
    If AbstractChart = True Then Text38 = Text38 & ", Abstract of Chart"
    If EntireChart = True Then Text38 = Text38 & ", Entire Chart"
    If BillStatement = True Then Text38 = Text38 & ", Bill/Statement"
    If StartDate > "" Then Text38 = Text38 & ", " & StartDate & " - " & EndDate
    End Sub

    so now i have a text box that list what i basicly need. last chart i looked at listed this in the box.
    , FS, OR, CARD, Entire Chart
    the only problem with this is that i need it to run from a query or even be able to run the code once per invoice on the report.

    to clear things up. i have a report that lists all of the activities of the day at a certain site. it groups by siteID and shows the following information sorted in ascending order by InvoiceNUmber. it also shows the patients name, DOB, the Requester, Comments, the date entered, the status of the request, and lastly, it is supposed to list the chart information contained. instead of a bunch of checkboxes, i'd rather have a textbox that lists whats checked for the record.

    i hope that explains my needs. let me know if any other details are know. thanks.
    Unique like everyone else,
    Clark
    -------------------------------------------
    POSTING IS THE TERRIBLE SECRET OF SPACE!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •