Go Back   Access World Forums > Apps and Windows > VB.NET

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-12-2013, 01:21 PM   #1
LadyDi
Newly Registered User
 
Join Date: Mar 2007
Location: North Canton, Ohio
Posts: 894
Thanks: 52
Thanked 1 Time in 1 Post
LadyDi is on a distinguished road
Red face Rows() Property

I'm trying to create a form in Visual Studio and have run into something I can't get to work. I'm trying to set up a label to reference all the results in one query. I have everything set up, but I have to put Rows() in my variable and I have to put a number in the parenthesis or it won't run. When I put in the number, then it only shows the records at that index. Is there a way to make the Rows() display all the records - the most records it can have are 5. I've tried putting in Rows(0,1) and Rows(0-5) and Rows(*), but nothing works. Do you have any suggestions. Here is the code I have behind my label.

Code:
Me.TA_Error_Codes.FillBy(DS_CV_Calls_DB.Error_Codes_tbl, Me.cbo_Location.SelectedValue)
        If DS_CV_Calls_DB.Error_Codes_tbl.Count > 0 Then
            Dim errorCodes As CV_Calls_DBDataSet.Error_Codes_tblRow = DS_CV_Calls_DB.Error_Codes_tbl.Rows(0)
            Me.lbl_ErrorCodeRef.Text = errorCodes.Error_Desc
        End If

LadyDi is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Property Sheet: Link To Property Explanations. AJR General 2 01-05-2013 06:44 PM
Vertical rows into horizontal rows comma separated per group K-CJ Modules & VBA 4 08-28-2010 03:26 PM
subform "list box" "list rows" property missing Cameo Forms 4 02-09-2010 06:47 AM
Access 2007 - runtime property changes are being saved as persistent property values Atomic Shrimp Forms 1 10-12-2009 01:04 AM
If the AllowBypassKey property is disabled, how can the user reset this property accesser2003 General 3 05-15-2008 03:45 AM




All times are GMT -8. The time now is 06:51 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World