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
Input Masks and Data Entry
Posted On 19 Jun 2010 By a.p.r.pillai. Under Accesstips.
Technorati Tags: microsoft Input masks are special group of characters that can be used in the InputMask Property of data fields to make data entry work easier ... Continue Reading
3 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
Days in Month Function
Posted On 24 Apr 2008 By a.p.r.pillai. Under Functions.
Function to Calculate Number of Days
The User-Defined Function DaysM() given below can be used in calculations that involves the number of days of a particular month. Copy and Paste the ... Continue Reading
No Comments
Who changed the Data
Posted On 18 Jan 2008 By a.p.r.pillai. Under Accesstips.
Who changed the data? This question comes up when something found not in order with the information kept in the database and ended up with serious issues reaching out to ... Continue Reading
1 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
Find or Filter Data on Form
Posted On 14 Dec 2007 By a.p.r.pillai. Under Forms.
When I started learning Microsoft Access in 1996 the first challenge that I have faced was how to find a particular record on the Data Editing Screen or Filter a ... Continue Reading
4 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
SHADOW3D HEADING STYLE
This is the continuation of a series of different 3D-Heading-Styles introduced for designing Microsoft Access Form/Report Headings. This design is a variant of the 3D-Heading Style presented under the Title ... Continue Reading
No Comments
BORDER3D HEADING
If you have landed straight into this Page please refer my earlier Posts: Command-Button Animation to link the essential Library Files (the list of files and explains how to attach ... Continue Reading
No Comments
Border2D Heading Text
MS-Access Forms & Report Design Tools are very easy to use and needs only little practice to master them. But creating Controls like the above manualy is very difficult. The ... Continue Reading
No Comments
CREATE 3D-HEADINGS ON FORMS
Form/Report Heading Text with the above Design can be created within seconds filling-in your own text and forecolor of your choice. Even though you can do it manually by copying ... Continue Reading
2 Comments
