Prompt within a view 1

[codemech]

In an Access .mdb query I can create a prompt using the following criteria syntax --

>[After What Starting Date?]

Is there any whay to accomplish this in a .adp file?

Thanks,
C

 

[cmmrfrds]

I am only familar with the Access 2000 Project not the later versions, but I am quite familar with sql server 2000. A View in sql server does not take paramters. If you want to use paramters then a stored procedure is the most common way. A stored procedure can return a resultset just like a query in access. You can build Functions in sql server that can return tables/resultsets and I believe accept paramaters. There is also a Parameterized View in sql server, but I have not used it. Now, if you want to send paramters to a stored procedure and bind a Form to the stored procedure, you can put the parameter prompt in the InputParameter Property. So, bottom line is that the View interface in an access 2000 project limits you to the simple sql server view, and parameters are not part of that equation.