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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

declaring a variable as "Index" turned out into "index" 2
Pivot table macro filter data between yesterday and today (date+time) 0
Import File Information 0
Use VBA to Populate Listbox from Open Spreadsheet 4
Remove filter from current view - outlook 2003 7
Access Access 2010: Activating controls in a form after filter by form 0
Access Microsoft Access_use text filter for several access files 0
ADO retrieval from close workbook-data type issue 2

Back
Top