How to Use Form Filter on Report
Posted On 31 Jan 2012 By a.p.r.pillai. Under Reports.
Normally we use a Query or processed data table as Report Source for printing selected data items, like Customer Invoices or Customer Ledger Statement etc. How do we take ... Continue Reading
No Comments
Creating Watermark on MS-Access Reports
Posted On 17 Jul 2011 By a.p.r.pillai. Under Reports.
No matter what kind of database design you plan for your Company, reports (in text or Chart form) are the main output the external users expect from the application. The ... Continue Reading
No Comments
Continued on Page 2 on Report
Posted On 17 May 2011 By a.p.r.pillai. Under Reports.
Normally, MS-Access Reports can run into several pages and it is a custom to give page numbers on each page along with the total number of pages as an indicator. ... Continue Reading
No Comments
Easy-Read Reports
Posted On 24 Mar 2011 By a.p.r.pillai. Under Reports.
When Computer Reports; like Accounting Ledger Statements or Purchase Invoices are printed with closely positioned lines. It is easy to read if alternate line background is shaded with a light ... Continue Reading
No Comments
Percentage on Report Summary
Posted On 13 Feb 2011 By a.p.r.pillai. Under Reports.
We have worked with a Query to solve this problem earlier in the Blog Post: Percentage on Total Query. This time let us see how it is done on a ... Continue Reading
No Comments
Embedded Macros in Access2007
Posted On 29 Jan 2011 By a.p.r.pillai. Under Reports.
There is only one difference between the stand alone Macros and embedded macro; they will not appear in the navigation pane under Macros Group. They are written directly on Forms/Reports ... Continue Reading
No Comments
Report Design in Access2007
Posted On 20 Jan 2011 By a.p.r.pillai. Under Reports.
In Microsoft Access 2007 there are some interesting design time features; Report View (not Print Preview) and Layout View besides Design View and Print Preview. These two new views allows ... Continue Reading
No Comments
Form and Report Open Arguments
Posted On 05 Feb 2010 By a.p.r.pillai. Under Reports.
While opening a Report or Form we can pass several Optional Values as Run-Time Arguments to control the output on the Report or to change the Form Open Mode depending on the User's Profile.
3 Comments
Msaccess Report and Page Totals
Posted On 24 Jul 2009 By a.p.r.pillai. Under Reports.
Ms-Access Functions Sum, Count, Avg etc. cannot be used in Page Header or Footer Areas of Reports for creating Page-wise Summary Values. These will work in Report Group Header/Footer or in Report Header/Footer areas only.
1 Comments
Detail and Summary from same Report
Posted On 17 Jul 2009 By a.p.r.pillai. Under Reports.
You don't have to design two different Reports; one for Detail Listing of records with Group-wise Totals and another one for Group-wise Totals alone. We can play a small trick to get both outputs from the same Report depending on the User's choice.
Recommended reading before proceeding with this topic:
Hiding Report Lines Conditionally
Hiding Records and Group Footer Calculations
Hiding Group Header/Footer and Detail Sections
For hiding of Report Lines conditionally there are other methods too. For example the following VBA Code (instead of the earlier simple method we have tried) can give you the same result for hiding Detail Section Report Lines:
No Comments
Hiding Report Lines Conditionally-3
Posted On 09 Jul 2009 By a.p.r.pillai. Under Reports.
This is the continuation of two Articles published earlier on this Subject. You may go through them by following the links given below before continuing from here.
We have learned how to hide Report items conditionally and calculate Sub-Totals and Report Footer Totals in Code by excluding values of those records we have removed from the Report Detail Section. We have updated the calculated values in Group Footer and Report Footer Section Controls.
1 Comments
Hiding Report Lines Conditionally-2
Posted On 03 Jul 2009 By a.p.r.pillai. Under Reports.
Last week, we have started the topic of hiding Report Detail Section data lines and worked through a simple example as well. But, we have not yet seen how this action affects the normal calculations on the Report, like calculating Group-wise Sub-Totals or Report Footer Totals.
No Comments
Hiding Report Lines Conditionally
Posted On 26 Jun 2009 By a.p.r.pillai. Under Reports.
Hiding Report lines or Report Sections conditionally at run time may not be an every day requirement. But, it is interesting to know how to do it, if it becomes necessary, with the help of Programs. One thing I like very much about MS-Access Report is its ability to write programs on the Report itself, especially for highlighting very critical information on the Report so that the attention of Users can be drawn to specific information on it. You can see an interesting and useful example in one of the earlier Posts with the Title: Highlighting Reports.
No Comments
Network And Print Page Setup-3
Posted On 19 Jun 2009 By a.p.r.pillai. Under Reports.
Shared MS-Access Reports are normally designed for a particular Printer on the Network. When Users attempt to print this Report on a different Printer the Report will change to the default Page Settings of that Printer, like Paper Size, Page Orientation and others and the Report may not print correctly.
No Comments
Network And Print Page Setup-2
Posted On 12 Jun 2009 By a.p.r.pillai. Under Reports.
We have seen in the earlier Article how to change Paper Size and Page Orientation of MS-Access Reports automatically through program for any Printer on the Network. We have copied PrtDevMode Property Values into Memory; modified them to match the Paper Size and Page Orientation of the Report and updated them back into the Report Page Settings before printing it on the default Printer installed on the User�s Machine.
No Comments
Network And Report Page Setup
Posted On 05 Jun 2009 By a.p.r.pillai. Under Reports.
When MS-Access Application is installed on a Network; Security is one of the major issues that the Database Developer has to tackle. This includes security of data and objects within the Database and the Database file itself. To learn more about securing a Database on Network click here.
No Comments
Textbox And Label Inner Margins
Posted On 31 Oct 2008 By a.p.r.pillai. Under Reports.
Let it be a Form or Report, a good design will always catch the eye of the User and the onlooker alike. We all design them, but if we give ... Continue Reading
1 Comments
No Data and Report Error
Posted On 28 Sep 2008 By a.p.r.pillai. Under Reports.
Report Source Query or Table can end up with no output records. In that case some of the controls with formula on the Report will show #Error on them. An ... Continue Reading
No Comments
Dynamic Report
Posted On 26 Oct 2007 By a.p.r.pillai. Under Reports.
Report designing in MS-Access is very easy as we already know. Once we setup a procedure to run the macros/programs to prepare the data for a standard Report, all we ... Continue Reading
6 Comments
MS-Access and Mail Merge-3
Posted On 18 Oct 2007 By a.p.r.pillai. Under Reports.
Continued from previous Post MS-Access and Mail Merge-2.
MAIL MERGE IN MS-ACCESS
We have already designed and tried the Form Letter preparation procedure through the earlier article. We need all those Objects ... Continue Reading
No Comments
MS-Access and Mail Merge-2
Posted On 11 Oct 2007 By a.p.r.pillai. Under Reports.
Form Letters
A Form Letter can be anything like an Invitation to the Members of a Club or a Notice to the Share Holders of the Company or a Circular to ... Continue Reading
No Comments
