Find Jobs
Hire Freelancers

Conver VB5 w/Access to VB6 w/Excel

$1500-3000 USD

Abgesagt
Veröffentlicht vor mehr als 10 Jahren

$1500-3000 USD

Bezahlt bei Lieferung
We have a program that was written in VB5 which is used in conjunction with Microsoft Access databases to perform automatic sequencers to start up and shutdown plant equipment such as boiler feed pumps, fans, mills, etc. The attached "[login to view URL]" includes the original source files, compiled exe file, and Microsoft Access database file. Also included in the zip file are 4 screen shots that go along with this write-up to better explain the project. This project will be to convert the current VB5 using Access databases over to VB6 and use Microsoft Excel instead for the tables. The project would also include the clean-up items which are explained in more detail later in this project description write-up. The visual basic program is generic in that the same executable can be used to run the sequence for many different pieces of equipment such as starting up a mill, starting up a boiler feed pump, shutting down a fan. Our control system is supplied by Metso Automation. They provide code that can be embedded in VB5 or VB6 to be able to read and write to their control system points. The steps of the sequence for any piece of equipment is determined and tabulated in a Microsoft Access database file. Each step has a column field for the tag name (point) and attribute in the Metso DCS the program writes to, the tag name and attribute the program looks at to say the step is complete, the time delay before proceeding to the next step, etc. There are other features of the program such as sending sequencer problem alarms to the Metso DCS, time stamping step completions which are captured in a log file, and a few others. A screenshot of the current sequencer main menu display is shown in “main [login to view URL]” which is included in the [login to view URL] file. Visual Basic file [login to view URL] uses [login to view URL] and [login to view URL], which are also included in the attached [login to view URL] file. The database file that it uses is shown in the “access- main [login to view URL]”. The actual database file is included in the [login to view URL] file called Mtr_MaxApp.mdb. A screenshot of a sequencer example for FGD Ball Mill A Start is shown in “sequence [login to view URL]”. Visual Basic file [login to view URL] uses [login to view URL] and frmDataDsp. An example of the Access database file for an FGD Ball Mill A Shutdown is shown in “access- seq [login to view URL]”. Note this is a 3 page tif. The actual database file is included in the [login to view URL] file called Mtr_MaxApp.mdb. Also included in the [login to view URL] file are [login to view URL], [login to view URL] (which uses [login to view URL]), and LogFile.bas. We have successfully tested this program and it goes through the steps properly, writing to points, reading points for completion confirmation before proceeding to the next step, time stamping, and exporting the log file. However, there are three minor clean up items. The “Current Step” number in the lower right of the sequencer display does not work. Jump capability still needs added (for example if it gets to step 43 and the point it is reading is true then it would jump to step 67, otherwise it moves on to step 44). Fault circuits still need completed and tested so a signal from the Metso DCS would come in and stop the sequencer. Since you won’t have the interface with the Metso DCS (requires software, key, virtual DPU, etc that we won’t be able to provide you), it may be difficult for you to fully test your program. So we would need the source files so we can functionally test it (we have a Metso DCS simulator to test it on). We may have to tweak it here and there when we get it on site but at least we will have the bulk of the work completed by you with a VB6 file that is free of compile errors and is coded to use Excel tables. If there are any questions on this project please contact me at. I also frequently talk to the person who originally wrote the VB5 program who is available to answer any questions you may have about the program itself. Thank you, Steve
Projekt-ID: 4876002

Über das Projekt

1 Vorschlag
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
1 Freelancer bieten im Durchschnitt $3.092 USD für diesen Auftrag
Avatar des Nutzers
I can help you
$3.092 USD in 3 Tagen
5,0 (9 Bewertungen)
5,0
5,0
Avatar des Nutzers
Hello, Sir. VBA expert here. I can do it. Best regards.
$3.092 USD in 30 Tagen
5,0 (4 Bewertungen)
4,2
4,2

Über den Kunden

Flagge von UNITED STATES
Allentown, United States
5,0
1
Mitglied seit Aug. 29, 2013

Kundenüberprüfung

Andere Aufträge von diesem Kunden

Convert VB5 w/Access to VB6 w/Excel
$1500-3000 USD
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.