Opening Specific Page of Pdf File
Posted On 30 Mar 2012 By a.p.r.pillai. Under Utilities.
Opening an external file (Word, Excel or Adobe .pdf file) from Microsoft Access is not a big issue. We can use the HyperLink tool (Ctrl+K) to browse and find a ... Continue Reading
No Comments
Centralized Error Handler and Error Log
Posted On 11 Mar 2012 By a.p.r.pillai. Under Utilities.
In an earlier article with the VBA Utility program we have seen how to scan through a VBA Module (both Standard Module and Form/Report Modules – Class Modules) and insert ... 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
2 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
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
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
GetRows Function and Exporting Data
Posted On 25 Dec 2010 By a.p.r.pillai. Under Utilities.
We are going to create a useful data export utility with the GetRows() method of the Recordset Object. The GetRows method is used for loading the entire set of data ... Continue Reading
No Comments
Unsecured Database and Users Log
Posted On 31 Jul 2009 By a.p.r.pillai. Under Utilities.
When Data Entry or Editing actions are performed on important Tables in Databases a Time-Stamp with User Name is normally saved on each record to mark that event. This is done through the Form's Before Update Event Procedure. A sample procedure is given below:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me![EditedBy] = CurrentUser
Me![EditedDt] = Now
End SubNo Comments
Filter by Character and Sort
Search, Find, Filter and Sort operations are necessary to organize data into manageable form so that finding required information becomes easy. We have seen some of these actions through the following earlier Posts Titled:
Find or Filter Data on Form
Filtering Data for different Users
Animating Label on Search Success
2 Comments
MS-Access and Reference Library
Posted On 27 Mar 2009 By a.p.r.pillai. Under Utilities.
We are using several Object Libraries besides the default References Library during the course of developing an Access Database. Microsoft Data Access Objects (DAO), Microsoft ActiveX Data Objects (ADODB), Visual Basic for Application (VBA) and so on. These are essential to create Data Processing Routines in VBA.
No Comments
REPAIRING COMPACTING DATABASE WITH VBA
As far as Microsoft Access is concerned compacting the Database is an essential function to keep the Database size to the minimum. When you work with the Database MS-Access creates ... Continue Reading
3 Comments
Database Daily Backup
Posted On 01 May 2008 By a.p.r.pillai. Under Utilities.
If your Database is installed on a Network then a regular server backup is done on a Daily/Weekly/Monthly/Quarterly basis by the Network Team and kept in Fire-proof Cabinets away from ... Continue Reading
55 Comments
Keyboard Shortcuts
Posted On 22 Dec 2007 By a.p.r.pillai. Under Utilities.
Keyboard Shortcuts are very useful, if practiced and memorized, for frequently used actions without shifting back and forth between mouse and keyboard. Microsoft Access has an extensive list of Keyboard ... Continue Reading
6 Comments
Who is Online
Posted On 07 Dec 2007 By a.p.r.pillai. Under Utilities.
As we already knew we can install Access Database on a Local Area Network (LAN) and several Users can work on it at the same time. But it is difficult ... Continue Reading
22 Comments
