Search results

This is the solution form Bob Larsonfor other viewers Well, that did help. The code should be this instead: strSQL = "Insert INTO tbl_name (firstname, lastname) values('" & Sheet1.TextBox1.Text & "', '" & Sheet1.TextBox2.Text & "')" Best of luck

Thanks a lot boblarson. You are great. You have solved my problem. I was going nuts where the error is. I give you 5 star out of 5. Thanks a lot.

Ok i am uploading zip format of my original excel file.

Ok i will upload the copy of excel file and access file so that you can test it out what is wrong with it. My excel file has xlsm format but i have saved it as xls format due to format restriction in the forum upload. Hope it will help you in finding the error. Thanks in advance

Yes my ms access database table name is tbl_name and has two fields i.e firstname and lastname. I have attached an image of database in design view to give u an idea. When i open the excel file, it give me security warning, that some active content has been disabled. By pressing option button...

I have checked the text boxes name and they are correct. I am attaching the error jpg it may help.

I have uploaded two jpg file to have an idea of the error. This is a test project. I have to make the project later on when it is successful. The excelproject.jpg file shows the highlighted line where the error occured.

Hi Bob larson, I have tested your code. First I have saved the excel file with new name. Then i deleted the old code from vba and put your new code. I have referenced DAO (Microsoft Office 12 Access Database Engine Object Library). When i ran the code it gave following error. Run-time error...

Thanks Bob larson, I will apply your code and see if it works. I hope it will work. I will get back when i test the code. Thank you again for the help Best Regards Arshad

I am facing same problem. I have a form with two text boxes and a button to send the data into a ms access table. I am getting "Run-time error" object required. My code is as follows. Dim con As New ADODB.Connection Dim connectionString As String Dim sql As String connectionString =...