Custome Database Design with Alpha Software

Tips and Tricks


Takecharge Programming Blog

  • PC Desktop: Note Organizer KeyList_Build function

    —

    by

    cdctakecharge
    in

    Hello Everyone Today I will focus on a very cool function in Alpha Software called KeyList_Build() and to do so, I will be demonstrating it’s use in our upgraded Note Organizer Module. Below is a short video which shows the keylist_build function in action. Please watch the video to see how it works then continue…

  • PC Desktop: Note Organizer Search functions using form objects and or xDialog

    —

    by

    cdctakecharge
    in

    Hello Everyone, At the end of our last session I said we would look at our Search feature on our new File Manager, but in preparing I realized I already have a session devoted to that exact subject. The link below will take you to the original blog session if you wish to see it…

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

  • Back on Track

    —

    by

    cdctakecharge
    in

    Hello Everyone   I am so sorry for the lack of post over the last three months, but I have had a very busy start of the New Year. All new projects are now on schedule and work is progressing at an organized pace. I will start on a new lesson tomorrow (Friday) and have…