For Programmers: Free Programming Magazines  


Home > Archive > Visual Basic > March 2005 > getting data from mdb to flexgrid









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author getting data from mdb to flexgrid
SteveC

2005-03-28, 3:55 pm

I'm trying to get the data from a mdb I made with data manager to
display on a msflexgrid(10 fields).I've been doing this with UDT and
saving data in a text file,but the text files are getting large,6 or 7
thousand lines.Anybody point me to some examples.
thanks
SteveC

Duke

2005-03-29, 3:55 am

I hope I understand your problem, Is this what your after ?

MSFlexGrid1.clear
Do until Table.EOF = True
MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
MSFlexGrid1.Row = MSFlexGrid1.Rows - 1
MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 0) = Table!Field1
MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 1) = Table!Field2
MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 2) = Table!Field3
etc. etc

Table.MoveNext

Loop

Duke


>-----Original Message-----
>I'm trying to get the data from a mdb I made with data

manager to
>display on a msflexgrid(10 fields).I've been doing this

with UDT and
>saving data in a text file,but the text files are getting

large,6 or 7
>thousand lines.Anybody point me to some examples.
>thanks
> SteveC
>
>.
>

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2009 codecomments.com