Wrox Programmer Forums
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 30th, 2005, 11:36 PM
Authorized User
 
Join Date: Jun 2005
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Put info From VBForm to Acess?

I am lost. I need to be able to use a form with three text boxes where you input info name, email and Zip code. In addition, the user must input this info in order to get to the next page. And the info they put in gets saved to a database in Access. The person also will not be able to log in using the same name, email zip. Can some one help?

I have the database set up and the ADO connected to the form but have no clue how to input info to be put into the database.


 
Old July 30th, 2005, 11:42 PM
Authorized User
 
Join Date: Jun 2004
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Default

a nice way to make entries in a database using vb is by taking advantage of ADO.Recordset or DAO.Recordset

"Life is a Database"
 
Old August 6th, 2005, 09:59 PM
Authorized User
 
Join Date: Jun 2005
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I dont know what that is.

 
Old August 9th, 2005, 02:36 PM
Authorized User
 
Join Date: Jun 2004
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Default

a recordset is a "thingy" in programming that you instantiate and can make it take the shape/identity of an existing table in access. The recordset behaves pretty much like the table. It has rows and columns(fields). All you have to do is learn how to link it to a specific table, navigate through it, insert or delete rows, and update columns. You should go to msdn.com and look up recordsets... Since you're using ADO... you should read up ADO.Recordset examples. Questions, comments, anyone?

Julio Cesar

-"Life is a Database"
 
Old August 9th, 2005, 04:35 PM
Authorized User
 
Join Date: Jun 2005
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

all i was wondering is like what code do I nedd to type in?

I know i need to use Sql commands like "Insert Into" just wondering what i need to type "code" into vb to connect acess to the vb program.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Acess denied prafullaborade XML 2 May 22nd, 2008 09:55 AM
Searching Multiple Columns in Acess JezLisle Access 1 April 24th, 2008 11:37 AM
Microsoft word and Acess keisha Access 3 February 15th, 2008 09:08 AM
Acess 2000 to Sql Server mikersantiago Classic ASP Databases 4 November 16th, 2004 10:26 AM
Data acess with .NET btls BOOK: Professional C#, 2nd and 3rd Editions 1 June 14th, 2004 11:21 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.