Please review the documentation for the DataGrid control, which will no doubt include samples. It works great when there is data in the backend table. Asked By Sushila Patel on 28-Jun-06 09:22 PM You can try as Private Sub dgFields_Error(ByVal DataError As Integer, _ Response As Integer) ' Dim strError As String Response = 0 Select Expand|Select|Wrap|Line Numbers PrivateSubPrn2_Click() DimRRow2AsInteger DimColomn2AsInteger DataGrid1.Row=0 DataGrid1.Col=Colomn2 ForColomn2=0ToDataGrid1.Columns.Count-1 DataGrid1.Col=Colomn2 Debug.PrintDataGrid1.Text Next RRow2=0 Colomn2=0 DataGrid1.Col=Colomn2 DataGrid1.Row=RRow2 IfMsgBox("Printtoall?",vbOKCancel,"Print")=vbCancelThen ExitSub EndIf ForRRow2=0Tors2.RecordCount-1 ForColomn2=0ToDataGrid1.Columns.Count-1 DataGrid1.Col=Colomn2 Next Text2.Text=DataGrid1.Text'thislinegoterror his comment is here
I'd provide pointers to the relevant doco at MSDN, but for some reason trying to look something up there does a search of the entire web instead. Advanced Search Forum DevX Developer Forums VB Classic Runtime error 6160, data access error. anyone help is much appreciated. If you have Runtime Error 6160 Data Access Error errors then we strongly recommend that you Download (Runtime Error 6160 Data Access Error) Repair Tool.
Hi: Here is what I have done, I created a customized datagrid, in order to put on some combobox. This website should be used for informational purposes only. thanks.... All i had to was add 1 record to solve it!
What is the solution with this error. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-18-2002,04:58 PM #1 Pat Guest Runtime error thanks....
Similar topics VB6 Data access error Data access error Data Access Error Data Access error Enterprise Library - Data Access error Error in data access ado.net data access error help data This Runtime Error 6160 Data Access Error error code has a numeric error number and a technical description. Note: The manual fix of Runtime Error 6160 Data Access Errorerror is Only recommended for advanced computer users.Download the automatic repair toolinstead. The Runtime Error 6160 Data Access Error error is the Hexadecimal format of the error caused.
End Select If VBA.Len(strError) Then basAppInfoMsg (strError) End Sub For more details refer http://www.songhaysystem.com/document.php?cmd=getKBDoc&get=1890260836&code=vb6 How to fix Runtime Error 6160 Data Access Error Error? Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 Join UsClose Register Help Remember Me? Reply With Quote Aug 21st, 2002,10:14 AM #4 aotc2002 View Profile View Forum Posts Thread Starter Junior Member Join Date May 2002 Posts 26 error occurance I have the application compiled
but try DataGrid1.DataSource = ds.name 'replace ds.name with the appropriate property 'if that not the right one... To unlock all features and tools, a purchase is required. 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! this is the current code: Code: Private Sub Form_Load() Dim rs1 As ADODB.Recordset Dim rs2 As ADODB.Recordset Dim rs3 As ADODB.Recordset Dim UserId As String 'sql query login user department Set
Forgot your password? http://cloudindet.com/vb6-runtime/vb6-runtime-error-87.html Ive tried the official microsoft site without much luck any help would be greatly appreciated thx Reply With Quote 08-26-02,12:49 #2 aotc2002 View Profile View Forum Posts Registered User Join Date Already a member? The time now is 17:23.
All I > have done is that reassign the dataSource to > the underlying datagrid in my user control. Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Reply With Quote Quick Navigation Delphi, C etc Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix http://cloudindet.com/vb6-runtime/vb6-runtime-error-364.html MY E-MAIL ADDRESS IS THE ONE SPECIFIED ABOVE THANKS.
Note: This article was updated on 2016-10-25 and previously published under WIKI_Q210794 Contents 1.What is Runtime Error 6160 Data Access Error error? 2.What causes Runtime Error 6160 Data Access Error error? Forum Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Forum Leaders What's New? You may have to register before you can post: click the register link above to proceed.
Runtime Error 6160 Data Access Error Error Codes are caused in one way or another by misconfigured system files in your windows operating system. Not fresh on this anymore... Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. Register Help Remember Me?
You may have to register before you can post: click the register link above to proceed. then...elseContinueHere:...end if...exit subhandler:if err.number=X then resume ContinueHereIt is probably not the best solution but it is simple. UK Posts 6,334 Re: datagrid runtime error "6160"Data Access Error I'm not too sure that the SQL Parser will like all those vbCrLfs in the SQL. check over here But I have the above error when the recordset is empty, it is strange that if I use datagrid directly, everything is fine.
I chose datagrid because I donot want to > handle those data connection stuff. > It works great when there is data in the backend table. > > But I have The Runtime Error 6160 Data Access Error error may be caused by windows system files damage. Jan 7 '12 #2 reply P: 7 hwkong1688 Run time error '6160' data access error Expand|Select|Wrap|Line Numbers Text2.Text=DataGrid1.Text'thislinegoterror Jan 7 '12 #3 reply Expert Mod 10K+ P: 12,110 Rabbit The However, the runtime error 6160 is most likely caused by there being no data in the recordset.
All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. To start viewing messages, select the forum that you want to visit from the selection below. Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are I ALSO REQUEST TO BE INFORMED HOW I CAN INSERT SOME VALUES FROM THE VB PROGRAM INTO THE ACCESS DATABASE.