Visual basic 6 .. create a database and store data in

[PipingUnat]

tnx man it was very helpful..^__^

[praxalshah]

Thnq..:)

[Mikail601]

mohammed the cyberterrorist Thumbs up xD

[cpj28jan]

thanks sr...help me for the datagrid connection with database...

[PleaseNotAgain1]

Hey there, thanks alot :D Now, is there any way to add an image to a field?

[sathishc89]

HEY MAN YOU ARE MY ROLL MODEL THIS IS WHAT I AM SEARCHING THANKS A LOT MAN...................

[markili14]

AMAZING!!!!!!!!!!!! 

[qasimesmail9]

good video!!

[iceleon25]

Thanks a lot dude :) helped me on my report :)

[XsNiPeRxXz]

I don't see haters! Good video!

[raiheart23]

instead of I'm gonna

[raiheart23]

I'm gonna to!!!

[yatz14ify]

this is helpful ,,thanks to you sir!!

[cybertrancer]

Thanks bro, maybe this will help me to pass exam at uni hihi ^_^

[msrs0ft]

@cybertrancer im glad to hear that :)

[ThePassel]

@cybertrancer Lol, I am like pro coder, I can do databases and others and ur in university and you can't lool

[cybertrancer]

@ThePassel Quiet noob

[1mechatronics]

Look msrs0ft I didn’t find words for thanking you. This 15 min saved my soul.

My company attended to fire me because something related to this subject , I wish I can describe my happiness now. Really THANK YOU

[msrs0ft]

@1mechatronics my pleasure Sir

[msrs0ft]

@1mechatronics dont say any ,,, its ok

u r welcome

and its pleasure to help

[ramiz1116]

@msrs0ft dude how do you create the same database in VB 2008. because 2008 has not got add on option

[SeRgA123456789]

HELL YEAH THX SO MUCH!!!!!!!!! this is GREAT thing for my movie that im planing to do with my friends!!!!!! thx so MUCH!!!

[VenturaPaul]

thank you from Peruuuuuuuuuuuu ooh!! XD

[msrs0ft]

@VenturaPaul u r so welcome from egypt ; and i thinkthat im going to earn a new friend from peru :D

[zubair4685]

Goood work my friend

[msrs0ft]

@zubair4685  thnx alot , just hope to help

[starcatcher164]

hi can you help me about puting a unique record in a field. Like the student #, it must only be inputed once, and when it is input again a message box will appear sayin "message box already exist"? can you give me the code pls.?

[msrs0ft]

1st is to open the database with access and make a primary key for the field you want and it will never store a record twice .. but you have to write on your code that "

on error resume next"

as an error handler

other way :-

[msrs0ft]

"""""---------------------CODE­------------------" On Error Resume Next If Adodc1.Recordset.RecordCount = 0 Then Adodc1.Recordset.AddNew Adodc1.Recordset.Fields!Name = txtname.Text Adodc1.Recordset.Update Else Dim Count As Integer For Count = 0 To Adodc1.Recordset.RecordCount If Adodc1.Recordset.Fields!Name = txtname.Text Then If MsgBox("This value is exists . do you want to remove it and add the new?",

[msrs0ft]

vbOKCancel) = vbOK Then Adodc1.Recordset.AddNew Adodc1.Recordset.Fields!Name = txtname.Text Adodc1.Recordset.Update Exit For End If Else Adodc1.Recordset.MoveNext End If Next End If """"

[starcatcher164]

@msrs0ft  thanks

[msrs0ft]

@starcatcher164

With pleasure ....

[msrs0ft]

@starcatcher164

You are welcome :)