Search results

Ok @isladogs I will post the macro when my PC come alive. But what I want to do is to be able to populate one form through two source, one being combobox and the other from manually entering the value, Is there any way I can do that? I really appreciate if anyone can help.

Hello guys am pretty new in access as well as VB. Please I need help again. I populated my textboxes in form using [combobox].[column](1) in the control source of each text box and it works like magic but now the problem is that I can't edit that same to inputs remotely. It seem the combo box...

Thanks guys I really appreciate you efforts in finding solution to my question. I just discovered a simplest way to do that using macro instead of VB codes.

[CurrentDB.Execute "INSERT INTO childDetails(SurName, OtherNames, DateOfBirth, PlaceOfBirth, Gender, StateOfOrigin, LGA, Attachment, PreviousSchool)" _ & " values('" & Me.txtSurName & "' ,'" & Me.txtOtherName & "','" & Me.txtDateOfBirht & "', '" & Me.txtDateOfBirht & "', '" & Me.cmbGender &...

It highlighted Me.txtLGA @cliff67 before it was Me.Surname as I tried debugging it it now jump to Me.LGA. I noticed that the values appears in the table childDeail but anytime I changed it override the previous one instead of inserting.

Thanks allot @cliff67 and @James Dickinson. Your code seems to have worked only that am have Compile error while running the code the heading of the error is "Method or data member not found" while highlighting me.LGA in the code. I have checked my forms as well as the reference table to make...

Here is the code I used. Private Sub cmdSave_Click() 'add data to table CurrentDb.Execute "INSERT INTO childDetails(SurName, OtherNames, DateOfBirth, PlaceOfBirth, Gender, StateOfOrigin, LGA, Attachment, PreviousSchool) " & _ " values(" & Me.txtSurName & ",'" & Me.txtOtherName & "','" & _...

Yes I know that method, but I want to use button to insert the data, My problem is programming the botton, I tried using INSERT INTO function but it not working

Working on my first database in access but encounter problem feeding data to table using forms. I have tried a couple of methods but it not giving me what I want, any idea on how to go about it. Looking forward to hearing from you guys. Thanks

Hi everyone, am Idforgod by Name a Civil Engineer from Nigeria who derive joy in working with Ms packages with keen interest in programming, Presently working with Access. Looking forward for making a great hook up here.