Search results

I connected the table using the HESA, because it is unique for each student and a Student might have many HESA values not one, at any one time. The Student_ID is also unique, but I never also set it as Primary key on the StudentDetails because there is a possibility that a student will have...

Nop, what I want is display the record as normal, Then use the "Play" button to display Session i.e., 03/04, 04/05, 05/06 etc depending on what is on the subform, at that time for that particular record. For Example for Student_Id: HUL555 I want when you click the button it gives 05/06, then...

Adam , please see a sample attached. Note: The button is just below the Upload and the Session on this database are in a different format 02/03, 03/04, 05/06 etc Thank you!!!

I have a subform built with 5 fields one of the field is called Session (this field has a drop list of the study year) therefore 2006/07, 2007/08, 2008/09 etc. I just want to navigate on this Session, so that when I click the button it takes me from one field of the Session to another...

Yes, both the two replies are correct. By default access 2000 will automatically bring it the first value as per the typed value.

Hallo, I have this code which moves from one record to another. Is there a way I can modify it so that it can only naviagte from a field in a subform when clicked. The field name is called Session (which is built up of many Sessions 2003/04, 2004/05, 2005/06 etc). Also incase there are two...

Hallo, I have a Session field on a subform. The Session are for example, 2006/07, 2007/08, 2008/09 etc. I have two buttons on the main form, what I want to do is, 1) When I am on a record of a student be able to click the buttons to go to the next or previous Sessions (on the subform) for...

Mstef I am working with access 2003 will you be able to open it ? Thanks

Hallo, I have a Form built with a subform. The subform has two fields 1) Standard_fee - displays the fees paid at various sessions 2) Session - which year of study i.e., 2006/07, 2007/08, 2008/09 I want to sum the fees per record depending on the session of study. This is mainly because for...

Re: Sum of a field based on another field Hallo, I have a Form built with a subform. The subform has two fields 1) Standard_fee - displays the fees paid at various sessions 2) Session - which year of study i.e., 2006/07, 2007/08, 2008/09 I want to sum the fees per record depending on the...

Ok, Thanks Boblarson... Much appreciated enjoy you weekend

Boblarson, It is not right because i want the total fee per session it should ONLY add for 07/08 only, and give me the sum rather than adding the whole fee amounts. For Example for Student Id : HUL555 it should display only 8,476 for the session of 07/08 rather than 90,990. You get me...

Re: Boblarson, Note, the Form is called StudentDetails1.. Thanks

I havent got the question right but what it is that I have list box years i.e., 2006/07, 2007/08, 2008/09 etc. Therefore, a student can have differnet payers such as sponsors etc who will pay his/her fees during the years of study. Therefore, we may have 2 payers in 2006/07, 3 payers in...

The session is on the fourth column where I put down the code below (assuming it starts from (0)), =DSum("[Standard_fee]","FeeDetails","Session='" & Me.Session.Column(3) & "'") The #Name? is still popping up.... Surprisingly when we had...

It still doesn't work The name of the text box on the main form where the data is displayed is called txtAmnt, The text box at the subform footer where the DSum function is done is called Total_Amount The list box that shows all the years ie., 2005/06, 2006/07, 2007/08 is called Session So...

When I put the code and I am in the Form view it gives me the following on the text box #Name? Now, the amount has disappeared.... Any reason? Thanks

Boblarson, Any suggestions of how to change the criteria please table name is = FeeDetails Field the amount of fees are stored = Standard_fee Field that contains the different sessions (2005/06,2006/07,2007,08 etc) = Session Thank you

Hi KeithG, Tried it it gives me a value £210,503.00 and never changes again, even if i go to another record. The value is fixed and get dispalyed permanently which is wrong anyway..... any suggestions

Help!!! What's wrong with this code: =DSum("[Standard_fee]","FeeDetails","Session=2007/08") When I put this code in the control source the result is blank, without any error. What am doing is to sum the fees per session (2007/08) and display the result for that session Any...