April 1, 2005 at 7:03 am
I've a DB in access where the tables are linked in SQL, now the frontend is on Acces, so the user does his input over there. If the user now ask some report bases on query's, there are some criteria which has to be filled in, if the view is in SQL, I cannot but a reference back to an Acces form. Does anybody know how this can be programmed or does ther somewhere excist a script to bring from acces to SQL so the criteria fields in a form can be used in SQL.
April 5, 2005 at 7:30 am
As another newbie who is just starting to work with SQL Server (from an Access background) I just had to deal with the same thing. I don't know if this is the best solution, but it at least worked. You can set up a stored procedure with parameters, using @criteria_name as the placeholders for your criteria. Then in your report, there is a report property, Input Parameters, where you can assign the values from your form to the parameters in your sp. Here is an example from my report:
@DateAdded = Forms!fdlgReportFilter!txtDateParam
where @DateAdded is the parameter name in the sp, and Forms!fdlgReportFilter!txtDateParam is a reference to the appropriate field on the form that I was using to gather criteria.
Hope that helps!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply