i have created 2 tables name table1 and table2 with the same fieldnames in subjectnumber(sub-0001), subjectname(english1) but in my table2 i added studentnumber(s-0001) and studentname(paul)
im using dataenvironment in connecting my (table1) ms access 2007 database in a datagrid but my problem is how to save and add all information bind(table1) in datagrid into another database table2 in my ms access, i want to connect what is inside my datagrid (table1) and add to (table2)
i mean using dataenvironment i bind table1 to a datagrid1(table1) so i want all information bind in datagrid1 to add and save into table2 database in just 1 commandbutton click in vb6.
I have 2 forms in vb6, form1 only the subjectsnum & name connect into a datagrid. however, in form2 it is the same but i added the studentnum and name textboxes but the subjects likewise are in a datagrid connect in dataenvironment. i want to save all information in the datagrid as well as the student number/name in the textbixes in just 1 command button, click SAVE, in vb6..
hope you understand my problem and FOR FREE...
thanks in advance....GOD bless...
Below i attach my form2 problem. saving all information in a datagrid in just a single commandbutton click and it will automatically save all inside the datagrid.
and also the studentnum and name will also save.