| | |
how to insert records into a table using datacontrol
![]() |
•
•
Join Date: Jan 2008
Posts: 2
Reputation:
Solved Threads: 0
Hello,
I'm very new to visual basic ver 5.00 . and I need help please.
I have ms access '97 database with three tables. I created a form using form wizard , and it has a data control included. How do I enter data through the datacontrol to my tables in the database.
I would also like to delete ,edit , add records to the table at a later stage
I'm very new to visual basic ver 5.00 . and I need help please.
I have ms access '97 database with three tables. I created a form using form wizard , and it has a data control included. How do I enter data through the datacontrol to my tables in the database.
I would also like to delete ,edit , add records to the table at a later stage
VB5 and Access 97 - WOW.
There are a few of ways to access the data bases (I've only worked in VB6, but I assume that it will work for 97 - I'm sure someone will correct me if I am wrong)
The main options that you have available ADO and DAO, ODBC - I've only used DAO (jet).
But what ever one you choose, you will need to tell Vb what one you are using by going to the references section and selecting it.
Here is a good link that explains them and provides some sample code
http://www.vbexplorer.com/VBExplorer...er_ADO_DAO.asp
There are a few of ways to access the data bases (I've only worked in VB6, but I assume that it will work for 97 - I'm sure someone will correct me if I am wrong)
The main options that you have available ADO and DAO, ODBC - I've only used DAO (jet).
But what ever one you choose, you will need to tell Vb what one you are using by going to the references section and selecting it.
Here is a good link that explains them and provides some sample code
http://www.vbexplorer.com/VBExplorer...er_ADO_DAO.asp
Last edited by bushman_222; Jan 28th, 2008 at 7:08 am.
•
•
Join Date: Jan 2008
Posts: 2
Reputation:
Solved Threads: 0
•
•
•
•
VB5 and Access 97 - WOW.
There are a few of ways to access the data bases (I've only worked in VB6, but I assume that it will work for 97 - I'm sure someone will correct me if I am wrong)
The main options that you have available ADO and DAO, ODBC - I've only used DAO (jet).
But what ever one you choose, you will need to tell Vb what one you are using by going to the references section and selecting it.
Here is a good link that explains them and provides some sample code
http://www.vbexplorer.com/VBExplorer...er_ADO_DAO.asp
Hello bushman,
thanks for your timely reply. I am aware of ado and dao. But not all that familiar with the use of data control. I created a simple form in vb , with data control, and tried to run it. I keep gettting the error 'Function or interface markedas restricted or the function uses an Automation type , not suppoerted in Visula Basic.""
I can't seem to under stand what the error could be. I have decalred the data base name and recordsource in the form properites.
Also ,another question...
If I have developed an application in windows in vb ver 5.oo, can I post that application on a web site , and get users to access the application by logging into the website, or would I have to develop the application again using Web forms (ASp.NET)
Any suggestion would be helpful
![]() |
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: how to drag and move image
- Next Thread: searching help part 2..
Views: 4235 | Replies: 3
| Thread Tools | Search this Thread |
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 access activex add age append application basic beginner birth bmp box c++ calculator cd click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f database datareport date delete desktop dissertationtopic edit error excel filename filter form game header iamthwee ide image inboxinvb keypress listbox listview liveperson login looping machine mail match metadata microsoft movingranges number objectinsert open oracle os password picture pos prime print program range reading refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort spectateswamp sql sql2008 sqlserver subroutine table tags textbox urldownloadtofile variable vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





