*500* How to select multiple rows in MSFLEXGRID

Posted on 2005-03-09
Medium Priority
Last Modified: 2008-01-09
Hai there ...

I was using MSFLEX GRID to display some records form database, i can select the Multiple records also, but i want to get the values from a particular column with in the selection for example if i displayed a 100 records in grid, i select records from 10 to 15, i want to take a columns values from 10 to 15, i get only one column value. any help is appreciated

Thanks in Advance
Question by:maramreddy
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
LVL 43

Accepted Solution

TimCottee earned 1500 total points
ID: 13494188
Hi maramreddy,

You need to iterate through:

For example:

Dim aryValues() As String
ReDim aryValues(MSFlexgrid1.RowSel - MSFlexgrid1.Row) 'Redim for the available rows
For intRow = MSFlexgrid1.Row To MSFlexgrid1.RowSel
    aryValues(intRow - MSFlexgrid1.Row) = MSFlexgrid1.TextMatrix(intRow,2) 'Use column 2

Then you have an array of values from the selected rows.

Tim Cottee

Author Comment

ID: 13494432
Thank you very much Tim ...its working and i have one more doubt, but it is not related with the MSFLEXGRID. it is related with datareport.

I want to save the generated Datareport into PDF format, in a specified folder with specified format.
i am using VB6.0 and data reports, and Acrobat 5.
I know that by selecting the printer as Acrobat distiller, and i want to save in a particular folder with particular name, without prompting the user.

Thanks in advance


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month15 days, 17 hours left to enroll

743 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