Re: DAP didn't return any records when I used a Like clause in the que

Perhaps you used * as a wildcard character? DAPs use ADO recordsets, not DAO
recordsets, so the wildcard is %.

--

Ken Snell
<MS ACCESS MVP>


"Christian Bahnsen" <ChristianBahnsen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:4F6C3EC6-DC2D-4BC8-8B75-839752450F63@xxxxxxxxxxxxxxxx
The data access page (DAP) I created based on a query that contained a
Like
clause didn't return any records. Is this a known issue with DAPs?


DAPs based on similar queries that didn't use Like clauses work fine.

--
Christian Bahnsen


.

Relevant Pages

  • Re: How much to convert to SQL server
    ... filtering on, in a where clause, is not indexed. ... If the subselect is happening first, yes, it will ... best way to get editable recordsets from uneditable equivalent ...
    (comp.databases.ms-access)
  • Re: PLEASE HELP!!
    ... Data Access Pages (DAPs) are a completely different animal from forms. ... form's functionality manually in a DAP. ... recordsets... ...
    (microsoft.public.access.forms)
  • Re: DAP rs.find
    ... the syntax or even where to place the LIKE statement on the line. ... elsewhere that the % is the wildcard character. ... I've never worked with DAPs. ... (no private e-mails, please) ...
    (microsoft.public.access.dataaccess.pages)
  • DAP didnt return any records when I used a Like clause in the que
    ... The data access page I created based on a query that contained a Like ... clause didn't return any records. ... DAPs based on similar queries that didn't use Like clauses work fine. ...
    (microsoft.public.access.dataaccess.pages)
Loading