Data Access Page Development Questions

L

Leo

I am trying to design a Data Access Page to narrow down a 10,000 record
recordset based on two parameters: Bank Name and Bank State. This is supposed
to be a rush job, and I was trying to sidestep having our system
administrator add my request for PHP with an ODBC Access/ MS SQL driver into
their long queue

So I have two questions. A successful answer to one of the two parts would
help me immensely.

1. My original design was similar to a PHP or ASP page. I was going to
create a DAP page via the Wizard, and then unbind the Bank Name and Bank
State controls from the table fields. I would create a button, and run a
simple VBScript sub to return a filtered recordset based on the control
values. The recordset would be placed into a div on the DAP’s HTML.

The problem is that the sub returns errors, and removes the quotation marks
from my <Script type=â€text/vbscriptâ€> tags. I have even tried this as
language=â€vbscriptâ€, and the results are the same.

Is there any way to do this with an Access DAP?

2. This is my end-around move, which also failed: Build the DAP based on a
parameter query. The system prompts me for the missing values, but returns a
page based on the empty recordset. Is there any way to build a DAP based on a
parameter query?

Thanks,
Leo
 

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

Top