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
Saving Report Pages as separate PDF Files
Posted On 20 Jan 2012 By a.p.r.pillai. Under Utilities.
You are printing several Customer Invoices as a single Report, running into several pages. You have problems with this kind of Reports in segregating the Invoices and physically mailing them ... Continue Reading
No Comments
AutoNumber with Date and Sequence Number
Posted On 10 Jan 2012 By a.p.r.pillai. Under How Tos.
We always make use the Autonumber feature in tables to create a unique ID field for the table. It is easy to define and always starts the auto-number with 1 ... Continue Reading
No Comments
Assigning Module Level Error Trap Routines
Posted On 27 Dec 2011 By a.p.r.pillai. Under Utilities.
Last week I have introduced a Function to insert Error Handling lines into a VBA Function or Sub-Routine automatically. Readers commented saying that it is a good utility but its ... Continue Reading
No Comments
Technorati Verification Page
Posted On 26 Dec 2011 By a.p.r.pillai. Under Uncategorized.
This page is published specifically for verifying Technorati MVBS6AUTXJRZ verification code. After which this will be removed. ... Continue Reading
No Comments
Merry Christmas and Happy New Year
Posted On 24 Dec 2011 By a.p.r.pillai. Under Uncategorized.
Flash Card Courtesy: www.123greetings.com History of Christmas On December 25, Christians traditionally celebrate the birth of Christ. The origins of the holiday are uncertain, however by the year ... Continue Reading
No Comments
Utility for inserting VBA Error Handler Code
Posted On 15 Dec 2011 By a.p.r.pillai. Under Utilities.
We have tried few examples on working with VBA Module Object Properties and Methods. We have learned how to insert a Sub-Routine into a Form Module with expression.InsertLines() method of ... Continue Reading
2 Comments
Prepare a List of Procedure Names from a Module
Posted On 07 Dec 2011 By a.p.r.pillai. Under Utilities.
How to prepare a list of Procedure Names (Function or Sub-Routine Names) from a Standard Module or Class Module? Earlier Articles: Writing Code with ... Continue Reading
No Comments
VBA Module Object and Methods
Posted On 27 Nov 2011 By a.p.r.pillai. Under Utilities.
VBA Module Object have several interesting methods and properties. Last week we have seen how to insert a Click Event Procedure in a Form Module with a Function. You can ... Continue Reading
No Comments
Writing VBA-Code with VBA
Posted On 20 Nov 2011 By a.p.r.pillai. Under Functions.
To insert an Event Procedure in a Form or Report we will open the VBA Module and write the code manually. If we open the Class Module through the Event ... Continue Reading
No Comments
Control SetFocus on Tab Page Click
Posted On 10 Nov 2011 By a.p.r.pillai. Under Forms.
"When I Click on a Tab Control Page I want to set focus on a particular Text box on that page, not on the first Text box on the Tab ... Continue Reading
No Comments
Adding Data directly into External Databases
Posted On 31 Oct 2011 By a.p.r.pillai. Under Queries.
Back-End to Front-End database designs are common in MS-Access . Back-end can be MS-Access, dBase, SQL Server, Excel or Paradox databases with their linked Tables. Once the tables are linked ... Continue Reading
1 Comments
Users and Groups Listing from Workgroup Information File
Posted On 24 Oct 2011 By a.p.r.pillai. Under MS-Access Security.
How about taking a print out of Users and Groups from the active Workgroup Information File (Microsoft Access Security File)? This is only for users of Microsoft Access 2003 ... Continue Reading
No Comments
Access Security Key Diagram
Posted On 17 Oct 2011 By a.p.r.pillai. Under MS-Access Security.
As you are aware implementing Microsoft Access Security is serious business. Even though this has been deprecated from Access2007 and later versions, thousands of Access Developers are still using this ... Continue Reading
No Comments
Updating Sub-Form Recordset from Main Form
Posted On 10 Oct 2011 By a.p.r.pillai. Under Forms.
Sub-Form on a Main Form is the common design that we follow to display several related records of the record on the Main Form. Order Detail records related to Orders, ... Continue Reading
No Comments
Easy Reference Access2003 Commands in Access2007
Posted On 01 Oct 2011 By a.p.r.pillai. Under How Tos.
You are very familiar with Access2003 Menus and Toolbars. Design tasks are so easy when you know what to look for and where they can be located. Everything runs so ... Continue Reading
No Comments
IIF vs SWITCH Function in MS-Access
Posted On 25 Sep 2011 By a.p.r.pillai. Under Functions.
The IIF() Function definition is reproduced here from Microsoft Visual Basic for Applicatiions Reference below: IIf Function Returns one of two parts, depending on the ... Continue Reading
3 Comments
Preparing Rank List
Posted On 14 Sep 2011 By a.p.r.pillai. Under Utilities.
We use Autonumber Field in a Table to create automatic sequence numbers for each record entered into the Table. This can be defined as Primary Key field. Related Table field ... Continue Reading
No Comments
Happy Onam to all our Readers
Posted On 09 Sep 2011 By a.p.r.pillai. Under External Links.
Image Source: www.dgreetings.com പുന്നെല്ലടകൊണ്ടടപ്രഥമന് - അതില് പൊന്തിക്കിടക്കുന്ന നാളികേരത്തുണ്ട് നെയ്യില് വറുത്തിട്ട മുന്തിരി.. അണ്ടിപ്പരിപ്പുകള് കണ്ണൊന്നിറുക്കി ; ... Continue Reading
No Comments
Restoring disabled Full Menus Access2007
Posted On 31 Aug 2011 By a.p.r.pillai. Under How Tos.
When you develop an application, even if it is for your own use, always consider that each object you design is for someone else use. Then only we will be ... Continue Reading
No Comments
Running Workgroup Admin in Access2007
Posted On 16 Aug 2011 By a.p.r.pillai. Under Uncategorized.
If you are serious about Microsoft Access User-level Security in earlier versions (.mdb files) of Access Databases and would like to continue using them in Access2007, with the security settings ... Continue Reading
No Comments
Apply Filter to Table directly
Posted On 09 Aug 2011 By a.p.r.pillai. Under How Tos.
Normally we use Filter settings on Forms/Reports to extract records on specific conditions. This can be achieved in several ways like adding a WHERE Condition (without the clause WHERE) in ... Continue Reading
2 Comments
Download Free Software:Desktop Utilities, Mobile Communication, Games etc.
