Search results

  1. R

    trouble w/ Yes/No check box not displaying Yes or No

    I have an Option Group object with "Yes" and "No" check boxes that automatically produce a value of 1 or 2 for the Option Group frame that they are in. The control source for the Option Group frame is [Support Required]. How can I get the Option Group to place "Yes" or "No" in the [Support...
  2. R

    It's driving me CRAZY!

    I've used this same thing (just different object names) in another database to preview only the current record and it works fine. In this database, however, when I click the cmd button, I get an error message of "Data type mismatch in criteria expression". My report is "Report2", my field is...
  3. R

    Changing text color based on values

    Changing text color of row in a query based on values I need to flag records in a query & it's table base on the results of an expression. This database has different Equipment at different Location with a DateTested compared to the current date to show the TimeSpan . For any record that has...
  4. R

    Subform for current record only to show on report

    I have a form with a subform and a Report Preview cmd coded to open the report for only the current record. This is successful, however, the report shows the subform info for all the records. I've tried to tinker with the code to do the same for the subform as it does for the form (to show...
  5. R

    Calculating a total of a Subform field

    I have a "Request" form that includes an "Equipment" subform where the user can enter devices and their costs of items they want from inventory. The relationship of the two tables is by REQUEST# and the user can print their report based on this request#. Therefore, for each request, the...
Back
Top Bottom