Enter Parameters

[tonijel]

Hi,
I have a Data Access Page which is generated on behalf of a query.
Query uses one parameter field ,so when is started it promts with the form named Enter Parameters in which I have to input parameter value.
So before the DAP is opened, first is displayed parameter form.
I would like to change dimensions of that form(height, width) but I dont know how.
I already tryied by opening DAP in design view & then in microsoft script editor but i couldn't find anything about this pop-up parameter form.
Any suggestions are wellcome

 

[fneily]

See:

http://msdn.microsoft.com/library/?url=/library/en-us/dnacc2k2/html/odc_PassParam.asp

It's kinda complex and it's hard to test if you're not on a server.

You might want to create a DAP from your query(non-prompt) and then have a combobox to do a filter or find. It's alot simpler.

Read:

http://msdn.microsoft.com/library/?url=/library/en-us/dnacc2k/html/programdap.asp

Custom filtering and search:

http://msdn.microsoft.com/library/d...c2k2/html/odc_customfilteringandsearching.asp

 

[tonijel]

thx fneily but it didn't work out....
After I press command button on the DAP for parameter input , i get error so I given up...
The error is : Object required: 'txtMytextBoxName1'

This is the error line from page source:

' Values in the text box are stored in the value property,
' while bound span controls store the value in InnerText.
pVariable1 = txtMytextBoxName1.value
pVariable2 = txtMytextBoxName2.value

so when button pressed nothing happens & no page opens.

I was thinking if You could suggest me how could I make DAP which will have only one text box in which will the value written there be forwarded to some parameter SQL...

Do you know what VB code should I implement in onClick action for button so he could start some query who would use value placed in that text box and then generate results in DAP....