Search results

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...

Hi RG, Yes, it works, I just need to explicitly set the "Allow Additions" property to False before perform the deletion. Thank you so much ..............

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...

hi RG, Thanks !! I have got the problem solved !!

Hi RG, Thanks so much for your advice, that's exactly the problem I'm facing. By the way, how does the Synchronize routine in the Parent Form looks like? How do it force the Parent text box to reflect the changes that made by the subform?

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...

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...

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 !!

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...

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?

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?