Go to Top

Blog Archives

I purchased the Report Generator, how do I use it with my existing Access database?

Congrats on purchasing our product! In order to use the system in your database you only need to import the following objects from the Report Generator to your database: frmReportGenerator frmCriteria frmCriteriaAssignment frmReports tblReports tblReportCriteria tblReportCriterias You will need to delete the reports already in tblReports and replace it with yours following instructions in “How do I add reports…” on this page.

Is Outlook the only way to email a report?

In order to email a report from the Report Generator you will need to have Outlook configured and have it be able to send/receive emails. If you don’t use Outlook select the PDF output option and email using another process such as Gmail or Yahoo by creating an email and attaching the PDF manually.

How can I get a report to use a custom title?

In order to have a custom title in your report that you are adding to the system follow these steps: Place your report in Design View. Make sure your report has a label in the Report Header section and name it lblReportLabel. Select the Report Header band and bring up the property sheet. Click on the Event tab and then on the On Format method.

How can I add a new criteria to the system?

First, always backup your Access database prior to making any changes. Second, place the frmReportGenerator in design view. The easiest way add a new criteria is to copy an existing one, so if you have data criteria, copy txtStartDate, if its a combo box, copy the ProductID object. If all you need is a regular text field, copy the JobNumber object. You must change your new field name by going …Read More

How do I add a report to the Report Generator?

Create your report like you normally would, than once you have verified the report is working correctly, follow these steps: Add your report using the form frmReports. In the field ReportID enter the file name of your report used in Access. In the Report Name field you will type the name users will see. For example, if your report file name is rptSales, than enter rptSales in the ReportID and …Read More

What are the criteria that come with the Report Generator?

Criteria are at the heart of the Report Generator, with the right combination of criteria you will be able to use the same report under a wide range of conditions. The report generator already comes with several criteria for immediate use, but you don’t have to use any of them if you don’t need to, and instead use the criteria of your choice. Here’s what each mean: txtStartDate – Use this …Read More

Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.