I appear to be missing the point on this one- quite happy using DAO - am now upsizing to SQL server - using a Project as a front end, and ADO.
Currently- usng DAO, I run a report based on a query (select * from customer) - sending a parameter to the query using querydefs in VBA. This 'modifies' the query to read "select * from customers where code = ABC001"
Am really struggling to understand how to send the parameters and thus modify the query (Stored Procedure) using ADO.
Any pointers in the right direction would be greatly received.
it showed me the syntax for using the 'where' part of the docmd.open report.
Currently connecting the data via Access Project ( now 6-7 millions records on average - will increase)
Needed to run a filter on the report - on a customer by customer basis.
I then use a recordset to get my first customer - run the report using 'where' and then move on to the next reord(customer) in my script.
Am new to SQL Server - having worked out the Access DAO for all of this last month (500,000 records) - now get hit with large increase in number of records - so have had to use SQL.
Presume my use of the filter is the correct way - from a performance point of view - to process this. In that I am only sending small instruction down pipe to server - server then processes request and returns only records that match.