943,923 Members | Top Members by Rank

Ad:
Jan 28th, 2008
0

how to insert records into a table using datacontrol

Expand Post »
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
newvbee is offline Offline
2 posts
since Jan 2008
Jan 28th, 2008
0

Re: how to insert records into a table using datacontrol

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
Last edited by bushman_222; Jan 28th, 2008 at 7:08 am.
Reputation Points: 10
Solved Threads: 4
Junior Poster in Training
bushman_222 is offline Offline
65 posts
since Jan 2008
Jan 30th, 2008
0

Re: how to insert records into a table using datacontrol

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
newvbee is offline Offline
2 posts
since Jan 2008
Jan 30th, 2008
0

Re: how to insert records into a table using datacontrol

Hi,
Ther ir no way to use VB application softwares in Web,

Web applications are distincly different,yiou cantry with DHTML or go for Dot net

Windows app cannot be used as Web app

With regards
Venkatramasamy SN
Reputation Points: 12
Solved Threads: 12
Junior Poster in Training
venkatramasamy is offline Offline
71 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: it posible to change the skin of the form??
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: searching help part 2..





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC