Search results

  1. C

    Combine TWO IIF(IsNull) Expressions into one control

    Is it possible to combine two IIf(IsNull) Expressions into one control on a report in design view or in a query without having to do concatenating and looping and what not? =IIf(IsNull([Constitutional]),"CONSTITUTIONAL SYMPTOMS: None ",("CONSTITUTIONAL SYMPTOMS: ") & " " & [Constitutional]) I...
  2. C

    Help w/ check box that can add additional text to field, not just replace text.

    Hello, I need help adding text to a field by using a check box. Not just replacing the current text with the text I coded in. Private Sub CheckBoxName_AfterUpdate() If Me![CheckBoxName].Value = False Then Me![FieldName] = Null If Me![CheckBoxName].Value = True Then Me![FieldName] = "text"...
  3. C

    Help adding "text" (ENTER) and more text using VB

    Hi all, I have check boxes that automatically input text into fields on forms. I use this code... Private Sub Check88_AfterUpdate() If Me![Check88].Value = False Then Me![VisitHistory] = Null If Me![Check88].Value = True Then Me![VisitHistory] = "Additional text." DoCmd.RunCommand...
  4. C

    Is it possible to delete the last comma using Trim?

    Hi, Does anybody know how I would get rid of the last comma in the following expression? Pardon me if I don't use the correct terminology but, I'm creating a report where I'm combining a bunch of fields separated by commas. But the problem is that if I don't populate the last field in the...
  5. C

    Combo Box creating multiple unwanted pages on a report

    Hi and thanks for your interest, I'm creating a database to produce transcriptions in a medical office instead of having to go through a transcription service. I have a main form with multiple subforms(4) and tabcontrols(2). The subform I use to enter medications is based on a control box...
  6. C

    Report for Current Record on form without Prompting for ID

    I've been trying to figure this out for hours now. I need the code to Preview a report for only the current record on my form without prompting for the ID. I'm making a patient report database. This is the code I'm using now... is there a way I could simply revise this code so I won't have to...
Back
Top Bottom