Database Import Debuging

Completed Posted Jul 10, 2002 Paid on delivery
Completed Paid on delivery

I have data import system partialy developed (RAC coder is not bother to finish it beware of Subhash Sombra). I need somebody to finish it. This are bugs that needs to be sorted: 1, when records are imported on the first screen there is no option to use name from DB (I'm talking about private client) 2, when I have displayed client info and click on next record (which is corporate client) I get error saying that " You can't hide a control that has the focus. " 3, preselection for corporate client is not working I get lots of " You can't hide control..." 4, after I inserted first corporate client I could not insert second corporate client 5, after you insert corporate client it does not appear in the list menu 6, once you change from normal client to corporate it does not revert to normal client 7, when inserting new client sometimes it overwrites client already in DB 8, in the list menu for private client plase list firstname instead of ID 9, optional if you feel like changing color and layout feel free ( I don't like present look) Functionaly for whole import system should be: 1, import data from text file 2, display agency/client details from imported file in form where end user can select if he wants to use agent/client from his current databse or insert new record 2.1 it is necessary to make distinction between corporate client and private client 2.2 upon loading imported data into form system should preselect closest match from database 3, clicking save button will insert new booking (also sets booking status to imported) 4, then itinerary for that booking will be inserted into bookingitinerary table (there can be more than one itinerary entry for booking) 5, next imported booking here are links to relevant files text file that needs to be imported [login to view URL] import database version with less bugs but not addressing corporate client fully [login to view URL] import database [login to view URL] client original database where objects from import databse will need to go (be careful not to use same names) [login to view URL] This should not take too much time to finish for somebody who has experience with access 90% is done it just corporate client addition is messing up, there may be some additional . Please only serious people with experience developing for access, VBA who will stand be their work and have proffessional integrity.

## Deliverables

I would like to develop good relationship for future projects. I need this done fairly quickly as I'm way past my deadline. Thanks for your bids. Original Project description: I'm developing website for client that needs to able to import data from web database (Access 2000 which I'm going to develop) into access 2000 database that he has stored on his PC. His database is much more comlicated than web one (it uses VBA, macros,and it's not perfect..). Basicaly you would need to develop solution to import bookings from web into his database - it is relationship database; data would need to imported into max 6 tables: Bookings - main table ; contain details for BookingItinery - relationship One to Many with Bookings AgencyDetails - relationship Many to One with Bookings , relationship One to Many with AgentDetails ; contains details for different agencies (address, tel, fax,...) AgentDetails - relationship Many to One with Bookings ; details for agents for various agencies ClientCoDetails - relationship Many to One with Bookings , relationship One to Many with ClientDetail ;contains details for corporate clients ClientDetails - relationship Many to One with Bookings ; contails details for private clients as well as corporate once I need to be able to import bookings into clients database. Preferably he would be faced with situation where he just click import bookings and he select file he downloaded from web with latest bookings. Then if booking was done by agent he would either insert new agency into db or just confirm selection if agency already exists. Then either add agent details to agency or just confirm selection if agent already exists. Same thing for Client tables. After that he get form with prefiled booking details(simmiliar to existing one) than insert details for itinary. Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.

## Platform

Windows

Database Administration Engineering Microsoft MySQL PHP Software Architecture Software Testing SQL Windows Desktop

Project ID: #2859857

About the project

7 proposals Remote project Active Jul 11, 2002

Awarded to:

timcookinte

See private message.

$42.5 USD in 14 days
(2 Reviews)
4.5

7 freelancers are bidding on average $41 for this job

georgvw

See private message.

$38.25 USD in 14 days
(19 Reviews)
3.4
sanbak

See private message.

$42.5 USD in 14 days
(8 Reviews)
2.5
karthikrcvw

See private message.

$34 USD in 14 days
(0 Reviews)
0.0
geno6520bg

See private message.

$42.5 USD in 14 days
(0 Reviews)
0.0
mistycabal

See private message.

$42.5 USD in 14 days
(1 Review)
2.5
ricardolavia

See private message.

$42.5 USD in 14 days
(3 Reviews)
0.0