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
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
Updating Sub-Form Recordset from Main Form
Posted On 10 Oct 2011 By a.p.r.pillai. Under Forms.
Sub-Form on a Main Form is the common design that we follow to display several related records of the record on the Main Form. Order Detail records related to Orders, ... Continue Reading
No Comments
Creating Animated Command Button with VBA
The first Blog post that I have written about is Command Button Animation method in September 2006 on this Website. I used this animation method in almost all my Projects. ... Continue Reading
No Comments
Data Change Monitoring
Posted On 25 May 2011 By a.p.r.pillai. Under Forms.
In secured environment (i.e. Databases implemented with Microsoft Access Security) several options are available to protect data from unauthorized changes by Users. With User-level security settings we can define clearly ... Continue Reading
1 Comments
Product Group Sequence with Auto Numbers
Posted On 07 May 2011 By a.p.r.pillai. Under Forms.
How to generate automatic sequence numbers for different Category of Products. See the sample data given below to understand the gravity of the problem more clearly: ... Continue Reading
No Comments
Create Menus with Macros
We have learned how to create Menus and Toolbars through Toolbars - ->Customize options earlier. If you would like to have a second look at them then the links are ... Continue Reading
No Comments
Lively Controls on Form
We always concentrate on timely completion of a Project and to deliver it to the Users as quickly as possible. When I am pressurized to complete a particular project I ... 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
Budgeting and Control
The local Charity Organization for Children allocate funds for disbursement to eligible individuals or entities under various categories. Accounts Section supervises the disbursement activities. It is part of the responsibility ... Continue Reading
4 Comments
Menus with Option Group Control
We can create cascading Menus with Tab Control and Option Group Controls on Form. Several Menus can be arranged neatly one behind the other and allow the User to make ... Continue Reading
2 Comments
Digital Clock on Main Switchboard
You may find several pieces of gadgets like Clocks, Wrist Watches and so on around you to check the Date and Time. How about inserting a Digital Clock into your ... Continue Reading
10 Comments
Label Animation Zoom-out Fade
Technorati Tags: msaccess animation Computer Programming is interesting because when you start doing something it will definitely lead to more than that and give you more ideas to try ... Continue Reading
No Comments
Label Animation in Colors
We have learned several label animation methods, through last few Posts dedicated to this topic, but we will try another trick, with the last design that you have created to ... Continue Reading
No Comments
Label Animation Zoom-in Style
This week we will learn a different style of Label Animation technique. Those who would like to have a look at the earlier simple label animation methods, the page links are given below to visit those pages:
No Comments
Label Animation Variant
I have several Label Animations Styles in store for you and we have already seen two of them through last two Articles:
Here, we will examine two variants of the last animation method we have tried last week. If you have gone through the procedures in creating the sample labels and programs then we can try the same animation method with slightly different settings of the labels.
No Comments
Label Animation Style-2
Last week we have learned a simple label animation method to display Employee Names, and made it to appear character by character from right side of the label to full view. The animated label gives the Form a lively look and makes it more interesting to the User to work with the Screen.
No Comments
Label Animation Style-1
A Form with lively Objects like Animated Command Buttons or Animated Giffs or Moving Text etc. makes it more interesting to the User to work with our MS-Access Applications. MS-Access doesn�t have any of those things built-in or ready made to use it quickly. Our imagination and ingenuity is the only tool available to create something with the existing strictly business like features provided in MS-Access.
No Comments
Microsoft Date Time Picker Control
Posted On 14 Feb 2010 By a.p.r.pillai. Under Forms.
We have learned how to use Calendar Control for easy entry of Date Values into Fields on Form through the earlier Article: Animated Floating Calendar. We have used a single Calendar Control for several Date Fields by moving the Calendar Control automatically near the selected Date Field with unfolding animation.
1 Comments
Web Browsing within Access Form
Posted On 28 Dec 2009 By a.p.r.pillai. Under Forms.
Browsing the World Wide Web is nothing new to us. But, how about organizing the Web Addresses of frequently visiting Websites in a Table and browse the Web from within an Access Form?
2 Comments
Save User Specific Parameter values
Posted On 06 Dec 2009 By a.p.r.pillai. Under Forms.
Last week we have prepared a Report Parameter Control Form for concurrent usage on Network without clashing with other User�s Report Data Filter Parameter Values, while preparing different Versions of the same Report. To do this we have discarded the usage of a Parameter Table as Record Source to the Parameter Form and created two Unbound Text Boxes for keying in Parameter Values for setting Filter condition in the Report Source Query. Besides that we have seen how to save the Parameter Values in the Custom Properties of the Form, when the Form is closed.
5 Comments
