thanks for the effort guys the scenario is like this I populate a temp table in access, then pick the data from this table using the ado control to populate the datagrid I rebind the ado ctrl via code and refresh the grid
but am thinking of dropping it all together now. --- "Unicorn.PC.Support" <[EMAIL PROTECTED]> wrote: > If the data is displayed correctly by stepping > through the code, that > usually indicated either an error condition that is > being ignored, or a > timing problem. > > Things you could try. > > 1/ Put a doevents() after the statement that loads > the data to the grid. > > If this fixes the problem, you really need to try > and find out what is > causing the problem. but at least you have found > that it is a timing > problem. > > 2/ Are you trying to display recently added data? > i.e. If the Grid is > displaying a table of connected workstations and > yours is in the list, you > will need to allow for the inbuilt delay on > displaying new data. > Stepping through code often makes this 'problem' > disappear because you > exceed the delay time while pressing F8 > > 3/ Print out the contents of the returned recordset > using debug.print and > check that the data appears to be formed correctly, > i.e. Null's in > unexpected places can cause all sorts of strange > behaviours. > > Matt > > > > ----- Original Message ----- > From: "Tinashe M Shoko" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, May 31, 2004 4:43 PM > Subject: Re: [vbhelp] Datagrid problem - dropping > last row > > > > it is truly bound > > if i step through code at time it displays all the > > records > > > > --- "Unicorn.PC.Support" > > <[EMAIL PROTECTED]> wrote: > > > is you grid truly bound, or are you populating > in > > > manually? > > > > > > Matt > > > ----- Original Message ----- > > > From: "Tinashe M" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Sunday, May 30, 2004 9:38 PM > > > Subject: [vbhelp] Datagrid problem - dropping > last > > > row > > > > > > > > > > Hi I have a form I designed with a datagrid > bound > > > by ado control to > > > > an access table. Problem is when I view the > > > records on the grid, the > > > > last record is always missing even the > rowcount > > > from code is the > > > > number of records selected. > > > > > > > > Any ideas anyone? > > > > > > > > > > > > > > > > > > > > > > > > > > > > '// > > > > > > ======================================================= > > > > Rules : > > > http://ReliableAnswers.com/List/Rules.asp > > > > Home : > http://groups.yahoo.com/group/vbHelp/ > > > > > > > > > > ======================================================= > > > > Post : [EMAIL PROTECTED] > > > > Join : [EMAIL PROTECTED] > > > > Leave : [EMAIL PROTECTED] > > > > '// > > > > > > ======================================================= > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ===== > > > ***************************************************************** > > As for those pushy metric proponents, give them > 2.54cm and they will take > 1.6093km!!!!!!!! > > > ***************************************************************** > > ....and Yossarian still could not understand how > Milo could buy eggs for > seven cents in Malta and sell them for five cents in > Pianossa and still make > a profit .... > > > ***************************************************************** > > "To the world you might be one person, but to > one > > person you just might be the world" > > > ***************************************************************** > > SSDD - Stephen King > > > ***************************************************************** > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Friends. Fun. Try the all-new Yahoo! Messenger. > > http://messenger.yahoo.com/ > > > > > > > > > > > > '// > ======================================================= > > Rules : > http://ReliableAnswers.com/List/Rules.asp > > Home : http://groups.yahoo.com/group/vbHelp/ > > > ======================================================= > > Post : [EMAIL PROTECTED] > > Join : [EMAIL PROTECTED] > > Leave : [EMAIL PROTECTED] > > '// > ======================================================= > > > > Yahoo! Groups Links > > > > > > > > > > > > ===== ***************************************************************** As for those pushy metric proponents, give them 2.54cm and they will take 1.6093km!!!!!!!! ***************************************************************** ....and Yossarian still could not understand how Milo could buy eggs for seven cents in Malta and sell them for five cents in Pianossa and still make a profit .... ***************************************************************** "To the world you might be one person, but to one person you just might be the world" ***************************************************************** SSDD - Stephen King ***************************************************************** __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
