Custome Database Design with Alpha Software

Tag: Alpha Software

  • Designing a Custom Form Query

    —

    by

    cdctakecharge
    in

    Hello Everyone Today we are looking at how to design a custom form query for the simple form we created in the last session. Alpha Software provides a Query by Form option on the drop down Query Menu.This option will display the query toolbar and blanks all fields on the form allowing the user to…

  • Displaying Data from Multiple Tables Without Creating a Set

    —

    by

    cdctakecharge
    in

    Hello Everyone When you look at the title you might ask yourself why would I want to do that? The answer is in a flat table all data is easily sorted, queried or viewed without the restrictions imposed by the rules of the set. Many would say why not just build another data view to…

  • PC Desktop: Tape Calculator – Changing Text formatting with xBasic.

    —

    by

    cdctakecharge
    in

    Hello Everyone Today we are going to look at how you can change text formatting on the fly using xBasic code. To do this we will examine the Tape Calculator we created for our new desktop. You can see from the image, the calculator  has all the standard buttons for a calculator as well as…

  • Making the Object Spell Checker work

    —

    by

    cdctakecharge
    in

    Hello Everyone and Happy New Year This session was supposed to be about our desktop tape calculator and I am currently writing that lesson but I recently had a customer request which I found interesting and wanted to share. The customer has an application which has migrated form DOS to their current version of Alpha…

  • PC Desktop: ToDo Manager

    —

    by

    cdctakecharge
    in

    Hello everyone. Hope the Holiday season is going well for all of you. Today we are looking at the ToDo manager and how it relates to our Start menu and File Manager. As you can see from the above image, clicking the Direct Access Button in the top tool bar builds a menu system in…

  • PC Desktop: Email Account Manager

    —

    by

    cdctakecharge
    in

    Hello Everyone, It’s been a while and I do apologize, but sometimes life gets in the way of life and I for one believe you should go with the flow. Today we are looking at the Email Account Manager and the code for attaching single or multiple files to an email. First, lets watch this…

  • PC Desktop:Zip File Manager

    —

    by

    cdctakecharge
    in

    Hello Everyone Today we are looking at the punch list for our File Manager Module. As we have discussed, the File Manager will also double as the Start Menu for our desktop. Therefore, we must consider both applications when working on our punch list. Initially our list for this module was fairly short but as…

  • PC Desktop: Web Bookmark Manager

    —

    by

    cdctakecharge
    in

    Hello Everyone Today we will be looking at our Web Bookmark Manager. Our Bookmark manager is designed on our weblist table and has three separate yet related functions. Provide a method for managing our Web Bookmark Menu Provide a means of searching the Web using the major search engines Provide a Browser interface for all…

  • PC Desktop: Passing Field values to Variables

    —

    by

    cdctakecharge
    in

    Hello Everyone Today we are looking at the first two lines of our punch list. Clock Calendar Set font color on buttons to Red if there are task, notes or appointments scheduled for that day. Set Quick Note entry form to allows continuous entry. Watch the short video below then come back to see how…

  • PC Desktop: Using a Punch List

    —

    by

    cdctakecharge
    in

    When developing an application even when following a design document it is important to review your progress at varying intervals to insure you are staying on course and meeting the requirements of the Design Document. One of the tools I use to stay on course is a Punch List. I call it a Punch List…