var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query with parameters in Access Projects
I am working with Access Project with SQL server as backend.
In Access 97, we can create queries with parameters.
How can we do the same in Access Projects ??
Stored procedures ? But I thought we cannot join stored procedures in the way we join tables/queries.
What is it more exactly that your looking for?
Yes you can create queries with parameters... but what do you want to do?
Thanks for the reply.
I started this with an mdb file. I created 2 queries with parameters, which are references to a form date range.
Select * From table1 where Date between forms!x!date1 and forms!x!date2 and blah, blah...
Select * From Query1 where Date between forms!x!date1 and forms!x!date2 and blah, blah...
>>Now I am converting these queries to an Access Data Project.
in Access project, you cannot create view as a parameter query.. it can only be done in the queries that are lying behind forms as recordsource..
I think they CANNOT be used even in the "recordsource" property of a form.