Learn Microsoft Access Advanced Programming Techniques, Tips and Tricks.

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 for business like, features provided in MS-Access.

After working with MS-Access for sometime I got bored with whatever we have in MS-Access. I wanted to make something more eye-catching to kill the boredom. As the saying goes "Necessity is the father of inventions", I have invented and developed some of the interesting features like: Command Button Animation, Animated Floating Calendar, Usage of Office Assistant in MsgBoxes, Animating Label on search success and others.

Today we will learn a simple Label Animation Technique with an example on the Employees Form from Northwind.mdb sample database.

  1. Import the following objects from C:\Program Files\Microsoft Office\Office11\samples\Northwind.mdb 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 on the Header of the Form in a Text Box. When you make some other record current on the 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 right edge of the label to the left, character by character, and move into place.

  2. Open the Employees Form in Design View.
  3. Delete the existing TextBox that displays the Employee's Name.
  4. Create a Label on the Header of the Form.
  5. 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
    • Fore Color = 16777215
    • Font Name = Times New Roman
    • Font Size = 18
    • Font Weight = Bold
    • Text Align = Right
  6. Display the Code Module of the Form (View - ->Code).
  7. Press Ctrl+A to high-light the existing VBA Routines and press Del Key to delete them.
  8. Copy the following VBA Code and paste it into the Code Module of the Form.
    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
  9. Save and Close the Employees Form.
  10. Open the Employees Form in normal view.
  11. 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.

  12. Click on the Navigation button to move the records forward one by one.
  13. The names of the employees will be displayed in the same style by moving from right edge of the label to the left.

We will add little fancy work to the Employee Name with a three dimensional backlit effect (icing effect) by copying the Label and placing it over the existing one. See the finished design image given below:

  1. Open the Employee Form in Design View.
  2. Select the header label.
  3. Click on the Copy, Paste Tool Bar buttons to make a copy of the label (or select Copy, Paste Options from View).
  4. Click on the new Label to select it, if it is not in selected state.
  5. Display the Property Sheet of the Label (View - ->Properties).
  6. Change the following Property Values as shown below:
    • Name = lbl2
    • Fore Color = 128
  7. 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.  Sample design image is given below:
  8. 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:

  9. While the Form is still in design view display the VBA Module (View - ->Code)
  10. You will find the following line of Code in the Sub Form_Timer() Event Procedure in a different color (most probably in green color):
  11. 'Me.lbl2.Caption = txt2

  12. Find the ' (single quote) character at the beginning of this line and delete it.
  13. Save and Close the Form.
  14. Open the Form n normal View.

Now you will find the Employee Names appearing in animated characters with 3D effect as shown in the second image above.

Share:

No comments:

Post a Comment

Translate



PageRank
Your email address:

Delivered by FeedBurner

Search

Infolinks Text Ads

blog.feedspot.com Microsoft Access Blogs

Popular Posts

Search This Blog

Blog Archive

Powered by Blogger.

Labels

Forms Functions How Tos MS-Access Security Reports msaccess forms Animations msaccess animation Utilities msaccess controls Access and Internet MS-Access Scurity MS-Access and Internet Queries External Links msaccess reports msaccess tips Menus and Toolbars Accesstips MsaccessLinks Process Controls Art Work Downloads msaccess How Tos Graph Charts msaccessQuery List Boxes Command Buttons Emails and Alerts Query Combo Boxes Custom Wizards DOS Commands ms-access functions msaccess functions msaccess graphs msaccess reporttricks Array msaccessprocess security advanced Access Security Custom Functions Data Macros Menus Property Report Top Values VBA msaccess email msaccess menus progressmeter Access2007 Auto-Number Calculation Command Button Copy Data Type Field Type Fields Form Join Microsoft Numbering System Records Security Split SubForm Table Utility Variables Workgroup database msaccess wizards Access2003 Accounting Year Action Animation Attachment Binary Numbers Bookmarks Budgeting ChDir Color Palette Conditional Formatting Controls Data Filtering Defining Pages Diagram Disk Dynamic Lookup Error Handler Excel Export Expression External Filter Form Instances Formatting Groups Hexadecimal Numbers Import Labels List Logo Macro Mail Merge Main Form Memo Methods Monitoring Object Reference Objects Octal Numbers Operating System Paste Primary-Key Product Rank Reading Recordset Rich Text Sequence SetFocus Summary Tab-Page Tables Time Difference Union Query User Users Water-Mark Word automatically commands function hyperlinks iSeries Date iif ms-access msaccess msaccess alerts pdf files reference restore switch text toolbar tutorial updating upload vba code

Featured Post

Passing Two Dimensional Array to Function

First of all, I have some good news for you, our website: LEARN MS-ACCESS TIPS AND TRICKS has been selected by https://blog.feedspot.com pa...

Labels

Blog Archive

Recent Posts