[Resolved]Adding to Databases

Hi Everybody,

I am currently a college student who has only been developing with VB for a short time and just trying to get my head around certain things. I've added items to a database using VB "Within" Microsoft Access, although i have yet to implement this feature using Visual Basic 6.

What i am planning to do is to make a kind of account creation system within my application. I am using a Data Control to define my database and i want to add data to four fields in my database.

So quickly done below is the form that will be used to collect the data required and then on the click of a button it will add itself to the database i specify. (Re-enter Password is mainly put for validation purposes)
http://www.anolofy.co.uk/Leigh/fields.JPG

I have been testing out coding such as using the Addnew function etc, but i just can't seem to get my head around it. Any help would be seriously beneficial to me :)

Many Kind thanks in advance
Leigh

Welcome to the forums. :wave:

Post the .AddNew code that you have that isn't working.

Thanks for the welcome! :D Looks like i'll be around here often the way i'm going on! lol

datDatabase.Recordset.AddNew
datDatabase.Recordset!First_Name = txt_Regfirstname
datDatabase.Recordset!Surname = txt_Regsurname
datDatabase.Recordset!Username = txt_RegID
datDatabase.Recordset!Password = txt_RegPass

The above may be entirely incorrect because our tutor didn't really go into any detail on how to add through VB6, i've just tried to understand what's been on websites.

VB Code:

datDatabase.Recordset.AddNew
datDatabase.Recordset!First_Name = txt_Regfirstname
datDatabase.Recordset!Surname = txt_Regsurname
datDatabase.Recordset!Username = txt_RegID
datDatabase.Recordset!Password = txt_RegPass
datDatabase.Recordset.Update '[b]add this line[/b]

ah, works like a charm now! :) Thanks a lot! :)

Quote:

---

Originally Posted by Leigh

ah, works like a charm now! :) Thanks a lot! :)

---

No problem and good luck on your project. :thumb: