Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Retrieving data from a MSHFlexGrid

  
   Database Help (Home) -> Visual Basic RSS
Related Topics:
New record with data from other form - I would like to open a addrecord form. In this form I would like teh Field DebNr to be filled with the value of the field DebNr in my (open) form FrmStam. I used the code ; Private Sub As Integer) If

data environment in data report- error?Why - I have a vb project and I have used data reports. The reports are working perfectly well here. But when I copy the whole folder to another machine, I cannot open the and it shows error. Why?All the forms and reports can be opened in..

NEWBIE insert data rather than update in db - I have an app for tracking mileage on company vehicles. On the first form you select a combobox getting vehicle names from database) and enter the info. Then I need to export that data back to the database. The ? is how do I..

Data Environment Designer - need additional table fields o.. - Hello -- There are too many columns in the table to fit on a form when dragging the DED's table's Command node onto the form. I need to add to the form some of those columns which did not come onto the form in that initial dragging. After

Using Data Environment Designer - how to drag Command node.. - Hello -- I can't figure out how to get the Data Project and blank form on the screen at the same time so that I can drag the Command node onto the blank form. I am following the tutorial on p 182 in Roger Jennings' Database Guide with Visual..
Next:  Visual Basic: SQL- using lst box to gatehr info for a specidi field.  
Author Message
Ant

External


Since: Feb 16, 2005
Posts: 10



(Msg. 1) Posted: Sun Feb 20, 2005 10:40 am
Post subject: Retrieving data from a MSHFlexGrid
Archived from groups: comp>lang>basic>visual>database (more info?)
I've managed to set up an MSHFlexGrid and store it with data from an Access
DB successfully.

What I'm trying to do is retrieve data from a selected row but I'm not sure
what methods I need to call to get this data.

Can anyone tell me how to do this or point me to documentation that shows
how to.

Thanks
--
Ant

 >> Stay informed about: Retrieving data from a MSHFlexGrid 
Back to top
Login to vote
Randy Day

External


Since: Oct 06, 2003
Posts: 50



(Msg. 2) Posted: Sun Feb 20, 2005 10:47 am
Post subject: Re: Retrieving data from a MSHFlexGrid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Ant wrote:
 > I've managed to set up an MSHFlexGrid and store it with data from an Access
 > DB successfully.
 >
 > What I'm trying to do is retrieve data from a selected row but I'm not sure
 > what methods I need to call to get this data.
 >
 > Can anyone tell me how to do this or point me to documentation that shows
 > how to.

You mean like this?

'<row number> refers to the row you've selected
for x= 0 to mshGrid1.cols - 1
CellData = mshGrid1.textmatrix(<row number>,x)
next x<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Retrieving data from a MSHFlexGrid 
Back to top
Login to vote
Ant

External


Since: Feb 16, 2005
Posts: 10



(Msg. 3) Posted: Sun Feb 20, 2005 1:40 pm
Post subject: Re: Retrieving data from a MSHFlexGrid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Randy Day" <ruthal.TakeThisOut@sasktel.nex> wrote in message
news:111hc9s2b527582@corp.supernews.com...
 > Ant wrote:
  >> I've managed to set up an MSHFlexGrid and store it with data from an
  >> Access DB successfully.
  >>
  >> What I'm trying to do is retrieve data from a selected row but I'm not
  >> sure what methods I need to call to get this data.
  >>
  >> Can anyone tell me how to do this or point me to documentation that shows
  >> how to.
 >
 > You mean like this?
 >
 > '<row number> refers to the row you've selected
 > for x= 0 to mshGrid1.cols - 1
 > CellData = mshGrid1.textmatrix(<row number>,x)
 > next x

I have another question, do you know how to get the value of the row that
has been selected by the user, I went through trying all the
methods/attributes beginning with row but kept getting invalid property
errors?<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Retrieving data from a MSHFlexGrid 
Back to top
Login to vote
Ant

External


Since: Feb 16, 2005
Posts: 10



(Msg. 4) Posted: Sun Feb 20, 2005 1:40 pm
Post subject: Re: Retrieving data from a MSHFlexGrid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Randy Day" <ruthal.RemoveThis@sasktel.nex> wrote in message
news:111hc9s2b527582@corp.supernews.com...
 > Ant wrote:
  >> I've managed to set up an MSHFlexGrid and store it with data from an
  >> Access DB successfully.
  >>
  >> What I'm trying to do is retrieve data from a selected row but I'm not
  >> sure what methods I need to call to get this data.
  >>
  >> Can anyone tell me how to do this or point me to documentation that shows
  >> how to.
 >
 > You mean like this?
 >
 > '<row number> refers to the row you've selected
 > for x= 0 to mshGrid1.cols - 1
 > CellData = mshGrid1.textmatrix(<row number>,x)
 > next x

Thanks for replying! That's great, exactly what I was after.

Cheers
--
Ant<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Retrieving data from a MSHFlexGrid 
Back to top
Login to vote
Robert Berman

External


Since: Feb 17, 2005
Posts: 2



(Msg. 5) Posted: Sun Feb 20, 2005 7:40 pm
Post subject: Re: Retrieving data from a MSHFlexGrid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Ant" <nospamf RemoveThis @nospam.com> wrote in message
news:cvaifr$87f$1@wisteria.csv.warwick.ac.uk...
 >
 > "Randy Day" <ruthal RemoveThis @sasktel.nex> wrote in message
 > news:111hc9s2b527582@corp.supernews.com...
  >> Ant wrote:
   >>> I've managed to set up an MSHFlexGrid and store it with data from an
   >>> Access DB successfully.
   >>>
   >>> What I'm trying to do is retrieve data from a selected row but I'm not
   >>> sure what methods I need to call to get this data.
   >>>
   >>> Can anyone tell me how to do this or point me to documentation that
   >>> shows how to.
  >>
  >> You mean like this?
  >>
  >> '<row number> refers to the row you've selected
  >> for x= 0 to mshGrid1.cols - 1
  >> CellData = mshGrid1.textmatrix(<row number>,x)
  >> next x
 >
 > I have another question, do you know how to get the value of the row that
 > has been selected by the user, I went through trying all the
 > methods/attributes beginning with row but kept getting invalid property
 > errors?
 >

myvariabelName = flexgrid.row<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Retrieving data from a MSHFlexGrid 
Back to top
Login to vote
Ant

External


Since: Feb 16, 2005
Posts: 10



(Msg. 6) Posted: Sun Feb 20, 2005 7:40 pm
Post subject: Re: Retrieving data from a MSHFlexGrid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Robert Berman" <BermanRL.DeleteThis@NOSPAM.earthlink.net> wrote in message
news:Er7Sd.1812$873.293@newsread3.news.pas.earthlink.net...
 >
 > "Ant" <nospamf.DeleteThis@nospam.com> wrote in message
 > news:cvaifr$87f$1@wisteria.csv.warwick.ac.uk...
  >>
  >> "Randy Day" <ruthal.DeleteThis@sasktel.nex> wrote in message
  >> news:111hc9s2b527582@corp.supernews.com...
   >>> Ant wrote:
   >>>> I've managed to set up an MSHFlexGrid and store it with data from an
   >>>> Access DB successfully.
   >>>>
   >>>> What I'm trying to do is retrieve data from a selected row but I'm not
   >>>> sure what methods I need to call to get this data.
   >>>>
   >>>> Can anyone tell me how to do this or point me to documentation that
   >>>> shows how to.
   >>>
   >>> You mean like this?
   >>>
   >>> '<row number> refers to the row you've selected
   >>> for x= 0 to mshGrid1.cols - 1
   >>> CellData = mshGrid1.textmatrix(<row number>,x)
   >>> next x
  >>
  >> I have another question, do you know how to get the value of the row that
  >> has been selected by the user, I went through trying all the
  >> methods/attributes beginning with row but kept getting invalid property
  >> errors?
  >>
 >
 > myvariabelName = flexgrid.row
bingo bango, no idea how I missed that.
thanks<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Retrieving data from a MSHFlexGrid 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Visual Basic All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]