Recent content by HAP_Paul

Thank you both for your usefull reply. Based on this, I was able to minimze the run time!

Hi all, I have a table where comments related to a specific test are divided in several lines. For practical reasons, I want to have a table where these comments are combined. So some thing like table 2. Table 1 (original) ID | Test-ID | Comment-ID | Comment...

Is there a way to check for legitimate versus non-legitimate version of Access by VBA? I have noticed a couple of times that my application (which is sold to many, many customers) may give errors if the user has a non-legitimate version of Access 2010. When I install Access Runtime 2007, the...

Just tried DoCmd.OutputTo acOutputReport, StrReport, "PDF Format (*.pdf)", StrDocumentName, False Unfortunately without success. I get the same error message.

No, I do not think the format should be "PDF Format (*.pdf)". With "PDFFormat(*.pdf)", I do not get this error when this database (mde format) is used on an other machine. Besides that, as I initially stated, I get the same error when exporting to PDF manually. So I do not think the cause is in...

Yes, I know. In fact, it is already like that. For some reason, during copying the code, the quotes have changed. So, this is not the cause of the problem.

Hi all, Despite googling and searching for solutions for many days, I keep having a problem. I know it has been discussed before, but I cannot find a solution for my case. It is really driving me nuts. One of the users of my application, reports an error when saving a report to pdf by VBA...