I have 3 combo boxes 3 text boxes on
my VB6 FORM. i want to save the
details displayed on the combo boxes
and text boxes to my access database.
can any1 pliz help me out with the
codes
Printable View
I have 3 combo boxes 3 text boxes on
my VB6 FORM. i want to save the
details displayed on the combo boxes
and text boxes to my access database.
can any1 pliz help me out with the
codes
You could start here: http://www.vbforums.com/showthread.php?t=337051
i have checked it out but i wasnt satisfied with the answers. Can you pliz help me out. I need the codes soon because of my project
Well, I'm surprised. The very first Tutorial here: http://www.vbforums.com/showthread.php?t=551154 describes exactly how to do what you want.
I have checked it but it doesnt show me how the "SAVE CODE", can you please make the code for me?
the save code you are looking for is the addnew code inthe example given you do not save to a database you put stuff in it, you add data to the database.
If you donot have a database and need to make one that is a different matter.
If you have one but want to save you information to a new table within it use a variation of the example.
if you are still stuck then we will need musch more information about what you think you need to do, whith what and why and how you have tried so far.
here to help
Yeah i have a database and want to save the data in a table that is inside the database. I used this code(ADODC1.RECORDSET.UPDATE) as the save code but when i clicked the save button nothing was saved. i guess the problem lies within the code!
If you are adding a new record you have to first call the AddNew method of your recordset then you assign values to the fields then you call the update method to update the database.
btw The correct term is "Code" not codes. It does not matter if your code is one line or 1 thousand lines one file or several files it is still Code.
@DataMiser let me put the addnew code then i see how it goes