ChDir and IN Clause of Access Query
Posted On 14 May 2012 By a.p.r.pillai. Under Functions.
Last week we have learned how to change the Directory Path control of VBA to the CurrentProject.Path (active database’s location) with the use of ChDrive() and ChDir() Commands, without altering ... Continue Reading
No Comments
Microsoft DOS Commands in VBA-2
Posted On 05 May 2012 By a.p.r.pillai. Under Functions.
With the MkDir() Command we were able to create a folder on disk, with the help of a small VBA routine that we have written last week. We don’t even ... Continue Reading
No Comments
Microsoft DOS Commands in VBA
Posted On 24 Apr 2012 By a.p.r.pillai. Under Functions.
Continued from last week’s Article: Disk Operating System Commands in VBA. Once we determine the presence of a file in a folder with the Dir() Command we can do ... Continue Reading
No Comments
Disk Operating System Commands in VBA
Posted On 13 Apr 2012 By a.p.r.pillai. Under Functions.
The first edition of Microsoft Disk Operating System (MS-DOS 1.0) was launched in 1982. The first edition of Microsoft Windows 1.0 Operating System, Disk Operating system with Graphical User Interface ... Continue Reading
No Comments
Happy Easter to all our Readers
Posted On 07 Apr 2012 By a.p.r.pillai. Under Uncategorized.
Easter is a good time to enjoy all of your many meaningful blessings: family, friends, and of course chocolate molded into tasty bunnies. ... Continue Reading
No Comments
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
Calculating Time Difference
Posted On 21 Mar 2012 By a.p.r.pillai. Under Functions.
How do we calculate difference of time in Hours, Minutes and Seconds between two time period? The time period can be on the same date or across dates. ... 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
Changing Font Color Conditional Formatting
Posted On 29 Feb 2012 By a.p.r.pillai. Under How Tos.
With conditional formatting feature of Microsoft Access we can apply up to three colors to the font or background of a Textbox, because only three set of conditions can be ... Continue Reading
1 Comments
Duplicating fields with Conditional Formatting
Posted On 12 Feb 2012 By a.p.r.pillai. Under Forms.
To make data entry task faster in Microsoft Access we duplicate certain field values (Ctrl+”) to bring them forward to the current record from previous record field, wherever it become ... Continue Reading
No Comments
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
2 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
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
