Hi Gerald
Thanks for the feedback.
The search function is a bit slow because I built this application with very little use of VB coding. The search is performed by repeatedly "filtering" data by running multiple queries and writing the data to a new table each time. This is what takes the time. I originally did it this way, because at the time my VB skills were somewhat limited. (I wrote this application many years back.) When I have the time, I will probably re-write it using coding rather than the queries, but this will probably still take some time. At the moment I am working on a WPS/PQR application.
Just some instructions on the planning/QCP application:
1) Make sure you start by entering a "job".
2) To successfully do this, you need to also select a customer. - So you need to enter that info as well.
3) Make sure you assign a "job tracking number".
When entering a QCP:
1) Open QCP database from the main menu.
2) click on "enter and edit qcp"
3) Select the job number from the drop down box.
4) Enter a QCP number.
5) Enter all relevant data as given on top part of page.
6) You can now select standard "modules" that are available by clicking on the "Add module to QCP" button. (e.g. Module 28 is for rolling and welding a shell section for a vessel.) Select by clicking on record selector on the left of the module number, and enter the weld number that you want to assign to this weld/module (e.g. LW1) and click on "Add".
7) It will now add this module to your QCP. You need to give it a sequence number depending on where in the QCP you want it to print and display. By default it is 0. If you leave all your modules 0, they will appear in the sequence that you entered them.
8) You can edit any entry in the particular module, or add more entries as you require. Just make sure you number the points in the sequence you want them to appear.
9) When you are finished, you can exit the QCP entry page and go to the pressure test or documents pages to enter info there.
10) To print the QCP and associated documents, go to the "print qcp etc" page, from the QCP menu. Select the relevant QCP, and the documents that you want to print for it.
You can also enter and print ASME VIII and BS5500 data reports if you are building a PV. They are relatively self explanatry.
Let me know if there are any more questions.
Thanks for the feedback.
Regards
Niekie Jooste
Fabristruct Solutions
www.fabristruct.com