ZIP CODE TO CITY STATE. I HAVE ATTACHED 3 TABLES WHICH WILL USE THE ROUTINE, CREATE THE INPUT FORMS. THEY SHARE THE ZIP CODE DATA. OPERATOR ENTER A POSTAL ZIP CODE. THE ZIP CODE MAY BE 9 DIGITS. THE ADDITIONAL 4 DIGITS ARE NOT STORED IN THIS PROGRAM. USING THE FIRST 5 DIGITS THE PROGRAM RETRIEVES THE CITY AND STATE FOR THAT ZIP CODE.. THE OPERATOR MAY ADD AN ADDITIONAL CITY FOR THIS 1) I want to create input forms for the three tables. 2) the operator enters the ER #, If the number exists, load the existing data into the form 3) the input forms should have 4 buttons, “edit?? to change existing data, “clear?? to remove displayed data from the screen, and “edit?? to permit changes to existing data and “store?? to save data to the tables. 4) else accept the data. 5) the input forms contain a zip code, city and state 6) Integrate the zip program into the input forms 7) delete the add record button. This s/b automatic if the zip code is not already on file. 8) load the input forms with the stored city and state, if available ZIP CODE. ( SOME ZIP CODES MAY HAVE SEVERAL CITIES ATTACHED) IF THE ZIP CODE IS NOT ON FILE, THE PROGRAM WILL ACCEPT AND STORE THE CITY AND STATE. CITY MAY HAVE 30 ALPHA CHARACTERS. STATE HAS 2 CAPITAL ALPHA CHARACTERS. UP TO 99999 ZIP CODES MAY BE STORED
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
ACCESS 2002, VB6, WIN95+