How do i add data from 3 access tables on one vb6 form?

Question

I'm trying my hand on vb 6 n facing this difficulty, from one table the gp code will come other members data of that grp n 3rd table consists of transactions by each member.

Answer 1

You heve to use SQL to do that job. Join the three table using SQL. If you are not familiar with it, you have to study it cause it very important when doing database programming.



For free VB source codes, visit: http://smartcoder.awardspace.com





KaBalweg

http://smartcoder.awardspace.com

Answer 2

There are several ways you can do it... You can create a View in your DB that combinds the needed information the tables. You can use an ADO Recordset and through a Select statement using Joins pull the data into a single ADO Recordset. Or you can open multiple ADO Recordsets and use VB code to manipulate the data and to get the results you want from each Recordset... The last requires quite a bit more code but is how I first started out doing things when I was new to ADO and SQL Select statements. Good resource for help is: http://msdn.microsoft.com/library/ You can find good information on ADO and SQL in there.

Answer 3

Create an sql query that contains the data from the 3 seperate tables and then bring it in via VB.

Answer 4

Create a view that joins the 3 tables on some common column.



Use VB to read the view and populate your form.

Answer 5

high priced pal ! open the seen subject-loose 6.0 click on the upload ins menu.after choosing that determination an pop memu will apper mentioned as addins. click in this determination u may well be stumble on an small communication field appers mentioned as seen records supervisor. on that determination u can open an msaccess record in vb.