LEARN MS-ACCESS TIPS AND TRICKS

"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

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

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

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

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

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

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

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

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

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

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

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

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

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:

 

Label animation Style-1

Label Animation Style-2

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:

 

1. Label Animation Style-1
2. Label Animation Style-2

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.

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.

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.

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.

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?

 

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.

Parameter Controls are provided to the Users for entering data Filter criteria values for preparing MS-Access Reports. A reference to the parameter control fields can be set in the criteria row of the Report Source Query directly to filter the data. A sample image of such a Parameter Control is given below.

This is the continuation of our discussion on the usage of Form Bookmarks to revisit the records which we have already visited earlier. The links to the earlier Articles are given below: