Search results

  1. E

    Dynamic Query parameter for pivoted chart

    Hi, I have a Total Query to summarize the count of a field (with the criteria such as Sales Volume by category from Jan-01-10 to date()) and I created a pivoted chart to display the data on a pie-chart. Subsequently, I create another new form and embed the pivot chart as sub-form and few more...
    • espua
    • Thread
    • Replies: 0
    • Forum: Forms
  2. E

    Delete the Last Record but Don't Create a New Record

    Hi all, I want to allow my user to delete the last record (the record he just created) by using a command button with "DoCmd.RunCommand acCmdDelete". However, "acCmdDelete" will move forward to the next record, which in directly created a new record shall the command is perform on the last...
  3. E

    Cascading Form Update

    Hi all, I encounter a problem here. I have a main form (OrderForm) with a subform (OrderDetails). In the OrderDetails subform, I put a [txtSubSumOrder] TextBox at the subform footer to perform the Sum of the OrderDetails. To pass the [txtSubSumOrder] data back to the main OrderForm, I put...
    • espua
    • Thread
    • Replies: 6
    • Forum: Forms
  4. E

    Query that return no. of records in run time

    Hi all, May I know some to construct any functions or query string that can track the no. of records that mean certain criteria in the run time. Basically I want to track the records in a subform (in datasheet view). Should the no. of records is 0, then I can disallow user from saving it onto...
  5. E

    Record Naviagation Tracking

    Hi, How do I track whether the current record is the first record, last record or new records status? I need it to disable some command button in the form. Appreciate your enlightenment !!
  6. E

    Reflecting Changes on the SubForm to Parent Form

    Hi, Scenario: Parent form: An order form (Order table) with data fields like Order ID and etc. In my Order Table, I have a revenue data field, which is a calculated field based on numbers of items in its subform (OrderDetails table). Since the profit data field is based on the items of the...
    • espua
    • Thread
    • Replies: 1
    • Forum: Forms
  7. E

    Writting Data onto Table from Code

    Hi, I wish to explicitly write a value onto a data field upon some events on a form with syntex below Table1.Field1=100 But I'm getting error message saying object is needed. What shall I do?
  8. E

    Display Variable/Constant Value on Text Box

    Hi all, I tried to display a variable and constant onto a text box by putting =myvariable onto the data source of the text box. However, Access seems keep threating my variable as a data field and giving me error message. What to do with this?
Back
Top Bottom