Recent content by hanarina

I tried this code and the entire subject column is hidden. How to make empty row only to be hidden?

Hi.. I need help with this problem. I tried; If subject.value = "" Then Subject.Visible = False End IF but it didn't work~ Tq...

These two tables have the same field, I separate it so that I can search student detail from table1 only or table2 only (that what my lecture told me to do), then she asked me to add another search button so that she can search from those two table. This is just a simple database to record...

Let say I combined the 2 tables, how can i search student name from intake 1 only? Here is the sample of database I'm working on..

I separate it so that my table wont be so crowded, should i just combine them? Can you guide me how to create the SQL code? I'm not sure how to use it..

Hello, I have a problem with loading student names from two table. I want my cmbobox to view the student name for searching their form. I'm not sure how to give value from 2 table.. Can anyone help me?? Thank You

Thank you for the reply, I already create a separate table for subject and connect both student detail table and subject table. Then I got stuck on what to do next .. mayb my explanation is not clear enough. What I'm trying to do is a list of subjects in the subform is automatically shown once...

Hi... I have this problem that I'm not sure how to do it.. I'm trying to filter a subform using a combobox so that user can key-in data. The subform can only show certain subject(the subject already in there, user dosent have to fill on the subject), and the user only have to enter the point...

Btw how can I make my combo box to view all the name list when non of the option box is selected?

Thank you x3... It work~:D:D

I changed the NAME to StudName but it still didnt work.. Here I attach my dBase..

Guys~ I have this SQL code but I'm not sure what wrong with it. it seems to work but the problem is when i click my combo box, nothing is there(no data at all, I already set the data source). Here is the code Option Compare Database Private Sub Form_Current() On Error Resume Next Dim...

Thanks for responding to my post.. Sorry but I don't understand what you mean by creating a table.. (Sorry I'm a Slow learner) how do I give point only to relevant subject depending on the programme user choose?

Anyone help!! I'm a student and a really beginner with access and never touch VBA before (and sorry if my english is all messy) anyway, I need help with data validation using VBA. I have a form with one subform, in the main form i have a combobox(Programme name) if a certain programme name...