Search results

Stacey did you solve your problem as I have the same problem (First Problem). For second problem: try this = Nameofthesubform.Form!Nameofthetextboxofthesubformfooter Put this in the control source of the text box on the main form. This will bring the total client sum you will have to see if...

Re: Sum a field based on another Field Hallo, I have a subform with two records, Standard_fee and Session. I have the following code on the Subform Footer : =Sum([Standard_fee]) and created a text box on the main form with the control source: =FeeDetails.Form!Total_Amount What this does, it...

Thanks, will try to sort it out further.

Boblarson, Do you mean putting this code in the control source of the new text field on the main form, =[YourSubFormCONTAINERNameHere]![Form]![YourSumTextBoxNameHere] secondly will the total amount be displayed on this field, in the main form. Thanks

That is a logical way of doing it, however, how I want it to work is that when an administrator types in the Fee_amount the total_amount is reflected underneath instantly. With a query it is not that efficient. Is there not a way you can insert a field in a subform on its own / subform footer...

Hi Boblarson, Tried it but never works, the name of my subform containing the footer is FeesDetails and the Sum Text box is called Total_Amount (which is in the Form Footer of the subform) =[FeesDetails]![Form]![Total_Amount] The above code I inserted in the control source of the new text...

Thanks access guy49, managed to solve it. However, I have another problem as outlined below Is there a way of adding a text box on the Form Footer of a subform, find the sum of a field on the subform (fee_Amount) i.e., =Sum([fee_Amount]) and set the default view to Dataset and be able to...

Or maybe because it is access 2003

Re: database Hi Mstef, The database is 2.67 MB size and here it only allows 100kb any ideas thanks

Hallo, Is there a way of adding a text box on the Form Footer of a subform, find the sum of a field on the subform (fee_Amount) i.e., =Sum([fee_Amount]) and set the default view to Dataset and be able to view it when you are in the Form view. Or is there a way around it rather than setting the...

Also, in my subform I have other fields with lists, therefore the continuos form makes the full list displayed then it select the one I did select for the selective record. I dont want that to happen. I want it to be displayed as before + the total amount is there any other way Thanks

When I set the dataset to continuos Forms the entire layout is unpleasant and data is all scattered around. I.e., all the rest of the subform is messy. However, the Total Amount was visible at the end of the form Is there any other way I can still keep the format which i have formulated + the...

Thanks I have sorted it. I have another problem though, I am working with subform too. I want to sum feeamount. I imported a text box on the Form Footer and used the =Sum([Fee]) on the control source. However, when I go on the form view I dont see the text box nor the value. What am doing...

Sorry when am in the Form view not Design view

Hi MStef, Thnaks for the forward mdb. I did exactly as what is shown in the form. In the Form Footer I added a text box and in the control sourse put =Sum([Standard_fee]) but still it never shows up when I am in the design view. The problem is that I can not view the text box when I am in...

Re: Using the SUM function Hallo, This is a really basic question but am new to access. I have a subform which is built up of 3 fields, Payer_code, Session and FeeAmount (these are displayed in a straight line fashion) with drop down of various payer_codes, sessions and fee amounts...

Hi, I have a Subform which is build up of a FEE field, this field is populated with fee amounts from different payers. I have created a query to sum all the amounts and have a total amount. What I want to do is that at the end of the Fee Field in the subform, display the total amount which...

Re: Data Update Hi I am trying to create a pop up box which will highlight some change has been done on a record and at the same time save the date and time it took place. The code is as follows; Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.NewRecord Then If MsgBox("Data will...

Hi Mark, I am new with access do u have an idea what the code will be like.. Really appreciate your help!!! Regards

Hi, I want to automatically update date and time when a record is changed or created. I have a form which is also built with a subform. The code am using is shown below: In the Before Event of the Form I have the following code; If Me.NewRecord Then If MsgBox("Data will be saved, Are you...