Recent content by TomSD

Hi thank you for your response! I just found a solution to my problem by using a crosstab query. For the sake of clarity, what I wanted to do is: For each company, show whether a Check has been performed. No user interaction needed. I managed to solve this as follows: Create a query...

Hello I've a table "Check" and a table "Company". In the table Check, there are some general checks listed that need to be done when a new company is added (ie: did we get approval to add the company; did we use form X; did we do a background check). In the future, there might be some other...

That's indeed important to keep in mind. However, as nearly all reports are +/- 254 KB, the risk of reaching the 2 GB limit anytime soon is quite limited. I'm planning to implement a sub that'll email and delete pdf's older than X days. In my case, I believe this might be a good solution.

Thanks, that works like a charm! In case this code can help someone else: note that StrReportName should be the name of the report in your Access database, and not what you'd like the name to be. Which makes sense but still took me some minutes to figure out.

While this would be easier, it's not what I'm looking for. The reports would be stored on a network drive, and the risk that someone accidentally deletes a report without anyone noticing would be quite high.

I get a "User-defined type not defined" error on the bm declaration. Any ideas? I'm using Access 2013.

I'm not entirely sure what you mean? Currently, I've a report with an ExportWithFormatting macro bound to the on load event. I've a table as well and that indeed has a field "Report" with data type Attachment.

Indeed, a report can be saved as a pdf. However I'm wondering whether a report can be saved as a pdf and then stored in the access database itself without the user interfering. It's possible to save a report as a pdf, and then manually add the pdf as an attachment in a table. However I'm...

Hello I'm wondering whether it's possible to generate a pdf from a report and save the report to the database without the user having to interfere (except for opening a form). Any ideas?