Import Data from Access

  • Thread starter Thread starter Frederico Ottoni
  • Start date Start date
F

Frederico Ottoni

Hello,

I want to get some information from a recordset in access and display it
into a listbox using outlook vba.
But I have to problems.
I can't filter the informations I need and then index it to be
displayed. That's because to filter it I need to open the recordset like
dbOpenDynaset, Snapshot or ForwardOnly, and to index it need to be
opened like dbOpenTable. That way I can't do that sequence of filter and
index.
The other problem is that I can't filter a recorset by a field the is a
search column.

Can anyone help me please?

Ottoni.
 
Hi Frederico,

why don´t you use the SQL query for getting the searched records only?
 
Back
Top