LEARN MS-ACCESS TIPS AND TRICKS

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

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

Normally, a Graph Chart is designed to the required size and formatting on a Form/Report. The design stays with its dimension for ever, unless the developer has second thoughts and ... Continue Reading

In a secured Database; basic access rights to Objects like Tables, Forms, Queries and Reports are defined for specific Workgroups/Users as a one time exercise. This takes effect automatically ... Continue Reading

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

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

It is very unlikely that you want to change the status of a Secured Database (implemented with Microsoft Access Security) to an unsecured one. This exercise become necessary when you ... Continue Reading

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

Combo Boxes on Tables/Forms are for inserting frequently used common values quickly and easily into Data Fields.  The Source Data Values of the Combo Box comes from Table or Query.  ... Continue Reading

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

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 remove all permissions from all Objects for Users Group Account as all Users belongs to this default Group Account and inherits permissions, if available, besides other Group Accounts each user belongs to. If you have not gone through the earlier Articles on Microsoft Access Security with VBA, you may take a look at the following links before continuing:

 

Creating User-Account with VBA
Create Security Group Account with VBA
Users Group and Permissions

When you create a new Workgroup Information File, as part of the Microsoft Access Security implementation, it is important that the following two steps you follow immediately after creating the new Workgroup Information File (.mdw) file on priority basis:

Last week we have learned how to create a Microsoft Access Security User Account(SMITHJOHN) with VBA and learned how to join him as a member of the default Group Account Users. The Users and Admins Group Accounts are already present in the default Workgroup Information File (Sytem.mdw) or in the new Workgroup Information File that you create separately.