Search results

Re: Populate a field in a subform Hallo, I have a subform called FeesDetails. This subform is made up of a table called FeeDetail which is built up of 5 fields , Payer_code, Fee_Amount, Session, Payer_name and Payer_address. Payer_code is also a list box containing all the payer_codes...

Thnak for you reply. The only problem is that I will have hundreds of payer_codes and payer_names. Will it be applicable and do u now the afterevent code. Thanks

Hi , I have a subform, which is build up of 3 fields Payer_code, Fee_Amount, and Payer_Name. The name of the subform is FeesDetails. I have a drop down list for the Payer_code with a list of all the payer codes. What I want to do is when I select or populate the Payer_code, the Payer_Name is...

Hi there, I have a form which is also build up with a subform. The form has four fields student_ID, Surname, Forename, and Numhus. The subform is build up of module and mark fields. The problem is when I update any field on the subform (i.e., module or mark) the information is updated...

Re: Two Subforms on a Form Hi there, I have a form [StudentDetails] and two subforms [FeesDetails] and [PayersDetails]. I have a Relationship for the main form [StudentDetails] and [FeesDetails]subform, whereby when the Student_ID is the same the FeesDetails text fields are populated on the...

Re: Data transfer from Combo Box of one form to Subform of another Hi, I have a form build up with a subform in access 2003. Then I have an Insert button on this form which when clicked opens another form which is build up with a combo box. Now, when I select a field for example (Student_ID)...

Re: Combo Box Hi, I have a combo box, however, the combo box when ever I call it up it remembers the previous data typed in. I tried to re-create it when I was given the option remember the last data I checked the check box because the only other option was to save the data retrieved to a...

Re: Combo Box Hi, I have a combo box, however, the combo box when ever I call it up it remembers the previous data typed in. I tried to re-create it when I was given the option remember the last data I checked the check box because the only other option was to save the data retrieved to a...

Re: Pop up box Hi, I am working with Access 2003 database. I have a form which am intending to insert a "insert button" to find the details of a Student, such as address and name. I will have thousand of students. The idea is to have a button to click and give you a small pop up page with the...

Re: Pop up box Hi, I am working with Access 2003 database. I have a form which am intending to insert a "insert button" to find the details of a Student, such as address and name. I will have thousand of students. The idea is to have a button to click and give you a small pop up page with the...

Hallo, I have developed an access database for students data. My next task is to create a username/password for various administrators who will logg on to add, delete or update the records. I am using Access 2003, any suggestions as to how I can go about this task? Thank you in advance

Hi, I have created a simple student access database. I have a form which displays the student details and a subform which displays tuition fees status. I would like to add the payer's address on the subform mainly because it will link with the other details in the sub form, such as Payer's...

Thank you guys, it is working now. Many thanks to boblarson, you are a star!!!!!

The Recordsource for the form is StudentDetails and for the subform is FeesDetails I have created a form with 4 fields Student_Id, Surname, Forename, AOS_Code, NumHus (Stored in Student Details) with a subform built up of the Payer Code, Payer Name, Details, Amount (Stored in FeeDetais). Then...

Hi, It doesnt display the date and time when a change is made on the subform. Sorry for not being clear in the initial statement Thanks

date/time update Thank you for your suggestions, I tried to add the same code in the subform control before Event update and after Event update. No luck!!! what wrong am I doing ? Many thanks

I have a form which is also build with a subform. In the form I add the date and time when a record is changed to a respective table in the database. So that, when the next administrator logs in he can see when the form was last updated. I used the following code: Private Sub...

Hi statsman, I did as you said, however, when I retrieved that data. The changes on the subform took effect, but the date and time was not updated even after refreshing the subform. The effect will always take place (change in date and time), when the change is done on the Form NOT subform...

Hi all, I have a form which is also build with a subform. In the form I add the date and time when a record is changed/added to a respective table in the database. So that, when the next administrator logs in he/she can see when the form was last updated. I used the following code: Private...