flexgrid does not refresh

[PeggyC]

Hi.

I'm having trouble getting a flexgrid to refresh. I'm using a datacontrol to get the data from an Access DB. I've tried doing data1.Refresh or MSFlexGrid1.Refresh and that doesn't work. I've also tried requerying and then refreshing but that doesn't work either. I'm probably doing something wrong. Can anyone help?

Thank you!
Peg

 

[kevinclark]

More likely a bug with the control. Take a look at this article.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q179759

Microsoft advises using another data control but from my experiences its better not to use them at all.

 

[marcsoft]

your best bet is to use the textarray feature of the flex grid. this will not only update the grid, but also the display. sometimes, its best to buffer the grid, if possible, so that you dont constantly update the grid until you want to , after updating your buffer. the textarray feature takes a value that corresponds to the current cell. so, if you have a 10 col by 5 line grid, your cells range from 0 to 49. also, you dont want to update your fixed cols/rows. this can be a problem.
msflexgrid.textarray(cell addr) will update a given cell and display it.

 

[PeggyC]

Thanks for the tip. I found out that the db wasn't updating fast enough so when the grid refreshed it only extrated the old data. I put a pause time in there and it seems to be working ok. I'll try your idea and see if it works better.

Thanks again!