Reporting from microsoft access

Hello, I have a access report several actually that I would like to run without opening it and save automatically as a PDF to my desktop. Thank you, Molly. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

I have the same question 0. Report abuse. Details required :. However, when you double-click a report in the database window to view it, Access displays the printable version of the report in the Print Preview window. This window displays the report as it will be printed and does not contain any child controls that provide access to report data. So, how do you retrieve the data from the report? This approach may be difficult to implement because you will have to code scrolling operations and determine coordinates of the rectangles holding the desired text.

Also, the recognition may produce incorrect results for wrapped lines. Another possible solution is to export the report data to a file and then analyze the exported data.

This approach is easier to implement and it does not depend on the way the data is displayed no "text wrapping" problems. Below you will see how you can export a report and obtain data from a file. In further explanations, I will use the Summary of Sales by Year report from the Northwind database that is shipped with Microsoft Access We will export the report to an HTML file. Why HTML? I tried other formats and found that To export the report to the HTML format, follow these steps you can even record a script to automate the exporting actions in the future :.

Now you can parse the file to obtain the report data and retrieve summary values from it. To parse the file, we will use TestComplete's WebTesting plug-in. Answered by:. Archived Forums. Sign in to vote. Monday, December 8, PM. Hello, Please read the following threads to know how to do it. Application" ie. Introduction to reports in Access.

Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow.

No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! This is where you place the controls that make up the main body of the report. At the end of the report.