HansUp HansUp Fionnuala Fionnuala Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 0. Sunday, March 11, PM. Hi Daniel van den Berg I have removed all the criteria in my queries so far so good access does no longer ask for the parameter.
Close acReport, "Scorecard" rs. Let me know if you need to see anything else Thanks Jesper. Monday, March 12, AM. Monday, March 12, PM. I have set it up like this: Let me just thank you for your time and effort in this. Tuesday, March 13, AM. Hi Jesper, I am not sure, but what I think happen is that there are several [corrected name] fields in your query, which than might be causing difficulty for the Where statement to find the right one in the query.
PDF" ' set here the [tblMain]. Tuesday, March 13, PM. Hi Daniel Tried to add the [user]. I try to dig into this matter, hope I come up with something useful. Hope you can access the file. Wednesday, March 14, AM. Hi Jesper, I can't get it to work, also I have some compatibility problems as I have Access and yours is build in Access Thursday, March 15, PM.
Hi Daniel I have taken a step back and removed all VBA from the DB and changed it to open the report based on what is selected in a dropdown list on the Open report Form. AIdzclOPzH1eD-c I do not get that error message "The expressions is typed incorrectly, or is too complex to be evaluated" at all but I checked just to be sure and I have not been able to find any data type inconsistencies in any of the queries.
Hope this can bring us to a resolution. Saturday, March 17, AM. Hi Jesper, Thanks for doing this, but unfortunately I receive a message that the "item not exists or is no longer available" message when trying to open the link to SkyDrive.
Maybe try again. Saturday, March 17, PM. Hi Daniel That works perfect, thank you very much. Would the solution to that be like this? Hi Jesper, You don't need to set the filter for the Report, you can leave that out of the code for both Reports, as your already use the Form parameters. I was playing with some of those properties, and forget to leave that out, it has no affect. I was just kidding about owing me something, glad to help you out!
You can handle this with the. HasData property of your Report. EOF Me. I have the same question 5. Report abuse. Details required :. Cancel Submit. Tom van Stiphout MVP. No, I just tried it and works just fine for me. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to Tom van Stiphout's post on October 23, Thank you Tom for your quick reply and for checking the code!
I'm assuming that you have the latest Acrobat Reader on your machine? If that's the case, we may have to put in a request to our IT department to look into my colleague's computer. Ken Sheridan. I don't see that the Adobe Acrobat Reader version would have any bearing on the matter, or even whether Acrobat Reader is installed or not. I have a similar routine for outputting invoices as PDF files in one of my demos.
0コメント