Take that recordset and use it to create a new table (a temporary one) in the local Access database.<BR>3. Close the recordset.<BR>4. Run my report off the new temporary table<BR>5.

After you have created a table-type or dynaset-type Recordset object, you can change, delete, or add new records. You cannot change, delete, or add records to a snapshot-type or forward-only-type ...

To see records in a specific order, sort them. To sort data in a Recordset object that is not a table, use an SQL ORDER BY clause in the query that constructs the Recordset. You can specify an SQL ...

I have a recordset (rst) which I have created using an OpenRecordset Method on an existing table...call it t_Employee: Set rst = db.OpenRecordset("t_Employee", dbOpenDynaset) I want to be able to ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...

It's easy to print a single label for one or more records, but when you need to print multiple labels for a single record, you'll need VBA.