Introduction
A Form with lively Objects like Animated Command Buttons, Animated GIFs, Moving Text, etc., makes it more interesting for the User to work with MS-Access Applications. MS-Access doesn't have any of those things built-in or ready-made to use quickly. Our imagination and ingenuity is the only tool available to create something with the existing, strictly for business-like features in MS-Access.
After working with MS-Access for some time I got bored with the repeated use of the same objects without any changes for designing the Applications. I wanted to make something more eye-catching to kill the boredom. As the saying goes "Necessity is the father of inventions", I have developed some interesting features like Command Button Animation, Animated Floating Calendar, usage of Office Assistant in MsgBoxes, Animating Label on search success, Reminder Ticker, and others.
Today we will learn a simple Label Animation Technique with an example in the Employees Form from the Northwind.mdb sample database.
Import the following objects from the Northwind sample database.:
- Table: Employees
- Form: Employees
If you open the Employees Form in Normal View you can see that the Employee's; Name; Firstname and Lastname joined together; is displayed in the Header of the Form in a Text Box. When you make some other record current on Form the employee's full name changes on the Form Header Textbox as well.
We will add some animated effect to this and make the employee name appear slowly from the right edge of the label to the left, character by character, and move into place.
Open the Employees Form in Design View.
Delete the existing TextBox that displays the Employee's Name.
Create a Label on the Header of the Form.
Display the Property Sheet (View - -> Properties) of the Label and change the following Property Values:
- Name = lbl1
- Width = 3.5"
- Height =0.32"
- Back Style = Transparent
- Border Style = Transparent
- ForeColor = 16777215
- Font Name = Times New Roman
- Font Size = 18
- Font Weight = Bold
- Text Align = Right
Display the Code Module of the Form (View - ->Code).
Press Ctrl+A to highlight the existing VBA Routines and press the Del key to delete them.
Copy the following VBA Code and paste it into the Code Module of the Form.
Label Animation Code.
Option Compare Database Option Explicit Dim txt1 As String, txtlen As Integer Dim j As Integer, txt2 As String Private Sub Form_Timer() j = j + 1 If j <= txtlen Then txt2 = Left(txt1, j) Me.lbl1.Caption = txt2 'Me.lbl2.Caption = txt2 Else Me.TimerInterval = 0 End If End Sub Private Sub Form_current() txt1 = UCase(Me![FirstName] & " " & Me![LastName]) txtlen = Len(txt1) j = 0 Me.TimerInterval = 50 End Sub
Save and Close the Employees Form.
Open the Employees Form in the normal view.
- Click on the Navigation button to move the records forward one by one.
The names of the employees will be displayed in the same style by moving from the right edge of the label to the left.
When you open the Form you will find the Employee Name is moving into place slowly from right to left, character by character, in the header label.
Fancy Work to the Label.
We will add little fancy work to the Employee Name with a three-dimensional backlit effect by copying the Label and placing it over the existing one. See the finished design of the image is given below:
Open the Employee Form in Design View.
Select the header label.
Click on the Copy, Paste ToolBar buttons to make a copy of the label (or select Copy, Paste Options from the View Menu).
Click on the new Label to select it, if it is not in the selected state.
Display the Property Sheet of the Label (View - ->Properties).
Change the following Property Values as shown below:
- Name = lbl2
- ForeColor = 128
Move the label up and over the first label and place it slightly down from the top edge of the first label and to the left, about the thickness of a hair. The sample image design view is given below:
While the Form is still in design view display the VBA Module (View - ->Code)
You will find the following line of code in the Sub Form_Timer() Event Procedure in a different color (most probably in green color):
Find the ' (single quote) character at the beginning of this line and delete it.
Save and Close the Form.
Open the Form in the Normal View.
Now you will find the Employee Names appearing in animated characters, with the 3D effect, as shown in the second image above.
I have already included the line of code necessary to run this trick. All you have to do is to enable that line in the VBA code, do the following:
'Me.lbl2.Caption = txt2
This is my first time visit to your blog and I am very interested in the articles that you serve. Provide enough knowledge for me. Thank you for sharing useful and don't forget, keep sharing useful info: à¸à¸™ิเมะ An animation is defined as a visual change in a scene with respect to time.
ReplyDelete