Dear Members
I have written a program whose intention is to track fee payment by students in a school. the program is intended to track as many students as possible. My program works very well and it is linked to a database (Access 2003). I can move from one document to the next or previouse, I can exit, enter new records and even delet. the codes are working very well. however after many entris have been done, it becomes to tidious to move literally from one document to another while looking for a specific record that May need to enter more information or edit. I therefore added to more items on my program the 1st is a text box and the 2nd a command button. I intend to enter the admision number of a student in the text box and then click on the command button which I have named cmdSearch. My expectation is that, when the above is done, the program should immediately locate and display the student whose admision number is the same as that entered in the text box. In fact I am looking for a way to very quickly search or find records in a database using VB 6.0 Enterprise edition. The student admision Number in the database is the primary key and is unique - no repitation, my database is named ULANDA and the table name is STUDENT. Please help me write the code to command by text box (which is named text38) and my command button (cmdSearch) urgently to accomplish what I want. My program is invalid without this very useful item. Thanks in advance
I have written a program whose intention is to track fee payment by students in a school. the program is intended to track as many students as possible. My program works very well and it is linked to a database (Access 2003). I can move from one document to the next or previouse, I can exit, enter new records and even delet. the codes are working very well. however after many entris have been done, it becomes to tidious to move literally from one document to another while looking for a specific record that May need to enter more information or edit. I therefore added to more items on my program the 1st is a text box and the 2nd a command button. I intend to enter the admision number of a student in the text box and then click on the command button which I have named cmdSearch. My expectation is that, when the above is done, the program should immediately locate and display the student whose admision number is the same as that entered in the text box. In fact I am looking for a way to very quickly search or find records in a database using VB 6.0 Enterprise edition. The student admision Number in the database is the primary key and is unique - no repitation, my database is named ULANDA and the table name is STUDENT. Please help me write the code to command by text box (which is named text38) and my command button (cmdSearch) urgently to accomplish what I want. My program is invalid without this very useful item. Thanks in advance