Search results

because it is required for my project :(

Hi, sorry for my late response, because I've been so busy these last days, by the way, this is my codes for combo box and textbox.... Private Sub Combo3_AfterUpdate() Set rst = db.OpenRecordset("SELECT * FROM StudentsProfile WHERE StudentsID= '" & Me.Combo3 & "'", dbOpenDynaset)...

yes, for example I choose 23011 as an StudentsID in combo box, and below that combo box I have 3 textboxes which it'll automatically populates the Name, Age and Gender of that student(I don't have any problem with that), and below the textboxes, the rest of the student profile (such as course...

Course, Year Level, and Subjects Enrolled

Hi ! I have a form with combo box and list box. I am able to choose StudentsID on my combo box, and whatever the studentsId i choose, it should be automatically display the profile of that student in list box...is it possible? Do I need to use .Rowsource ? Thanks in advance.

Oh I get it, thank you sooo much for helping me :)

Like this? Dim strFirstName As String = "Angela" Dim strMiddleName As String = "Panda" Dim strLastName As String = "Moore" But I shouldn't be the one who is inputting the names, it should read the value in my tables and display it on one of my textbox in form. :(

hi! I have a table with field names StudentsID, FirstName, MiddleName, LastName,Course,Address I created a form with combo box that when you choose any of the StudentsID, it will automatically populates the other textboxes (such as Name,Course,Address). My problem is, I need to combine the 3...

I just upgraded the question, because the questions I've been asking yesterday is not that clear, so I decided to revise it and attached a picture in it....

Hi friends! Need your help... I have two forms, named frmStudents and frmSubjects, in frmStudents I have my combo box which I can choose StudentID, and I created command button which I named it OPEN, and when I click the OPEN, the frmSubjects pop-ups, so here's the problem, when I choose 201 in...

i have a form with 10 textboxes....one of them is for search item... I am not using combo box nor list box, i need to type every first letter of the item, and it should gives me predicted words which included on my lists of items... please, any help would be appriciated THANKS God bless

forms with 10 textboxes and 1 combo box, in combo box, i can choose the name listed on my table and automatically shows up the profile of that person, but it shouldn't be editable...should I declare it false? but what is the right code for that? I used this code Me.gender.Enabled = False but...

on my form, i created command button named RESET, i already tried the wizard which is undo and reset form, but any of these are giving me such an headache error.

I created 2 forms, on my frm1 i have combo box and in frm2 its just textbox. and everytime i choose a value from that combo box, it should be automatomatically displays the value on one of my textbox in frm2 any help would be appreciated.... thanks

i need to pass the value from a combo box to another form(textbox) I already try DoCmd.OpenForm "SecondFormName", , , "FieldName = " & Me.ControlName it opens the another form but it does not automatically display the combo box value in my 2ndform... would someone help me? THANKS in advance

guys I have declared a field name with a criteria of autonumber. And I created a form including the field name with autonmuber. But everytime i run it, it gives me error, any help would be appriciated...

Opening another form using command button?

sorry for flooding out:(

Oh jeez, thank you sooooo much

Please :( Please I'm begging to all experts or to anyone who can help me. I've been figuring this for almost a couple of days and until now, and I need to pass it tomorrow on my instructor. I'm not good in VBA access codes so please be specific. I have a 2 forms, I have a combo box in form 1...