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
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