Learn Microsoft Access Advanced Programming Techniques, Tips and Tricks.

Control Screen Design


Computers were designed for serious business purposes, when they were costing a fortune, not for entertainment. But, this has 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 TV for Screen and to a Cassette Recorder for recording Programs(BASIC) or Data. Even now you can see these types of machines in Supermarkets in Toys section. IBM PCs with 4.77 Mhz. processor speed and 640K Main Memory, with cassette recorder and priced sky high were unreachable for many. 5.25" Floppies & 10MB Hard Disks came with later Versions of XT(Extended Technology), AT (Advanced Technology) Models.

What I am trying to say here is, the plaything concept has not changed ever since and it comes as a side dish to the 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 with 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 organized 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 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 at the right side for different category of Vehicles. When any of this button at the right side is clicked its corresponding menu options will appear at the center window overlaying the earlier one.

Why different Vehicle Type have different data files and menus, why can't all of them go into one Table is a question naturally comes into ones mind. The Main Data Table is one only, but the data 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 at the left side. As per his access-rights some of the command buttons at the right side are enabled and others are disabled.

When the 'Reports' command button at 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 at 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 strip 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 vehicle is showing 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. Whats This Button = No

Write an Event Procedure on the On Load event:

Private Sub Form_Load()
End Sub

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



  1. Just want to say what a great blog you got here!
    I've been around for quite a lot of time, but finally decided to show my appreciation of your work!

    Thumbs up, and keep it going!

    Christian, iwspo.net

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

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

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

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


Comments subject to moderation before publishing.

MS-Access Tips on your Finger-Tip

  • Download Android App 'MSA Guru' Version of LEARN MS-ACCESS TIPS AND TRICKS from Google Play Store.

Want to Post Free Ads on the Web


Subscribe in a reader
Your email address:

Delivered by FeedBurner


Popular Posts

Blog Archive

Powered by Blogger.

Follow by Email


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 Menus and Toolbars Objects Collection Object MsaccessLinks Process Controls Art Work Property msaccess How Tos Dictionary Object Graph Charts Query VBA msaccessQuery Calculation Combo Boxes Event List Boxes Command Buttons Controls Data Emails and Alerts Form Custom Functions Custom Wizards DOS Commands Data Type Object Reference ms-access functions msaccess functions msaccess graphs msaccess reporttricks Command Button Key Report msaccess menus msaccessprocess security advanced Access Security Add Auto-Number Field Type Form Instances Item Macros Menus 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 TreeView Control Utility 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 Diagram Disk Dynamic Lookup Error Handler External Filter Formatting Groups Hexadecimal Numbers ImageList Control Import Labels List ListView Control Logo Macro Mail Merge Main Form Memo Monitoring Nodes 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