Search results

Thanks, What do u mean as underlying query in the next form. My first form its primary key is Numhus and I have the same field on the second form, however, it is only in the table of the second form because of the relationship to exist, right!!! Should I also make Numhus primary key in the...

Hi, How can you create a relationship between two forms, so that when the main form displays a record, details of the same student_id can be viewed in the second form. any sample databases will be appreciated.

Hallo, I have a subform which comprises of a field called standard_fee (contains the amount of fees) and Session (contains the session period example 2003/04, 2005/06). A student record might have three Sessions per record for example 2003/04, 2003/04 and 2004/05. Therefore what I want to...

Hallo, I have a subform which is built up of a field called Session (this field has values such as 02/03, 03/04, 05/06, 06/07 etc) For a specific record you might have 2 or 3 similar values i.e., 02/03, 02/03, 05/06, 05/06, 05/06, 06/07. I have this code on OnClick event which moves from one...

Its ok JEA, I took it on a positive perspective. Thanks for being considerate..... Lovely Christmas, Cheers!!!

Thanks Boblarson

Thanks JEA I'll try my best to learn

Thank you Boblarson, Is the database crap, please tell me how I can improve it. I am new to Access... Secondly, I tried to put the code shown below on the checkbox After event. When I am in Form view and check or uncheck the box, the textbox is blank. It does not bring forward the date and...

There we go JEA Thanks

Date/Time upload Thanks for your response.. Do I put it on the BeforeUpdate of the main form?Because if i do so it still changes when a different field on the form is changed. It should only be changed when the Checkbox is updated. Any ideas

Hallo, On my main form I have a text box which saves the date and time after an update. The code I use is shown below Me.txtlastupdated = Now() tstlastupdated is the name of the text box which displays the date and time. Therefore, when any field is updated the date and time is saved. Now...

Come on Someone should tackle this, please!!!

Hi, I have a subform called FeeDetails, with one of the field called Session. Session has values as 2005/06, 2006/07, 2008/09 etc. A record on the form may have many Session values i.e., 2005/06, 2006/07 etc. I have a button which if clicked moves between the values i.e., 2005/06...

Hallo, I a main form called StudentDetails1, and a subform called FeeDetails and a field within the subform called Session. I have a button on the main form and a text box which displays the record stored in the field (Sesion) and you can go foward and backward by pressing the buttons on the...

Boblarson, I have given it a re-thought and I want it to do the following, if I am done with this I'll surely have a beautiful Christmas..... 1) I have two buttons as shown on the attachment, forward and backward buttons. And I have a session label, the text box on the main form of the...

The subform is not a dat entry but can act as one when needed. Some fields act as data entry fields. Secondly, I set the subform as blank when the main form opens so that you can either find a record or start with the first record. Please find the abopve attached specimen, for clarity many...

I have a student table and fees details subform. I have a textbox (textsession1) on the subform footer and on the control source =[Session] Then I have a text box on the main form which has the control source =FeeDetails.Form!txtsession1 What is happening is that when I am in arecord it...

Hallo, I have a subform called FeeDetails, which is build up of various fields, Payer_code, Session, Amount. This is build- up on a main form (StudentDetails). I have a text box on the subform footer called txtsession1 on its control source I have =[Session]. Then I have a text box on the...

Hallo, I have a subform called FeeDetails, which is build up of various fields, Payer_code, Session, Amount. This is build- up on a main form (StudentDetails). I have a text box on the subform footer called txtsession1 on its control source I have =[Session]. Then I have a text box on the...

** Or are you going to be looking at Fee records based on the SESSION, and NOT the studentID that is associated? Yes thats what I want to do. What I have done is create a text box on the subform footer and called it txtsession1 in the control source added =[Session] Then on the text box near...