Recent content by eujeong

Thank you for your quick response.:) problem 1 : I was hurry when I wrote my posting. All the name is starting with 'student'. I double checked my code again. Then what do need to do next? problem 2 : could you give me any example of code for this function? I have no idea what I need to put...

HI, all. I have problems in my form. Please advise for me. I have a combobox which has 3 fields: StudentID(column 0), StudntName (column 1), StudentAddress (column 2). When I put studnetID, if it is in the list then it's name and address fields are automatically filled (It works.). If the ID...

Thank you for your quick response. I read the posting that you linked. However, I still don't understand why it returns numbers. yes... I am a novice on Access.:banghead: Let me explain more detail. I made : tblDepartment, tblDivision, tblStudent ( it includes department and division field. if i...

I would like to store the string in my table when I choose a string from a combobox or radio button in the form. For example, if I choose 'Business' ( from major field in my department table ) in my combobox, I expect there is a 'Business' in my major field in my department table. And if I click...

Thanks a lot!!! I will try to remove the redundancy. However I still don't know how to use SQL (JOIN ?). Could you please explain how to write the SQL code(?) for my case?:o

Hi, I am a novice in Access World. I need a help. What I need to do is updating a table from a form. I have two tables. tblStudent and tblRegister tblStudent: StdName, StdID(PK), StdAddress, StdPhone, StdMajor tblRegister: RegID(autonumber, PK), StdID, StdName, StdAddress, Course...