Access Report keep a group together in one page

This Access tutorial explains how to keep a group together in one page in Access Report. You may also want to read: Access Report group by date problem Access Report - keep a group together in one page In Access Report, you can group a Field and then display the grouping in Group Header, and display the value in Details. Sometimes the Details may be so long that it extends to the next page, breaking up the same group into two pages. Access Report has a function called "group together i...
More

Access link to external ODBC data source

This tutorial shows how to link Access to external ODBC data source. Access link to external ODBC data source ODBC (Open Database Connectivity) is a standard programming language middleware API for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. The reason for connecting Access to ODBC is that Access can directly get database data once the connection is setup, saving a lot of time to make  Query thro...
More

Access Report – hide Subreport if no data

This Access tutorial explains how to hide Subreport if no data. You may also want to read: Access Report reset total page number and insert blank page Access Report page break by Group and add blank page Hide Access Subreport if no data Assume that you have a Master Report called Report A, the figures are displayed in Group Header. Now you have a Subreport called B and you want to display data for each Group Header. Drag Report B to A and define the joined Fields. As you...
More

Access Record Source Control Source Row Source Difference

This tutorial explains difference among Record Source, Control Source, Row Source in Access Report and Form. Difference among Record Source, Control Source, Row Source In Access Report and Form, there are three different data sources, which can be very confusing for starter. Record Source Record Source is a Property of  Report and Form, it is the data source that you want to appear in Report and Form. Record Source can be SQL statement, Table, Query. Record Source can have more than one F...
More

Vertical line in Access Report using Line Method

This tutorial explains how to add vertical line in Access Report using VBA Line function, while the line tool fails to draw a continuous vertical line. Issue with using Line tool to add vertical line in Access Report Vertical line in Access Report is one of the hottest topic in this website. In Access Report, it is possible draw a vertical straight line using "Line" tool under  "Design". However, the line is not continuous across  records. Lets take a look at what I mean the line is n...
More