Find Jobs
Hire Freelancers

Web Based Data Entry Form - repost

$30-250 USD

In Bearbeitung
Veröffentlicht vor mehr als 11 Jahren

$30-250 USD

Bezahlt bei Lieferung
I need a web based data entry form developed from a Microsoft Access form for an existing mysql database. We are currently using Microsoft Access to view / edit our existing mysql database. I would like to convert one of our existing forms from MS Access to a web-based form. I can provide a copy of the MS Access database and form. I am looking for someone who can deconstruct the MS Access form and understands MS Access well enough to see the form properties, dependencies, queries, etc without me having to walk you through the entire form step by step. You will need to be able to build the web form and model it after our MS Access form. This form already has the format we want including the main form, the sub forms, the queries, database structure, default data items, hidden data items, etc. Our Website currently has no web based forms so an initial setup will need to be created such as an admin page to manage users and user rights to the new form. All code and rights will be provided to me for future use and development of our site. I would require any information required so you or another developer could edit / update your work. Tables to be used in the form (actual table names are different, just listing descriptive name here): Main Tables: clients table tickets table address table contacts table vendors table accounting table equipment table Actual number & name of tables is viewable in the MS Access Database. Rough web form need: The form should allow our data entry people to do the following: Select a Client Company Name from a drop down list (which pulls from our Clients Table) Enter the Clients Ticket Number Select the repair type from a drop down list Enter the ticket location information: - Enter the address of the ticket - Enter the zip code which will then pull from our zip code table to automatically enter the city and state Select the vendor id from a drop down list linked to our vendors table Select the vendor profile (will default to vendor selected above but allow for edits from a drop down list) Select the Timeframe Type for the Ticket from a drop down list Enter the service date and have the pay period date auto entered based on our pay period table and the related service date Enter the end date of the ticket (we use this if the ticket spans multiple days) Date received (this field will default to current date but allow edits in the event data entry is behind) Enter the time we are required to start the ticket and the time we are required to finish the ticket Show a field at the end of the data entry which allows the data entry clerk to copy and paste to create calendar events and will pull information from the above fields to show: Client Company Name, Ticket Number, Timeframe Type, and Repair Type Show another field at the end of data entry that allows for copy/paste of the location information. An option button to allow more detailed data entry for advanced tickets to include: Item code Rate Amount Rate Type Fees Description End User Name Site Company Name In the background, there will be the following items: Date entered (enters actual date of data entry) Internal ticket number (auto counting field from our tickets table) Ticket status (defaults to active) Client ID (auto entered based on the client name selected by the data entry clerk)(pulled from our clients table) Followup By: default field to indicate the next person responsible for the ticket Followup Required: default to new ticket status Your bid should be a flat rate amount to develop this form to completion. I have tried to list all relative items to make your bid easier but I cannot guarantee that I have listed all fields, tables, drop-down lists, etc. I can provide a copy of our Microsoft Access database for reference and all login information for the mysql database and php myadmin site.
Projekt-ID: 4186960

Über das Projekt

2 Vorschläge
Remote Projekt
Aktiv vor 11 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
2 Freelancer bieten im Durchschnitt $250 USD für diesen Auftrag
Avatar des Nutzers
Can you provide a database diagram? You have written in a text format and its not understandable.
$250 USD in 22 Tagen
4,9 (319 Bewertungen)
7,9
7,9
Avatar des Nutzers
I can convert your MS Access form into a php web interface with a MySQL database.
$250 USD in 14 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
Sand Springs, United States
0,0
0
Zahlungsmethode verifiziert
Mitglied seit März 27, 2009

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.