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.
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
0 Views
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
Multiple Parameters For Query
Posted On 24 Oct 2008 By a.p.r.pillai. Under Queries.
Queries are an essential element in data processing and we use them a lot in various ways. While creating Queries the main issue we are faced with is how to ... Continue Reading
2 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
MS-Access and Mail Merge
Posted On 04 Oct 2007 By a.p.r.pillai. Under Reports.
Address Labels
When we talk about Address Labels, Form Letters, Mail Merge and so on, the name that comes into our mind is MS-Word, loaded with plenty of functions for the ... Continue Reading
2 Comments
MS-Access Object Documenter
Posted On 26 Sep 2007 By a.p.r.pillai. Under Reports.
We normally prepare Reports on processed or raw data and take print outs to share the information with others.
But, there are times that we need details of the database Objects: ... Continue Reading
No Comments
Useful Report Functions
Common Functions that you can use in Report Header or Footer Sections, while designing Reports, are given below. Copy and Paste the VB Code into a Global Module of your ... Continue Reading
3 Comments
Reminder POPUPs
Posted On 12 Sep 2007 By a.p.r.pillai. Under Emails and Alerts.
The Reminder Popup is a Report that opens and displays its contents automatically and plays a background sound to remind about something that needs the User's immediate attention. The Report ... Continue Reading
2 Comments
Reports – Page Border
Posted On 23 Aug 2007 By a.p.r.pillai. Under Reports.
Drawing a Page Border is very easy in MS-Word and it is part of the Formatting Options and different artistic styles are also available. But when it comes to MS-Access ... Continue Reading
1 Comments
Highlighting Reports
Posted On 16 Aug 2007 By a.p.r.pillai. Under Reports.
Analysis of data stored in Tables and providing resultant information in the form of Reports to the outside world is an important function of any Database Management System.
An Access Application ... Continue Reading
No Comments
