Data Access Page 'Enter Parameters' Problem

[Jason]

I have a Data Access Page which was a report at one time
saved in the DAP format. My problem is that there are
parameters needed for the queries to run and I need a
better way to gather those parameters. The pop-up box is
not descriptive enough for end users to comprehend and I
need another way to pass variables to the DAP created by
Access 2002. I'm not sure how to interface with the
language used in the Data Access Page that was generated
by Access.

 

[Rob Cooper \(MSFT\)]

Hi,

You will need to use a scripting language such as VBScript to write code in
the page. The following article discusses passing parameters to pages:

Passing Parameters to a Data Access Page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_PassParam.asp

Hope this helps,

Rob Cooper
Software Test Engineer
Microsoft Access Team

This posting is provided "AS IS" with no warranties, and confers no rights.