Results 1 to 8 of 8
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Totals on a form (2002 SP3)

    1) Balance Due and the three Totals controls should be calculated controls, they shouldn't be fields in the table. For example, the Control Source (not the Default Value) for Balance Due should be

    =[AmountPaid]-[AmountOfAccount]

    That way, the control will be updated automatically when the Amount Paid is changed.

    2) Open the form in design view and select View | Tab Order. You can drag controls up and down in the list to change their tab order, or you can click Auto Order to make the tab order strictly across then down.

  2. #2
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals on a form (2002 SP3)

    All those books I read and as usual, you answered my questions in a minute

    Thank you very much!
    Pooja

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals on a form (2002 SP3)

    One additional question if you have the time.

    1. Once the 'Print Receipt' button is pressed, is there some way to automate going to the next record to be inputted without using the 'New Receipt' button. Or maybe have both depressed at once? Just want to make sure I don't have some data compromised in case someone forgets to press the "New Receipt' button. Also perhaps, always have the form open up blank (New Record) when the database if opened up?

    Thanks again.
    Pooja

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Totals on a form (2002 SP3)

    You could add a line to create a new record immediately above Exit_cmdPrintReceipt_Click:

    ...
    RunCommand acCmdRecordsGoToNew

    Exit_cmdPrintReceipt_Click:
    ...

    If you want to open the form to a new record, use the On Load event of the form:

    Private Sub Form_Load()
    RunCommand acCmdRecordsGoToNew
    End Sub

  5. #5
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals on a form (2002 SP3)

    As usual, THANK YOU MUCH!

    Pooja

  6. #6
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Totals on a form (2002 SP3)

    On the attached db, if someone could guide me towards a solution for the following two questions, I'd really appreciate it.

    1. I inputted a calculation in the 'default value' properties for the 'Balance Due' and all the 'Total' fields since I need that information to be displayed. Currently it is not calculating at all.
    2. Very minor thing but if anyone can also let me know how to CHANGE the order of the tabbing (when endusers hit Tab to progress to the next field). The middle area of the form where Quantity, Description, Unit Price, and Total is displayed is currently tabbing down and then across. I need it to go across and then down.

    Thanks much!
    Pooja

  7. #7
    2 Star Lounger
    Join Date
    Oct 2003
    Location
    New York, New York, USA
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals on a form (2002 SP3)

    I'm getting a #Name? error when I ue the Expression Builder to set the Control Source to the product of 2 fields. Why? I'm trying to set a thrid fireld = to theproduct tf 2 other fields.
    =TestOrders!Price*TestOrders!Count
    Thanks in advance.
    Mark

  8. #8
    2 Star Lounger
    Join Date
    Oct 2003
    Location
    New York, New York, USA
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals on a form (2002 SP3)

    I figured it out. I needed to scroll a little further down in the Expression list and use Form!field name

    Mark

Posting Permissions

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