Recent content by PederSpendrup

Sorry but I still get the same error. If I use the same code in the VB for Access 2007 then " T as DAO.Recordset" is the error. As I don´t like to give up I spent the day trying and finally came to the following which appears to work. Just remains to do the rest in the project. Private Sub...

Thank you very much. I have tried the code which in my opinion should work but unfortunately I get the following error message: Compile error userdefined type not defined.Then Dim Db As Database is marked as beeing the error. Have got the same error with other code trials. Peder

My problem is that I can not get this simple code right in VB6. VB6 is in many aspects quite different to VB3.So my problem is to write a code that can add new records to an Access database table. Peder

Years ago I worked a lot with VB3 and databases,no complicated things just very simple and straigt forward. For adding new data I used to use the below VB3 code Dim Db As Database,T as table Set Db = OpenDatabase(" database.mdb" ) Set T=Db.OpenTable("tablename") T.AddNew T ("Field name" )=...