Recent content by pochta

Thanks! I'm not an expert yet but with your help I have a solution to the problem. Thanks again!

Golom, That makes sense. Can you give me a little detail on how to do it. It looks like all that is happening here is that SQL statements are being passed to Access. Surely it is not a big deal if you get the syntax right. Perhaps my approach is wrong. Is there a better way?

I posted this earlier as a failure to update. Actually it does UPDATE the field in Access but it generates an error message. Global Adodc1 As Object Public Sub PokeAccess() frmSqlTest.Adodc1.CommandType = adCmdUnknown frmSqlTest.Adodc1.RecordSource = "UPDATE Test1 SET Test1.Number=1234...

Thanks for the help but all of the suggestions result in either compile time or run time errors in VB6. I have narrowed the problem and can restate it. Here is the code using the Adodc1 for the connection link: Global Adodc1 As Object Public Sub PokeAccess() frmSqlTest.Adodc1.CommandType =...

I have been using VB6 to read data from Access. Now I want to write into the data base. I have set up a simple table with fields to test: ID Name Number Mark I have populated 5 records with random contents. In VB6 I have a form with one Command Button and one Text Box. The Text Box is bound to...

vbajock, Thanks. lnkData is the name of an Adodc tool that is connected to the access table. It is the same tool used for the SELECT statement. Tried Execute and got the 'method or data member not found' error message. The term execute is not in the VB help index and the word does not appear...

I have been using VB6 to read data from Access. Now I want to write into the data base. I have set up a simple table with fields to test: ID Name Number Mark I have populated 5 records with random contents. In VB6 I have a form with one Command Button and one Text Box. The Text Box is bound to...