Question:
I understand that it is possible to print reports stored in a backend Access .mdb file from Visual Basic. Is it possible, and if so, how is it done?
Answer:
VideoSoft is actually coming out with a control that is able to do this.Here’s a description of the product from them…I’ll be doing a review onthe product fairly soon. There is also a way to trigger Access to printthe report, but that only works when you have a full copy of Access on themachine. VSREPORTS will work without having a copy of Access installed. —VideoSoft VSREPORTS is the reporting tool that allows you to print MicrosoftAccess created reports without having Access installed on the user’smachine. This ActiveX control permits you to use the industry leading reportdesigner, Access, to create your reports and then print them using VisualBasic or any ActiveX container.VideoSoft VSReports gives you the ability to print reports created inMicrosoft Accesswithout having to distribute any Access runtime DLLs.Now you can print them in Visual Basic using VSReports! Place a VSReportsActiveX control on your form, set a few properties, and presto! Your Accessreport is ready to be printed.VideoSoft VSReports re-creates Access reports reproducing the exactpositioning offields and page breaks, fonts, colors, sorting, and filtering into groups andsections, just as in the original report.VideoSoft VSReports automatically supports all Access Report Writerfeatures includingVisual Basic for Applications (VBA) expressions, aggregated fields, andwatermarks. Multi-Column and parameterized reports are supported as well. VideoSoft VSReports dynamically reads the data at runtime from Access orany ODBCdatabase such as Oracle, Sybase, or VSData.
