Create a Record Set, Then Update Table from Record Set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jhr_2005 - 13 Jan 2007 00:25 GMT

I would appreciate some help to do the following: create a record set,
filter the record set and then with the filtered results, update a table. I
can start the process, but get stuck. Here is my attempt:

Dim db as DAO.Database
Dim rst as DAO.Recordset
Dim stSql as String

Set db = CurrentDB
Set rst = db.OpenRecordset("SQL_Query")

stSql ="Insert into "& rst.fields("Field1") & rst.filter = FieldYesNo=True

Here I wish to create a query to filter certain records and selects certain
fields to be append to a Table, but don't know how to do this. Your help
will be greatly appreciated.

Reply to this Message

Alex Dybenko - 13 Jan 2007 08:01 GMT

Why do you need recordset? try to make a select query, which returns
required data, and then make append query in it to insert data to
destination table.

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

>I would appreciate some help to do the following: create a record set,
> filter the record set and then with the filtered results, update a table.
[quoted text clipped - 15 lines]
> fields to be append to a Table, but don't know how to do this. Your help
> will be greatly appreciated.

Reply to this Message