?
Solved

DataTable Column/Row Reference

Posted on 2009-05-05
4
Medium Priority
?
406 Views
Last Modified: 2013-11-27
I have a MS Access 2003 query that returns 2 columns and 4 rows, based on the tableadapter parameter in my VB2005 program. I need to have:

textbox1.text = column1, row1
textbox2.text = column2, row1
textbox3.text = column1, row2
textbox4.text = column2, row2
etc. thru
textbox8.text = column2, row4

What is the proper way to reference the data in the table to fill the textboxes?
0
Comment
Question by:Tim313
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 44

Accepted Solution

by:
GRayL earned 1000 total points
ID: 24304926
A relational database does not work that way.  If you want to be able to refer to the return by row and column, then make the query the record source for a combo box or a list box.  You can refer to the values by:

myVal=Me!cboName.column(c,r)

Where r and c are zero-based rows and columns
0
 
LVL 20

Expert Comment

by:clarkscott
ID: 24305532
You have to SORT the recordset how you wish to view the data.
Scott C
0
 

Author Closing Comment

by:Tim313
ID: 31578025
Did not use the solution, but kept it for future reference....
0
 
LVL 44

Expert Comment

by:GRayL
ID: 24576782
Thanks, glad to help.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question