Learn Microsoft Access Advanced Programming Techniques, Tips and Tricks.

Control Screen Design

Introduction

Computers were designed for serious business purposes, when they were costing a fortune, not for entertainment. But, this changed in the 80s when Personal Computers were introduced and easily available programs were computer games.

Owning a personal computer was a dream of everyone at that time (even now) and I bought mine too (brand name Spectra Video, Taiwan). Its processor speed was 1.xx something with 84K Memory, (you can call it a Keyboard rather than a computer) with connections to a TV as a Monitor and to a Cassette Recorder for recording Programs(BASIC) or Data. Even now you can see these types of machines in Supermarkets in the Toys section. IBM PCs with 4.77 Mhz. Processor speed and 640K Main Memory, with a cassette recorder priced sky-high, were unreachable for many. 5.25" Floppies & 10MB Hard Disk came with later Versions of XT(Extended Technology), and AT (Advanced Technology) Models.

What I am trying to say here is, that the plaything concept has not changed ever since and it comes as a side dish to serious business needs and it is essential too.

MS-Access is designed for serious data processing needs, but you can make it attractive and amusing to use by incorporating animations, slide shows, and the like useful information from within your application itself (without overdoing it) so that the user doesn't get bored using your Application. It should be user-friendly and attractive too, like the reception area of Five Star Hotels with all the decorations around and ready to serve staff on duty, advertising what kind of service you can expect.

Here, our emphasis is on looking into a sample Control Screen designed with all the important elements of an Application, like Data Entry Screens, Reports, Data Processing, etc., and organizing all of them in a central point within easy reach.

We are not going through the entire design task of this screen, but for now, we will look into only a simple aspect of this screen design and others we will look into later.

The sample Control Screen

The Screen Header Section is decorated with the Company Logo and the Title of the Application in 3D Text and the Version Number below it. Below that, the control area is organized into mainly three categories: Data Files, Reports & Data Upload control. The purpose of this application is to monitor the service expenses of the vehicles, which are in Service Contracts with the company, and used for audit checks. The 'Data Upload' Command Button is used for running procedures for uploading vehicle service data from IBM AS400 Main Frame machines into the System every month.

You can see the Data Files command button is active and its Menu is displayed at the center and a row of buttons on the right side for different categories of Vehicles. When any of these buttons on the right side is clicked its corresponding menu options will appear at the center window overlaying the earlier one.

Why different Vehicle Type has different data files and menus, and why can't all of them go into one Table is a question that naturally comes into one's mind. The Main Data Table is one only, but the data are grouped into different categories to give access to different user groups and keep away from others. The right-side command buttons are enabled or disabled based on which member of the user-groups login into the System. The current user-name is appearing in a small text control below the 'Quit' command button on the left side. As per his access rights, some of the command buttons on the right side are enabled and others are disabled.

When the 'Reports' command button on the left side is clicked a similar set of menus and command buttons will appear at the same place with user-level security features. A total of 15 different menus including the upload command button's menu will be displayed in the same place. We will learn how to organize menus this way under the Control Screen Menu Design topic.

At the bottom of the screen, a white stripe can be seen with blue-colored text. This is a News Ticker-like control, scrolling continuously as a reminder to the user showing details of the vehicles, as an indication that their Service Contract is going to expire this month. The total number of such vehicles is shown underneath it, prompting immediate action for renewals, etc.

As you have already noticed this Screen doesn't have any default control buttons on the top (Min, Max, Close) or the title bar.

The System opens with a Startup Screen (learn Startup screen design here) followed by the Control Screen. The Control Screen stays as if it is pasted into the Application background till it is closed from the Menu, File - - > Close, or by clicking the Quit command button on the Screen. It doesn't have any Border style or re-sizing facility and it has a flat paper-like look. This is achieved with the following Form Property settings:

Form Property Settings.

  1. Default View = Single Form
  2. Allow Datasheet View = No
  3. Allow Edits = Yes
  4. Allow Deletions = No
  5. Allow Additions = No
  6. Data Entry = No
  7. Scroll Bars = Neither
  8. Record Selectors = No
  9. Navigation Buttons = No
  10. Dividing Lines = No
  11. Auto Resize = Yes
  12. Auto Center = Yes
  13. Pop Up = No
  14. Modal = No
  15. Border Style = None
  16. Control Box = No
  17. Min Max Buttons = None
  18. Close Button = No
  19. What's This Button = No

Write an Event Procedure on the On Load event:

Private Sub Form_Load()
    DoCmd.Restore
End Sub

When you open your control screen with the above property settings and with the On Load Event Procedure it will look as if the screen is painted in the Application Background.

Share:

2 comments:

  1. Thanks, found the article on google, nice post fella...

    I saw recently so sending a trackback to my site, thx again Si...

    ReplyDelete
  2. Thanks, found the article on google, nice post fella...

    I saw recently so sending a trackback to my site, thx again Si...

    ReplyDelete

Comments subject to moderation before publishing.

PRESENTATION: ACCESS USER GROUPS (EUROPE)

Translate

PageRank

Post Feed


Search

Popular Posts

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