Platforms: Symbian OS, Pocket PC, Palm, Series 60, BlackBerry, Smartphone
Categories: Databases
Upload date: 20 Sep 11
Developer: Dave Haupert
License: Freeware
Downloads: 86 File Size: 8 Kb
Orders for HanDBase - Order entry applet using multiple groups of DB popups.
There are three files in this archive: orders.pdb, accounts.pdb, and products.pdb. All three are used for this applet. Here's how it works: Accounts.PDB - has accounts info- ie, your customers, their account number, their price rate, which is a discount rate that you could set for each customer. For example, a company might receive a 20% discount off the price, so this value would be 0.80. Products.pdb - information about each product you are selling, including product numbers, prices, description, etc. Orders.PDB - the main entry point once everything is set up. Open orders.PDB and add a record. You can choose the customer making the purchase by either writing in the value or, better yet, selecting the customer popup, where you will be taken to the Accounts database and you will be able to select one from the existing accounts. This will also bring over the account # of this customer. You can now fill out the quantities for up to 3 items (which was all I could fit in the 30 fields with all of the other stuff), and select the product by pressing the Item x Desc field and selecting the product from the Products database. The price will come over and be factored in along with the quantity, and the 'discount rate' or 'price rate' as it is in the accounts database is factored as well. At the bottom the tax is calculated, which I put in at 6%, which is Florida's rate, but you can easily modify this by adjusting the Tax field property, and a total is given. I hope this is a useful starting point for you. If you need more products to be purchased, you can either take away some of the other extraneous fields and try to squeeze one or two more in, or redesign the database as follows: Make each record be part of an order. You can use the new 'prev record' calculated fields to keep a running sum. Then you can use the Filters to limit the view to the current customer's current order only, and have a good subtotal!
Like it? Share with your friends!
If you got an error while installing Themes, Software or Games, please, read FAQ.
Requirements:HanDBase v.2.7x or greater
Supported operating systems:
Palm OS 3.x, Palm OS 4.x, Palm OS 5.x, Pocket PC 2002, RIM BlackBerry OS 4.2, RIM BlackBerry OS 4.3, RIM BlackBerry OS 4.5, RIM BlackBerry OS 4.6, RIM BlackBerry OS 4.7, RIM BlackBerry OS 5.0, RIM BlackBerry OS 6.0, S60 1st Edition, S60 2nd Edition, S60 3rd Edition, S60 3rd Edition FP1, S60 3rd Edition FP2, S60 5th Edition, Windows Mobile 2003, Windows Mobile 2003 Smartphone, Windows Mobile 5.0, Windows Mobile 5.0 Smartphone, Windows Mobile 6 Classic, Windows Mobile 6 Professional, Windows Mobile 6 Standard, Windows Mobile 6.1 Classic, Windows Mobile 6.1 Professional, Windows Mobile 6.1 Standard, Windows Mobile 6.5 Professional, Windows Mobile 6.5 Standard
Similar Software:
Currencies CDN for HanDBase Currencies CDN for HanDBase - A currency converter for Canadian travelers. Destinations for international scientific meetings are included. In the Info section you will find a website address for latest rates
CountryCityCodes CountryCityCodes - Look up international dialing codes and city codes for countries around the world.
What's New in This Release:
· Improved compatibility with newer devices. Changed delivery method: eliminated registration codes
Inventory Inventory - Over 3000 people agree that Inventory is the simplest way to track all your important possesions at home.
In the case of an emergency or natural disaster, you will be able to use the information to process insurance claims much easier and faster
What's New in This Release:
· Completely redesigned system. Better support for OS 5, better color support
Match tracker for HanDBase Match tracker for HanDBase provides a complete record of any sports event for distribution to the media or to publish on a website.
The applet was originally designed to cover an international field hockey tournament and to provide the full match report to the media within the IOC specified time of 10 minutes of the end of the game
Pocket PC new purchase for HanDBase Pocket PC new purchase for HanDBase - Enter the cost of buying a Pocket PC and all the desired accessories. Adds sales tax and calculates running total.
You will have to change the calculation to your local sales tax rate. I will be replacing my current Pocket PC in a few months, and this lets me keep track of what model and extras I want for it
Photo for HanDBase Database for protocollation of data during photographic sessions
Sunday Shopper for HanDBase Sunday Shopper for HanDBase - This shopping guide allows you to enter all of the items you see in the Sunday ads that you want to buy. This way you won't have to take all those ads with you and you will still know what to get. It even has fields for entering whether you get rebates and if you need a form to mail in
Doctor Visit for HanDBase Doctor Visit for HanDBase - I started this database for my family, and I thought I could share this db with everybody. This db keep track records of your visit to a doctor. For yourself and the family. It also has a medicine db, so you could keep track all the schedules
Show Times for HanDBase Show Times for HanDBase - A simple applet no one has bothered to make yet. Maybe it'll help newbies get ideas for their own stuff. This app' will let you name a show that you like to watch or hear, record the times and days that the show is on, as well as the channel and means of broadcast. Has some built in pop-ups for quick url recording (sorry, no http://) likw www.,
Other Software by developer «Dave Haupert»:
Cases for HanDBase Cases for HanDBase - Keep track of trials and cases with this Database. Could be useful for Attorneys, Judges, and law enforcement personnel.
This is a good starting point for using this in your case-tracking work. There is a database for keeping a listing of Judges, one for Attorneys, and also a linked action list to keep track of what was done, and what's left to do
Password Manager for HanDBase Password Manager for HanDBase - Keep track or all of your passwords, account numbers, logins, etc.
If you are searching for a certain item, you can set the 'Type' filter to show only the type of account you are looking for
Time Log for HanDBase Time Log for HanDBase - Keep track of the projects you are working on. Lots of room for customization in this one! You can change the 'Charge to' field to be a DB Popup, and have it point into a database of customers you may have. You could add in a rate calculation and have it figure out the rate charged by calculating (rate * duration)
Real Estate for HanDBase Basic applet for Realtors and/or prospective buyers to keep track of houses and properties
Recipes for HanDBase Recipes for HanDBase - This is a great way to jot down a recipe when you are over a friend's or relative's house and like something they are making! It requires very little handwriting, as most of the popup's have useful values defined already
Archery for HanDBase Archery for HanDBase - Archery scoring system. This is a good demo of how to do some fancy calculations using the basic calculations available. The program will let you enter the three scores, and HanDBase will automatically calculate which values are non-zero and total the # of hits. It also keeps a running total, and also a score for that round
Teacher's Aid for HanDBase Teacher's Aid for HanDBase - Database for keeping track of students. This is a good starting point for teachers to use for tracking students. You first define your students, by opening the Teacher's Aid database, with their related info, and then you can take attendance and track test and homework scores with it
