How to Save Visual Basic Data with Access or Oracle through Data Control or ODBC

  • Thread starter Thread starter Mohsin
  • Start date Start date
M

Mohsin

Hi Every one( Good Day)
Any one can help me to save visual Basic Data in Access to make link
through Data control or ODBC. when i am trying to save vb data in
Access after making link through data control it is not saving what is
reason i donot know.
suppose i made one table in access and save in my Document and design a
form in vb with same data field and make a link through data control
properties so what will i write on save button to save those data in
access table.
i will appreciate to any one who will help me on this topic
thanks in advance
 
Mohsin said:
Hi Every one( Good Day)
Any one can help me to save visual Basic Data in Access to make link
through Data control or ODBC. when i am trying to save vb data in
Access after making link through data control it is not saving what is
reason i donot know.
suppose i made one table in access and save in my Document and design a
form in vb with same data field and make a link through data control
properties so what will i write on save button to save those data in
access table.
i will appreciate to any one who will help me on this topic
thanks in advance
Click to expand...

Good Day to you also,

Do you mean you are using stand-alone VB to interface to the Access
database?

The single example I have from some old code looks something like this:

Private Sub cmdSave_Click()
ConnectionObject.Recordset.Update
End Sub

This is assuming you have an ADODC object on the same form called
ConnectionObject that handles the link to the database.

HTH
 
Good Morning to All

indeed many thanks for your prompt response apropos my question.

as every body knows that visual basic is graphic user interface.
suppose, i am going to make a simple programme for two Numbers
Calculation. i designed a Form in visual basic to enter the data .

1st text box is Enter the 1st number. ( textbox name is T1)
2nd text box is Enter the 2nd number.( textbox name is T2)
3rd text box is total.( textbox name is T3)

made two buttons which are SAVE & EXIT (name is save and EXIT)

if i will enter data in textbox T1 & T2 and click on SAVE button then
it will make calculation of two numbers whatever user will enter in
aforesaid textbox and should be save in Access table.

To save the data in Access table i have to make a table in access ,
isn't it.
i made one table in access with the name of calculation and data field
is First_Number, Second_Number and Total and saved this access file in
my document Folder.

first of all to make a link between access table and visual basic form
what will i do,

i think i have to make link through data control and ODBC. is it right.
but when i make a link thourgh this. it shows errors hence please let
me know the full procedure how will i make link access table with VB
form both way and what will i write on SAVE button to save this data in
Access Table.

on save_button _click_event

T3.text=val(T1.text)+val(T2.text)--to Calculate the data



i do hope that my query is obvios now and every body can realize that
what am i facing problem to this data in access Table.

your cooperation on this regard will be highly appreciated.

Regards
Mohsin
 
Back
Top