Custome Database Design with Alpha Software

Tag: lesson session

  • PC Desktop: Building List Dynamically

    —

    by

    cdctakecharge
    in

    Hello Everyone If you read yesterdays blog entry I showed how to add values to a drop down control from another drop down control. The example was simple in design and required a basic understanding of list objects. Today I will cover Advanced procedures for building list dynamically. To do this we will look at…

  • Adding Values to a Dynamic Dropdown List using xBasic

    —

    by

    cdctakecharge
    in

    Hello everyone This session is a request from another programmer looking for some assistance. He wants to build a drop down control using xBasic and populate the values from another control which may be a database look up or some other type of list control. Typically you would use the object properties on the form…

  • PC Desktop: Application Launch Bar

    —

    by

    cdctakecharge
    in

    Hello Everyone. Today we are looking at a new feature for our PC Desktop which is a Launch Bar. Now throughout the history of Windows Desktop many Launch bars have been created, tried and forgotten; so why bother. Well I created this launch bar in response to customer feedback from people trying my new desktop…

  • Object Events: Where do I put my code?

    —

    by

    cdctakecharge
    in

    Hello Everyone If you have been following along, you know I write a lot of object code on forms rather than putting code in the code library. I was recently asked; How do I know what object should get what code? This is a fair question and deserves a look. To start with lets look…

  • 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…

  • 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: 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 xBasic to Add, Delete and Fetch Records

    —

    by

    cdctakecharge
    in

    Hello everyone Before we get into our session for today, I want to take a moment to talk about the software I use to do all of these lessons, Alpha Software. Everything we do here is currently focused on desktop applications but don’t get fooled, Alpha Software is much more than that. Alpha Software is…