Unanswered: Prompted date in report (using a view)
I am running a report with the control source as a view. I want to enter a prompted date but when I set the date field as =? I get an ADO error. I did try using the view's code as a query but it is based on 3 other views and still does not work.
I had written a stored procedure using on our server but I can't run this from any other computer on the network. And I have set all the permissions to access it.
Help would be greatly appreciated!
p.s. when I try to create a stored procedure on my pc it says:
Microsoft Access can't find the object 'Microsoft Access can't find the object 'StoredProcedure1.'.'