Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Refresh causes error message
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...- pochta
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
How do I UPDATE a field in Access
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...- pochta
- Thread
- Replies: 8
- Forum: Visual Basic (Classic)
-
Update runs without error - does not update
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...- pochta
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
