create table filtering a recordset

**JJCHCK** · 09-23-2011, 10:45 AM

Hi evreybody
Im tring to create a table with db.execute method but i have problems
with the filter method...I'm new to Vb

I have a table wich contains records that i want to reflect in another table....i attache my db

sorry for english

**June7** · 09-23-2011, 04:10 PM

Why do you need records in a another table?

What is the SELECT statement that fSql needs to be set to?

You have 'Option Explicit' spelled as 'Optione Explicit'.
You have dbs.Execute instead of db.Execute.
If you did Debug>Compile these errors would be apparent.

You don't do anything with rstFiltered.

**JJCHCK** · 09-26-2011, 01:45 AM

You're right excuse: they are hasty and confused
I must ottenerer records from a subset of the Customers table like table tmp to send a mail to the system administrator.

**JJCHCK** · 09-26-2011, 01:46 AM

tmpRcaCodclfTipoDest1DL3CN5CN

this is the table i would get
sorry again for english

**June7** · 09-26-2011, 06:32 PM

Not necessary to write records to a temp table for email. Build Access query with filter criteria. Use the query.

**JJCHCK** · 09-27-2011, 01:11 AM

I think i will do so...
thank you June7

create table filtering a recordset

Thread Tools

create table filtering a recordset

Similar Threads

Join Key of table in recordset

Filtering on Field Names from Table

What is the difference between 2 ways to create a RECORDSET ?

Join A Recordset to the current db Table

Create a recordset for a report

Posting Permissions