Im new to VB. Im creating a windows application that computes for certain figures which i plan to save and have this information sent to ms access 07. I know how to connect the databases.
My problem is that when i placed in the save command, it doesnt show in acess and the data is turned into a lbl file or something.
this is the code for save:
Dim SaveFileDialog1 As SaveFileDialog = New System.Windows.Forms.SaveFileDialog
.DefaultExt = ".mdb"
.Filter = "access database|*.mdb"
.InitialDirectory = "desktop"
If SaveFileDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then
when i click on save, it tells me if i want to overwrite the changes in access. when i click yes, it does not go into the program but creates another one. when i try to open it, the computer tells me this is a lbl file making it impossible for me to view.
i need to learn how to do this because i will be inputting data on a monthly basis. can someone help me?
pls try to show me an example of explain it in a way that a beginner like myself can understand.
thanks so much.