You are currently viewing the VB Components section of the Wrox Programmer to Programmer discussions. Why would others?) What is the err.description? in this case, the row has to be visible to get the data, you need to scroll. thava, on 15 Apr, 2009 - 06:38 PM, said:just querying the underlying table of the record set with an aggregate Hi, can you teach me how to do that?
xtremevbxtreme View Public Profile Find all posts by xtremevbxtreme
Registration is fast, simple and absolutely free . Thank you! Martin Walke replied Nov 27, 2009 Ok.. Have you checked the math manually?
Reply With Quote Quick Navigation VB Classic Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums DevX Developer Forums .NET ASP.NET VB Classic Java C++ XML my problem now if the record more than 3, it give error... so datata grid is not abole to update data. again sir thank you." Top Best Answer 1 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
The time now is 04:10 PM. but i want it to loop from the next record in order get col5 value which is not empty.. That formula is just so you can discover what real record number the cursor is set on in the datagrid. best regards.
butch Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #12 thava D.I.C Lover Reputation: 180 Posts: 1,607 Joined: 17-April 07 Re: How to total sum from please attachment.. The Visual Basic for Access group is no longer active. Forum Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Forum Leaders What's New?
I get an error message 6148. this content Alonsher #2 (permalink) June 19th, 2006, 02:48 PM BrianWren Friend of Wrox Join Date: Nov 2004 Location: Port Orchard, WA, USA. reading the various info that's out there, it would appear that you can only access "visible" rows. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers.
About UsTell FriendsHow to AskHow to VolunteerFAQTech SupportTop ExpertsExpert LoginBrowse Answers:By CategoryAlphabeticallyFind expert answers to:Find Run-time error '6148' : Invalid row number - Index ‹ Visual Studio ‹ Try: ghost = "Select * from QrySalesDetails where DatePurchased >= #" & FromDate & "# and DatePurchased <= #" & ToDate & "# " Len Robichaud IT Manager Visual Comfort 713-686-5999 Does anyone know why this could happen?>>Allen ---=_supportweb3ed7b099 # 1p newsgroup_archive1p 13 years, 5 months ago Allen, Maybe you could use tdblist.selecteditem=cnt instead of tdbList.Row = cnt. weblink Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search VB Components Issues specific to components in VB.
sasa sasa View Public Profile Find all posts by sasa #2 03-28-2002, 10:58 AM Thinker Iron-Fisted Programmer Retired Moderator* Guru * Join Date: Jul 2001 Location: Fayetteville Powered by vBulletin Version 3.8.9Copyright ©2000 - 2016, vBulletin Solutions, Inc. --> Need to download code? Top Best Answer 1 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
subscribe Programmers Heaven C# School Book -Free 338 Page eBook The Programmers Heaven C# School book covers the .NET framework and the C# language. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers ghostEncryption replied Nov 30, 2009 Ok sir,,Sorry." Column 6 on my Grid is SubTotal.."how can i display it to my DataReport sir.? Does anyone know how i can resolve this problem with approxcount as there doesn't appear to be much on here regarding datagrid columns displaying all (autofit/autosize)?
So the issue is to get the "focus" or visible selected row on the grid so that is does not error. If I have 5 rows and only 3 are displayed at a time, then when Iread 4 row I get the runtime error 6148 "Invalid Row Number". e.g. check over here DahnckeVITALYAhmed Sayed AzizRichard RostKaustav NeogyAmal Raj A Ask ExpertsVolunteer Ravindra Expertisevisual basic application programming from design to access information, sql, engineering and commercial applications.
but i want it to loop from the next record in order get col5 value which is not empty.. Maybe you are really getting Debit totals in vTtlCredits Hi June7, Thanks for reply, really appreciate it.. More Visual Basic Groups Your account is ready. however the next row, col4 now is empty and col5 has a value which i didnt get it..
Maybe you are really getting Debit totals in vTtlCredits This post has been edited by June7: 15 April 2009 - 06:07 PM Was This Post Helpful? 0 Back to top MultiQuote The following is some test code that demonstrates the problem. i'm avoiding to use .Movenext ... I got 1,2,3,4,5 columns..
Top For discussions on Visual Basic for Access please visit the Visual Basic – General Discussions group. please help. jeffreyJS ASP.NET 2.0 Basics 4 September 14th, 2006 04:07 AM mysterious error runtime error '451' coyotworks Excel VBA 1 May 12th, 2006 03:57 PM Runtime Error rwiethorn ASP.NET 1.0 and 1.1 Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free!
Try to ensure you only refererence an area containing data. Reply With Quote 12-23-2002,09:59 PM #2 anonymous View Profile View Forum Posts Senior Member Join Date Aug 2004 Posts 43,023 Re:datagrid - invalid row number [Originally posted by Rabab] hi may reading the various info that's out there, it would appear that you can only access "visible" rows. best regards.
End With Loop End if Even if I change the Do until i = 16 to whatever number, it is still giving me the same error, please help, I am very Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Resources Jobs thinker What if i have a datagrid and i want to operate on each row, i have a button on each that take data manipulates it, produces results, and places all but i want it to loop from the next record in order get col5 value which is not empty..
but i only get value amount from col4, which i understand coz next column 5 is empty... Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM