Recent content by DanielBry

Dear Arnelgp and Sneuberg, Really a very big thank you for all your help! :) Best Regards, Daniel

Dear All, It is working perfectly now. :) Please pardon my ignorance. May I seek help on one more thing. When I change the stdid in the student table from number to text. May I know why does the add, delete and edit button stop working with the error "run time error 3464 data type mismatch in...

Hi Sneuberg, Thanks for your help. I will definitely look at the split form. However, as some of the functionality of my access program is already working I will leave it to my enhance version in the near future. I am sorry as I am not getting the problem to the behavior of having an invalid...

I am sorry I missed your post. The exact step I do to encounter the error is as follow. From the program u click on either row from the subform and click edit. The data will be loaded into the text box. Next change the data e.g address and press update. When I select the same row to edit again I...

Dear Sneuberg, Thanks for your help. May I ask is it normal to get the error message Run-Time Error 2452 : "The expression you entered has an invalid reference to the Parent property." when I click on frmStudentSub? Thanks! Best Regards, Daniel

Dear Sneuberg, I have added in the .accdb file. Thanks for any help!

Dear All, I am implementing a access program with the update statement based on the access program from setha.info/docs/ict/msaccess/sourcecode/ict-msaccess-0004[dot]rar (Please replace [dot with .] as i do not have the rights to post url.) From the program u click on either row from the...