ADO • View topic • Using a Recordset as a Data Source for a New Query and Resulting Recordset

Using a Recordset as a Data Source for a New Query and Resulting Recordset

2 posts • Page 1 of 1

Jump to:

Next

1. datagridview tutorial plz!!!
hi , i'm an ex vb programmer , i need a GOOD and COMPLETE tutorial for filling a datagridVIEW via an access database file (.mdb) i want to be able to add a context menu for the cells much like excel and i want to add a DATE picker for a date field! i've been searching for a good tutorial for hours now! i dont get much out of the msdn docs =S Gideon
2. CurrentProject.Connection failure
Using Access VBA with Sql Server Users getting connection failure errors with our ADE due to timeouts, after being away from the workstation for a while. Also... I know I can check the CurrentProject.Connection.State property and re-establish the connection with 'CurrentProject.OpenConnection (ConnString)', but how do I trap the CurrentProject.Connection OnClose event globally from within a running ADE? Any hints/suggestions greatly appreciated TIA Steve
3. Moving data from ms access to sql server in .Net
I have accessed data from MS Acess database and stored it in a dataset and made some changes. I want to move the data in the dataset to the sql server database. How can this be done?
4. Can ADO access ACCESS and Oracle tables located on remote servers?
I have a Web application that was developed for me several years ago using Adobe Form Designer 5.0 and Adobe WorkFlow Server 6.2. The form uses VBScript. When upgrading to the latest version on a WIN 2003 Server using IIS RDS did not work so I converted RDS to ADO. The application queries a number of Access tables and writes user entered data to an Oracle data base. The ACCESS tables reside on the application server while the Oracle table is on another server. ODBCs are defined on the application server for each of these tables. My problem is that when using the application on a client PC it is looking for the DSN or ODBC on the client PC rather than the server where the application is. My question is an ADO tell the client Browser/PC where the DSN is located? -- Thanks Dick

Using a Recordset as a Data Source for a New Query and Resulting Recordset

by Andrew » Thu, 17 Nov 2005 14:50:25 GMT

I have an ADO recordset (rs1) in memory and want to run a query off of 
it, creating a new ADO Recordset (rs2) containing a subset of the 
records from the original ADO Recordset (rs1).  Would anyone be kind 
enough to provide a small code snippit in VB which would allow me to 
accomplish this?

Many thanks in advance ....


Andrew

Re: Using a Recordset as a Data Source for a New Query and Resulting Recordset

by Stephen Howe » Thu, 17 Nov 2005 21:12:10 GMT

> I have an ADO recordset (rs1) in memory and want to run a query off of

Can't be done. Whatever made you think it could?

Having said that you can clone a recordset from another recordset with
filter set.
But if you do, any changes to a record in one recordset is a change in the
other.

See
 http://www.**--****.com/ 
for an example

Stephen Howe

2 posts • Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest