Find Jobs
Hire Freelancers

Delphi ZIP Code application with MDB files

$100-500 USD

Cancelled
Posted about 15 years ago

$100-500 USD

Paid on delivery
I need a Delphi application that will: 1) Allow the user to pick an existing MS Access MDB file 2) Display the available tables within the MDB in a TChecklist 3) Once a table is checked display all the available fields in that selected table in another TCheckList 4) User input a 5 digit USA ZIP Code in a TEdit 5) User inputs a distance (miles) in a TEdit 6) When the user clicks a TButton the application will: I) Determine the latitude and longitude values for the ZIP Code entered in #4 II) Iterate through the entire MDB table (see #2) and determine the distance (as the bird flies) from the ZIP Code entered in #4 to each of the ZIP Codes found in each record (#3 defines the ZIP Code field for the selected table). III) Those records where the distance calculated is less than or equal to the distance specified in #5 should be stored in new temporary table. IV) Once the entire database has been stepped through, record by record, close the MDB 7) Using the temp database that was created, sort the distances in ascending order. 8) Display to user the number of records found 9) Give the user the option to export the results to a CSV file. User will choose the fields from the original MDB that will be exported using a TCheckList. The values for items 1, 2, 3, 4, 5, 9 should be saved to an INI file and restored back when the application restarts. IOW, I want the previously used values to be sticky. I will provide the ZIP Code database & trigonometric algorithms used to calculate distances between latitude and longitudes. The application can be written in Delphi 3 to D2005. The application must not use the BDE. The application should make accessing the MDB file as simple as possible on the user. I would like to avoid having to create ODBC data source. The ideal solution is simply to have the Delphi app display a File Selection window and allow the user to point to a MDB file and that's it! ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows 2000, XP, Vista
Project ID: 3786191

About the project

4 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $205 USD for this job
User Avatar
See private message.
$226.10 USD in 15 days
4.9 (104 reviews)
6.9
6.9
User Avatar
See private message.
$85 USD in 15 days
4.9 (29 reviews)
3.5
3.5
User Avatar
See private message.
$425 USD in 15 days
5.0 (2 reviews)
3.3
3.3
User Avatar
See private message.
$85 USD in 15 days
5.0 (2 reviews)
2.0
2.0

About the client

Flag of UNITED STATES
Fredericksburg, United States
4.9
34
Payment method verified
Member since Mar 7, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.