DAP Server Filter Doesn't Work

[Ken Snell \(MVP\)]

In a DAP, the Recordset property (open DAP in design view, go to Page
properties window, and you'll find it on one of the tabs there) must be a
stored query in the .mdb file. You'll need to edit the query itself in the
..mdb file once you know which one it is.
--

Ken Snell
<MS ACCESS MVP>

I have the same problem where in my noobish beginnings I put a space in one
of my record keys. I need to add an alais as you did but i cannot find the
recordset query code that contains all the select code.

Juan Posted this...
the recordset for both dap's is the same query name "itin table qry' the
recordset for this query is the following:

SELECT [ITIN TABLE].[CLIENT ID], [ITIN TABLE].[DOCUMENT CODE #1], [ITIN
TABLE].[DOCUMENT CODE #2], [ITIN TABLE].[C: US RESIDENT ALIEN], [ITIN
.....

Where in the DAP is that found?

 

[Tom Wickerath]

that is wrong

and I believe that he's trying to use 'server filter' on a DAP with MDB
which doesn't support the serverfilter method

you need to use the filter method

serverfilter is for Access Data Projects w/DAP-- I think that ADP + DAP =
WOWSERS

In a DAP, the Recordset property (open DAP in design view, go to Page
properties window, and you'll find it on one of the tabs there) must be a
stored query in the .mdb file. You'll need to edit the query itself in the
.mdb file once you know which one it is.
--

Ken Snell
<MS ACCESS MVP>

I have the same problem where in my noobish beginnings I put a space in
one
of my record keys. I need to add an alais as you did but i cannot find
the
recordset query code that contains all the select code.

Juan Posted this...
the recordset for both dap's is the same query name "itin table qry' the
recordset for this query is the following:

SELECT [ITIN TABLE].[CLIENT ID], [ITIN TABLE].[DOCUMENT CODE #1], [ITIN
TABLE].[DOCUMENT CODE #2], [ITIN TABLE].[C: US RESIDENT ALIEN], [ITIN
.....

Where in the DAP is that found?

It seems to me that nothing of this sort is in the html code....but where
is
it?