Search results

  1. J

    IIf Statements with DoCmd

    I have a MS sample database with a form named Task List that tracks daily task summary in table view. The first field reads either open if there is data for that record or new if data is null. When u click open, it opens the Task Detail form. Ive added a form to track Projects to this...
  2. J

    From form to form

    I have a "Problem Report" form with an ID#. On this form I have a control button that opens a "Field Problem Report" form. How do I make the "Field Problem Report" form open and autofill the "Problem Report ID#" field with the Problem Report's ID# so I dont have to enter it manually?
  3. J

    How can i put calculated controls in a query/report?

    I have a form that calculates daily cash register totals. One subtotal is for cash [Cash_Tot], based on quantities of denominations. Second subtotal is a control referencing an embedded subform's footer total for check amounts. Summing both controls give me a daily total. Im trying to...
  4. J

    Showing calculated controls in a query/report

    I use a Daily Cash Register Input form to sum cash and checks that works great daily. How do i get the sum calculated control [Total Cash] and the referenced control to a subform calculated control [Total Checks] to show on a query so that I may do a monthly income report? In short, how do i...
  5. J

    Question DLookup within an IIf()?

    I have 2 Work Order forms that I am trying to pass data with in to. Form 1 is named SPR_frm where: 1. SPR No (ID# for relating) is set to auto-increment. 2. Problem location is entered from a drop down selection combo box control. 3. Problem description is entered in text control. Form 2 is...
Back
Top Bottom