Search results

  1. E

    Is it possible to pass a numeric variable to a criteria parameter in a query?

    I have a form that I use for entering data. One of the fields in each record is an autonumbered field called "RecordID." There is a button on the form that (on click) executes a VBA script that saves the current record and then executes a command to print a report containing the data from a...
  2. E

    How to pass a value from one subform to another?

    I have a parent form with three tabs for subforms. Each subform is attached to a table: · "Demographics" displays a single record. · "Appointments" displays continuous records. · "Status" displays continuous records. To enter a new record under "Appointments" or "Status", I use a...
    • Eddie
    • Thread
    • Replies: 4
    • Forum: Forms
  3. E

    Conditional reporting based on value of a field in a selected record

    I have the following code that I need help modifying: Private Sub ChargeReport_Click() On Error GoTo Err_ChargeReport_Click Dim stDocName As String stDocName = "Charges_Report" DoCmd.SendObject acReport, stDocName, acFormatPDF, , , , "Charge Sheet" Exit_ChargeReport_Click...
  4. E

    Automating multiple reports with a macro that prompts user for a date range

    I am a bit of a noob who needs help with a problem that I have not been able to figure out on my own. A database that I created has a main query that includes a lot of calculations of data that it pulls from a main table. The main query prompts the user for a date range with a "Between [start...
Back
Top Bottom