I have created a DAP and am trying to add some ActiveX controls to it.
I want to be able to prompt the user for word or several words and then have the DAP retrieve all the records that contain the word(s) and display them as a new RecordSet.
Here is the code that I have so far:
<SCRIPT event=onclick for=Command0 language=vbscript>
<!--
Dim rs
Dim strSearch
Set rs = MSODSC.DataPages(0).Recordset.Clone
strSearch = inputbox("Please enter a Locality: "
MSODSC.DataPages(0).Filter = "Locality= '" & strSearch & "'"
MSODSC.DataPages(0).Filter = adFilterNone
-->
</SCRIPT>
I want to use either the Filter property or an SQL query. How do I code either one in VBScript?
Any and all suggestions would be appreciated.
Thanks
I want to be able to prompt the user for word or several words and then have the DAP retrieve all the records that contain the word(s) and display them as a new RecordSet.
Here is the code that I have so far:
<SCRIPT event=onclick for=Command0 language=vbscript>
<!--
Dim rs
Dim strSearch
Set rs = MSODSC.DataPages(0).Recordset.Clone
strSearch = inputbox("Please enter a Locality: "
MSODSC.DataPages(0).Filter = "Locality= '" & strSearch & "'"
MSODSC.DataPages(0).Filter = adFilterNone
-->
</SCRIPT>
I want to use either the Filter property or an SQL query. How do I code either one in VBScript?
Any and all suggestions would be appreciated.
Thanks