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
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
2 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
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
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
Invoke Word Mail Merge from Access2007
Posted On 29 Apr 2011 By a.p.r.pillai. Under How Tos.
Mail Merge is a powerful feature in Microsoft Word for creating and printing form letters. For example: Employment Contracts with fixed employment terms but with changing personal details, like name, ... Continue Reading
No Comments
Join Split Array Functions-2
This is the continuation of last week's Article: Join Split Array Functions If you have not gone through the fundamentals of the above functions then please do that, by ... Continue Reading
No Comments
Create your own color palette
Posted On 14 Oct 2010 By a.p.r.pillai. Under How Tos.
We have learned Binary, Octal & Hexadecimal Numbering Systems and learned few simple rules by which we can devise new numbering systems with any Base value, provided the user knows ... Continue Reading
No Comments
Colors 24 Bits and Binary Conversion
If you were following the last four Articles on Numbering Systems (Decimal, Binary, Octal and Hexadecimal) then here is something for you to play with. Before that following is the ... Continue Reading
No Comments
Hexadecimal Numbering System
Posted On 28 Sep 2010 By a.p.r.pillai. Under How Tos.
This is the continuation of earlier Articles: Learn Binary Numbering System Learn Binary Numbering System-2 Octal Numbering System ... Continue Reading
No Comments
Octal Numbering System
Posted On 23 Sep 2010 By a.p.r.pillai. Under How Tos.
This is the continuation of earlier Articles: 1. Learn Binary Numbering System. 2. Learn Binary Numbering System-2. Please go through the earlier Articles before continuing. . . ... Continue Reading
No Comments
Learn Binary Numbering System-2
Posted On 15 Sep 2010 By a.p.r.pillai. Under How Tos.
This is the continuation of last week's Article Learn Binary Numbering System Last week we have gone through the fundamentals of Binary Numbering System and learned how to convert decimal ... Continue Reading
1 Comments
Learn Binary Numbering System
Posted On 07 Sep 2010 By a.p.r.pillai. Under How Tos.
Are you afraid of learning Computer's own language, the Binary Numbering System. I suppose you are not! If you are a Computer Programmer or intend to become one then I ... Continue Reading
3 Comments
User Defined Data Type
VBA have several predefined data types like Integer, String, Date and so on to use in Programs. These can be used to hold only one type of data in them. ... Continue Reading
No Comments
Date and Time Values
Posted On 14 Jul 2010 By a.p.r.pillai. Under How Tos.
Technorati Tags: Microsoft MS-Access have Date/Time Data Field Type to store Date or Time or both Date and Time together. When you enter a Date Value ... Continue Reading
No Comments
Microsoft Excel Power in MS-Access
Posted On 07 Aug 2009 By a.p.r.pillai. Under How Tos.
There are times that Microsoft Access Application Users ask for Report Data exported into Excel so that they can work on it and do their own customized analysis. In this case we can create a Macro with the Macro Command OutputTo or Visual Basic Docmd to export the Data from a Table or Query and open the Data in Excel automatically.
3 Comments
MICROSOFT ACCESS HOW TOS
Posted On 06 Dec 2006 By a.p.r.pillai. Under How Tos.
IMPLEMENTING MICROSOFT ACCESS SECURITY MICROSOFT ACCESS SECURITY OVERVIEWCreating a User Account Creating a Group Account Add Users to Security Groups Remove Users from Security Groups Deleting a User-Account Deleting ... Continue Reading
4 Comments
DISPLAY PATH AND FILE INFO
Posted On 06 Dec 2006 By a.p.r.pillai. Under How Tos.
Displaying Path & File InfoSub ShowFileAccessInfo2()
Dim fs, d, f, s
On Error Goto ShowFileAccessInfo2_Err
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.Getfile("C:\mytext.txt")
s = UCase(f.Path) & vbCrLf
s ... Continue Reading
No Comments
RENAME FILE USING FILESYSTEMOBJECT
Posted On 06 Dec 2006 By a.p.r.pillai. Under How Tos.
Renaming a file and displaying Drive & File Information
Sub ShowFileAccessInfo()
Dim fs, f, s
On Error GoTo ShowFileAccessInfo_Err
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.Getfile("C:\mytext.txt")
s ... Continue Reading
No Comments
CREATE TEXT FILE FROM MSACCESS
Posted On 06 Dec 2006 By a.p.r.pillai. Under How Tos.
HOW TO CREATE A TEXT FILE FROM MICROSOFT ACCESS
The FileSystemObject Object provides access to a the computer's file system.The following code illustrates how the FileSystemObject is used to return a ... Continue Reading
5 Comments
CREATE EXCEL WORD FILE FROM ACCESS
Posted On 04 Dec 2006 By a.p.r.pillai. Under How Tos.
CREATE EXCEL OR WORD FILE FROM ACCESS
Create Excel File or Word Document from Microsoft Access and write information into them. Every application that supports Automation provides at ... Continue Reading
1 Comments
