|
|
Finding Difference between Dates in rows of a Column
Posted On 26 Mar 2013 By a.p.r.pillai. Under Utilities.
Your Company have several Customers who places orders for Products regularly and you maintain the Orders detail data in an MS-Access Table. The management would like to know the frequency ... Continue Reading
8 Comments
Shifting Focus from one sub-form to the other.
Posted On 23 Jan 2013 By a.p.r.pillai. Under Forms.
Sample Form with two Sub-Forms: Last week we have seen how to set focus to a particular field in a sub-form from the main form. ... Continue Reading
No Comments
Setting Focus on a field inside a Sub-Form
Posted On 08 Jan 2013 By a.p.r.pillai. Under Forms.
A Main Form (frm_Students) have two Sub-Forms (frm_Sessions and frm_Payment) on it. A sample image of such a Form is given below: The sub-forms on ... Continue Reading
No Comments
Merry Christmas and Happy New Year 2013
Posted On 21 Dec 2012 By a.p.r.pillai. Under Uncategorized.
May your World be filled, With Warmth and Good Cheer, ... Continue Reading
No Comments
Conditional Formatting in Continuous Form
Posted On 18 Dec 2012 By a.p.r.pillai. Under How Tos.
Conditional formatting is a magical option to change color (background/foreground) of textbox controls on Forms or Report. The color change is possible when one or more field values meets a ... Continue Reading
No Comments
Autonumber with Date and Sequence Number-2
Posted On 04 Nov 2012 By a.p.r.pillai. Under Functions.
Perhaps you may be wondering, whey we need something different when there is an Autonumber feature already built-in into Microsoft Access? Well, the built-in feature may not be suitable for ... Continue Reading
No Comments
Command Button Color Change on Mouse Button-down Action
Posted On 14 Sep 2012 By a.p.r.pillai. Under Command Buttons.
After working with the Command Button and Message Box Controls of MS-Access I really got bored with their styles. So, I set out to do something about it and created ... Continue Reading
No Comments
Time-bound Form Mode Change
Posted On 28 Aug 2012 By a.p.r.pillai. Under Forms.
Allow data entry or editing on certain period of time otherwise lock the form for data view alone. The reason to do this may be for time-bound work schedules or ... Continue Reading
No Comments
Missing Lines in Line-Chart
Posted On 14 Aug 2012 By a.p.r.pillai. Under Graph Charts.
You spent several hours to prepare the data for your Line-Chart. Designed the Line-Chart on a Report with Title, Data Labels, Legends and it looks nice except one big problem ... Continue Reading
No Comments
Back Tracking Open Forms
Posted On 28 Jul 2012 By a.p.r.pillai. Under Forms.
On Internet we may open several web pages, by visiting links on web pages. When we do that we will be provided with buttons on the browser to move from ... Continue Reading
2 Comments
Stretching Controls when resizing Form View
Posted On 13 Jul 2012 By a.p.r.pillai. Under Forms.
Sample image of an Employees Form Design is given below: When you view this screen in a maximized Application Window, the view will ... Continue Reading
No Comments
Defining Pages on Form
Posted On 28 Jun 2012 By a.p.r.pillai. Under Forms.
When we design a Form we will limit the placement of form controls within the visible area on the screen. A Form’s dimension is 22 x 22 inches. So you ... Continue Reading
2 Comments
Accounting Year Week Calculations
Posted On 11 Jun 2012 By a.p.r.pillai. Under Functions.
Let us get straight into an issue in computerized calculations. Most companies maintain their Books of Accounts for the Accounting Year starting from April 1st and ending on March 31st, ... Continue Reading
No Comments
Deleting Folders with DOS Command
Posted On 27 May 2012 By a.p.r.pillai. Under Functions.
We have seen how to create folders with MkDir() DOS Command and learned how to change default folder control to the active database’s parent folder with ChDir() Command. If ... Continue Reading
No Comments
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
1 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
