Search results for query: *

jebenson. Thanks for the reply. Yes, in fact I do assign to the dataset as follows: Dim da As OleDbDataAdapter = New OleDbDataAdapter(sSQL, myConnection) ' create a new dataset Dim ds As DataSet = New DataSet ' fill dataset...

I have a datagrid that returns a tree like view when data is returned. It appears with a (+) and DataResults link. When you click the link it displays all the data just fine. How do I get rid of this first view so that the data in rows is displayed immediately? I've been looking for a...

I have a .aspx page that runs fine when launching from design mode from localhost. I do have the .NETSetup installed properly on my machine. However, after I move my entire project to a different server and put all the files under a directory in Intepub I then try to load the .aspx page in a...

Hello All, I'm getting a run-time error 3704 that states "Operation is not allowed when the object os closed." when I attempt to close a recordset using ADO (2.5 Library). Here is my sample code: ********************************************************* Dim cn As ADODB.Connection...

Hello, I have built an Access Query that includes a memo field. When I try to display the results of that query memo field in either an Access report or Crystal report the data truncates and doesn't display the full data result. The data in the memo field can get quite large and I want all...

Hello all, I have an Access Report that I want to prompt the user a specific date range to enter in the query. When the user types the beginning and ending dates in. How to I pass that variable data so it displays in the report? What syntax is used in the report to show this? I have the...

I'm having trouble inserting a vbCRLF within variable text into a SQL server database field. I'm trying to do something like: sText = sLogon & chr(13) & chr(10) objForm.ADORecordset("fieldname") = sText Or sText = sLogon & vbCRLF objForm.ADORecordset("fieldname") = sText...

Using ADO, I'm getting a run-time error number -2147217864 that states: "Row cannot be located for updating. Some values may have changed since it was last read." Article 300586 states that this is a known bug in VB6.0 enterprise and professional using the ActiveX Data Objects data...