LIKE operator in Data Access Page parametric query

G

Guest

Hi

I am trying to use a data access page which asks for a parameter which uses
the LIKE operator in the query, so that the user can input part of the field
and see all the matches. My queries work in Access, I can base forms and
reports on them but when I base a data access page on one of these queries it
comes up with no data. Is the LIKE operator not supported in data access
pages?

The query is

SELECT item, description, colour, price
from tablename
where description like '*' & [Please enter part of the description] & '*'

(or similar, just copying quickly right now - take my word, it works as an
Access query, I can base a form or report on it, but no data if I base a DAP
on it)

Secondly, can users without Access use the DAP's? I thought I read about a
special license required. Should I try writing a form in VB instead, and
give them an executable?

Thanks
 

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

Parameter Value error in a Subform 0
Access stripping decimal places in query 1
Parametric queries 9
bitwise operator in SQL 3
Using "like" query from and external link to Access 1
Run 2nd query using results from 1st query 0
Access #Error & Excel Pivot 0
Is it possible to pass an operator from a form to a query limit? 2

Top