What's New in Labbie – Recent Editions:

If you don't know what Labbie is, go to the Labbie Home Page!

From time to time Labbie is revised to add enhancements and fix bugs.  The list of recent revisions is below, in reverse order (latest at the top).

Version 3.0.0.2 – 3 August 2010

Bug-392 on Asphalt Tests form reported 3 Aug 2010 by Rick, fixed by Rick on 3 Aug 2010: If txtGroup1-6 text boxes for visibility of Group checkboxes are not Visible, showing of checkboxes does not work! (Made visible, but disabled, with small grey text.)

Serious Bug-391 on Setup reported 29 Jul 2010 by Rick, fixed by Rick on 3 Aug 2010: After installing Labbie.3.0.0.1 from locally-stored Setup.zip, next time it runs, it reverts to 3.0.0.0 on Jan-Hendrik's PC and on Leticia's. On my laptop it does not do this, but disappears the desktop shortcut (which Dion complains of). On my PC, installation from Internet, gives "Exception occurred loading manifest from file Labbie.exe: the manifest may not be valid or the file could not be opened". Created a new Setup.

Version 3.0.0.1 – 26 July 2010

Invoicing now works 100% with Asphalt and Soil tests.  The Invoicing form now has a combo box that lets you choose which cost centre (Cubes, Soil, Asphalt, etc.) to bill for.  You can only view billing for one cost centre at a time.

Added new form Setup > Test Components to edit the Components of tests:  In the first column ("Main Item"), specify Price List items that will be selected on the Registration form as Tests to be performed.  Repeat on as many rows as are required. In the second column ("Consists of"),  specify the one actual test to be performed as part of the main item.  For example, a Road Indicator (single Main Item to be billed) might consist of (actual tests to be performed) Sieve Analysis, Mechanical analysis,  Atterberg Limits, MOD, and CBR (5 rows). The ("Consists of") tests need not have prices in the Price List, unless they can also be done separately.

The Setup > Price List form now has two new items in the "Test" column's combo box: Asphalt, and Composite.  The latter will be used to tie in with tests in the Components table.  The former will allow all Asphalt tests to be carried out on the sample.

Added Soil Test and Asphalt menus to Help.

Version 3.0.0.0 – 21 June 2010

First Release of Labbie Asphalt.  Sample lists on the Asphalt forms now show Asphalt samples only. Enter and down arrow key move the focus down, up arrow key moves it up, Tab moves to the right  (where applicable).  The Asphalt Sieve form now allows readings to be taken cumulatively per sieve (as before) but also individually per sieve (Roadlab method, as on Soils Sieve form) and will try to warn you if you are using the wrong method.

Version 2.0.1.4 – 7 June 2010

Full Beta Release of Labbie Asphalt.

Serious Bug-386 on Hydrometer form reported 31 Jan 2010 by Rick, fixed by Rick on 31 Jan 2010: Error in Sub dgvHydroData_CellEndEdit in frmTestHydro: Error 9: Index was outside the bounds of the array. Hydrometer Calculations. (Bug in Sub D422Table3)

Bug-376 on Pastel Export reported 21 Oct 2009 by Debi, Abandoned by Rick on 25 Jan 2010: Some Labbie invoices imported into Pastel are allocated to March instead of the correct month: 3 in August, some in Sept/Oct. Debi to fax a printout (never received). Unable to explain, but has not recurred.

Version 2.0.1.3 – 21 May 2010

Beta Release of Labbie Asphalt forms (reports still to come).

To allow Labbie to run a 64 bit driver (AccessDatabaseEngine_X64) for Access 2010 one, the user can now change the Connection String if the program can not make the connection.  The string "Provider=Microsoft.ACE.OLEDB.12.0" is placed on the clipboard and can be pasted to replace the usual "Provider=Microsoft.Jet.OLEDB.4.0".  This has to be done per PC as it is stored locally in the Registry.

Extensive changes have been made to e-mailing to allow sending using SMTP (localhost and address), MAPI, Outlook, and MailTo, to address the following bugs: Bug-229, Bug-249, Bug-275.  See Help for details.  This also allows the e-mailing of many reports that could not previously be e-mailed directly, such as Cube Diary and Cube Month Statistics.

Fixed Bug-229 on e-mailing reported 14 Oct 2008 by Shawn: Roadlab can't e-mail. SMTP address smtp.isdsl.net agrees with Outlook, but gives error: Invalid SMTP Server Address. Address isdsl.net on its own does not work either.

Fixed Bug-249 on e-mailing reported 28 Jan 2009 by Shawn: Setup > Company > Test Connection works, but e-mailing from report still says "bad SMTP address".

Fixed Bug-275 on e-mailing reported 25 Apr 2009 by Rick: Error on emailClient.Send in Sub cmdTest_Click in frmSetup: "Invalid SMTP Server Address? User not local; please try a different path. The server response was: User not local!"

Version 2.0.1.2 – 15 April 2010

Pre-Beta Release of Labbie Asphalt.

Version 2.0.1.1 – 7 April 2010

Released with expiry date of 7 June 2010.

Version 2.0.1.0 – 12 March 2010

Re-released program with corrected expiry date of 7 April 2010.

Version 2.0.0.20 – 12 March 2010

On the Samples form, the column "% Cement" may now include text, e.g. "10% OPC".

On the Samples form, on the right of "Project", you can now specify the type of test (only Soil Tests are operable at present).  Invoices are separated according to the type of test.  Columns in the grid may vary depending on the type of test.

On the Invoice Summary form, you can now specify the Cost Centre (type of test).  Only Cube Tests can be Invoiced at present.

The Asphalt menu has been added, but items on it are not functional yet.

Version 2.0.0.19 – 25 January 2010

Bug-383 on Sample Register reported 25 Jan 2010 by Rick, fixed by Rick on 25 Jan 2010:
Sample Register form (and others) lose their Title Bar text.

Minor Bug-380 on Cubes Receiving Form reported 25 Jan 2010 by Rick, fixed by Rick on 25 Jan 2010:
"There are no Prices set for this Project." when there are in fact prices set (on recalculating Billing - Sub cmdDuplicate_Click).

Bug-382 on View/Print Reports reported 11 Dec 2009 by Rick, fixed by Rick on 25 Jan 2010:
"Mark as Printed" fails: Error in Function ListValues$ - Operation is not allowed when the object is closed.

Bug-350 on Sample Register reported 4 Sep 2009 by Louis, fixed by Rick on 25 Jan 2010:
"Error in Sub cmdProjects_Click in frmSampleRegister: A column named 'ItemDesc' already belongs to this DataTable." after closing Projects form and editing billing, Project opened from Samples
(Put code in Sub BillingGridSetup to exit if there are columns.)

Develop-105 on Price List form reported 15 May 2008 by Rick, fixed by Rick on 25 Jan 2010:
Added a choice for "Visit" to combo box here and on Project billing. On cubes receiving billing, if Visit is set and there are km, bill for one visit, not for km.

Version 2.0.0.18 – 11 December 2009

The Soil Summary, Road Indicator, and Extended Road Indicator reports have been improved with the addition of UCS in the same columns as CBR if there is no CBR, date sampled, who sampled by, position, and other minor improvements.

Version 2.0.0.17 – 12 November 2009

Serious Bug-378 on Cubes Receiving Form reported 11 Nov 2009 by Leticia, fixed by Rick on 12 Nov 2009: Can't Save Cubes: Error in Sub SaveDataChanges in frrnCubeReceive
The INSERT INTO statement contains the Following unknown Field name: ‘ApprovinglD’, Make sure you have typed the name correctly, and try the operation again.  Updating CubeBatches
(Someone changed the field name "ApprovingID" to "ApproviatID" in the Cube Batches table. Fixed.)

Bug-375 on Search form reported 20 Oct 2009 by Modise, fixed by Rick on 21 Oct 2009:
Searching on Client and Project says "no results found for this selection". However the results are there and searching on Client, batch nos, etc does find results. The problem occurs only where there are duplicate project names (it may find the wrong client).

Version 2.0.0.16 – 16 October 2009

Bug-374 on Cubes Receiving Form reported 15 Oct 2009 by Leticia, fixed by Rick on 15 Oct 2009:
Enter and Save. Click Yellow plus button for a new Batch, and enter Client: The other boxes do not enable!
(Sub SaveDataChanges was skipping the line fLoading = False)

Version 2.0.0.15 – 14 October 2009

Develop-356 on Cubes Receiving Form reported 4 Sep 2009 by Rick, fixed by Rick on 14 Oct 2009:
Need automatic invoicing of slump tests, and Standing Time, which should replace Travel Time.

On the Prices form and the Billing tab of Projects, you can now specify prices as Bill for = Slump, Standing.  If "Slump" occurs in a Project's billing list and the Cubes Receiving form has a measured slump, one slump test will automatically be billed on the billing tab (or with the Recalculate Billing button).  On Cubes Receiving form, the field "Standing Time" replaces "Travel Time".  If this is filled in and the Project's billing list form has a "standing" item, standing time (in hours and fractions of an hour) will automatically be billed on the billing tab (or with the Recalculate Billing button).

Bug-372 on Invoice Export reported 13 Oct 2009 by Diane, fixed by Rick on 14 Oct 2009:
The message headed "Write Pastel Import Files?" does not explain what Yes and No do.
(Added Message "Yes = Proceed.", "No = Change the Pastel folder.")

Serious Bug-373 on Invoice Export reported 13 Oct 2009 by Diane, fixed by Rick on 14 Oct 2009:
Error in Sub InvoiceAll in frmReports: Conversion from string "117.csv" to type "Integer" is not valid.

Serious Bug-368 on Sample Register reported 29 Sep 2009 by Rick, fixed by Rick on 14 Oct 2009:
Sample Tests grid combo box is missing the PrIX and Description!
(May occur only if one starts a new project from the Sample Register form?)

Bug-352 on Sample Register reported 4 Sep 2009 by Louis, fixed by Rick on 14 Oct 2009:
Sample Billing not saving on Version 2.0.0.13. Was OK in previous version? No.
In fact there is no Billing Button yet. (Sample Billing now works.)

Bug-369 on Sample Register reported 29 Sep 2009 by Rick, fixed by Rick on 29 Sep 2009:
"Duplicate Sample and its Tests" button was not working.

Bug-322 on Projects Form reported 30 Jun 2009 by Rick, fixed by Rick on 29 Sep 2009:
Bug at demo: Billing tab - Left combo not refreshing after a visit to the Prices form? Got unhandled exception. (Refresh button handles now. Made it refresh whole grid so it does both combos.)

Bug-321 on Projects Form reported 30 Jun 2009 by Rick, fixed by Rick on 29 Sep 2009:
Bug at demo: Billing tab - combo box with Cubes etc does not allow blank anymore!
(Depended on Prices table. Now forced. Also made drop-down lists 20 lines long.)

Serious Bug-309 on Invoice Report reported 15 Jun 2009 by Leticia, fixed by Rick on 23 Aug 2009:
Leticia says that Tannie Gerrie is finding that figures do not add up to totals. Will scan and send example (never did).  (This was fixed as Bug-348 on 23/08/2009.)

Bug-241 on Holidays form reported 26 Oct 2008 by Rick, fixed by Mzamo on 30 Sep 2009:
Data for Holiday name and the two checkboxes do not display. The two checkboxes do not display and not adding HolID to new records.

Bug-218 on Deployment reported 14 Sep 2008 by Rick, fixed by Rick on 29 Sep 2009:
After compiling from a different machine (or new Labbie1_TemporaryKey.pfx, which had expired): Application Cannot be Started. Contact the Application Vendor.  Temporary solution is to reinstall.
(Certificate LabbieKey3.pfx extended to 2014 using C:\Work\RoadLab\Renewcert.exe. See Bug-367)

Serious Bug-367 on Certificate reported 21 Sep 2009 by Rick, fixed by Rick on 21 Sep 2009:
SignTool reported an error 'Failed to sign bin\Debug\Labbie.publish\\setup.exe. SignTool Error: ISignedCode::Sign returned error: 0x80880253: The signer's certificate is not valid for signing.
Solution: Run Renewcert.exe obtained from http://www.may.be/renewcert/
For more details see C:\Work\VS\RenewCertif\RenewCert\May.be
This takes old certificate, creates new one that expires in five years' time.

Version 2.0.0.14 – 20 September 2009

Bug-354 on Invoice form reported 4 Sep 2009 by Leticia, fixed by Rick on 7 Sep 2009:
"View Data" button not working: Reference not set to an instance of an object. This also happened with the "Delete" button.

Serious Bug-347 on Cubes Receiving Form reported 20 Aug 2009 by Rick, fixed by Mzamo on 11 Sep 2009: Spurious message (not true) after changing the Days for a new cube (commented out for release):
"NOTE: There are test results. If you change the test day here you will lose the results and have to re-enter them: Is this OK?"

Bug-333 on Crushing Diary report - today reported 26 Jul 2009 by Rick, fixed by Mzamo on 28 Aug and Rick on 20 Sep 2009: Shows all days instead of Today! Margins set. If no cubes today, date does not show. Caption "Verification of Cube Diary Report" fixed.

Bug-332 on Cube Progress report reported 25 Jul 2009 by Rick, fixed by Mzamo on 28 Aug 2009:
New report does not show any data. Title should be "Cube Progress" not "Verification of Cube Progress".

Develop-331 on Soil Test forms reported 24 Jul 2009 by Rick, fixed by Mzamo on 9 Sep 2009:
All Soil Test forms (sieve, through MOD to Classifications) must be able to be opened more than once. Sieve, Mech, Hydro, Atterberg, MOD, CBR, UCS, Field, Other, Classifications can now be opened more than once. New Bug-358: Program overlays windows of the same Form, even if moved apart.

Develop-233 on Cube Progress report reported 14 Oct 2008 by Rick, fixed by Mzamo on 6 Aug 2009:
Report needs preceding search. Removed likely mpa, add size2 next to size1, use batchid not batchno and project name not projectno.  Search hide group boxes ("Search Results to Show" and "Options to Output…").

Develop-155 on Cubes Receiving Form reported 26 Jun 2008 by Rick, fixed by Mzamo on 27 Aug 2009: Button to easily duplicate the Batch (ask if user wants it with/without cubes).

Bug-144 on Cubes Receiving Form reported 23 Jun 2008 by Rick, fixed by Mzamo on 21 Aug 2009:
One could change the "Days" value if there are test results.  Now program warns you and you lose the results if you proceed, and the batch is marked as not yet approved.

Wish-106 on Projects form reported 15 May 2008 by Rick, fixed by Fixed by Rick on 19 Sep 2009:
Billing tab: Added Refresh button on the local toolbar that you can use to re-query the combo box if the price list has been changed on another form.

Version 2.0.0.13 – 23 August 2009

Serious Bug-348 on Invoice Report reported 21 Aug 2009 by Diane, fixed by Rick on 23 Aug 2009:
Invoice totals are sometimes wrong. This was a display problem. Correct totals were always exported to Pastel. Corrected on report and in code. "Closed Invoices" code changed to allow reprinting and re-exporting of old invoices.

Bug-349 on Pastel Export reported 21 Aug 2009 by Diane, fixed by Rick on 23 Aug 2009:
Error on importing the file: "Line Items do not Exist".  Solution: Open Setup > Price List and check that "Billing Code" on the right is filled in for the Item numbers concerned. Civilab's Pastel GL codes must be filled in because they are different to the Price List Item numbers.

Version 2.0.0.12 – 20 August 2009

Added Soil Tests > Hydrometer Corrections form, which allows test data for Hydrometer Readings vs. Temperature to be entered per Hydrometer and Cylinder as per ASTM, plotted, and Correction Factors (slope of line) to be worked out.  Hydrometer readings form altered to suit: Hydrometer and Cylinder combo boxes added; choosing both causes Correction Factor to be looked up from Hydrometer Corrections list.

Cubes > Cubes Receiving form has a new button, "Duplicate Batch", that will duplicate all the batch data (data in the top frame) to a new batch, with a new batch number.  You mast add cubes in order to save the new batch.

Cube Reports menu rearranged into a more logical order, with most-used reports at the top.

A few Cubes menu items were renamed slightly.

Version 2.0.0.11 – 5 August 2009

Bug-336 on Program reported 3 Aug 2009 by Rick, fixed by Rick on 3 Aug 2009:
Error Unable to find manifest signing certificate in the certificate store. MDI_ES
(I found in the project properties the tab "Signing". The checkbox "Signing the ClickOnce manifest" was checked. Uncheck it and the error disappears.)

Bug-335 on Program reported 3 Aug 2009 by Rick, fixed by Mzamo on 5 Aug 2009:
Labbie Errors on a new development PC: faxcomexlib.faxdocument is not defined, faxcomexlib.faxServer is not defined.  (The fax services are not installed! Go to Control Panel > Add and Remove Programs > Windows components. Tick "Fax Service" and install.)

Bug-334 on Search Received Cubes reported 27 Jul 2009 by Rick, fixed by Rick on 27 Jul 2009:
Error in Sub frmCbReceive_Load in frmCubeReceive
Cannot find column [Cubes.DateCast].
No Data can be Shown!
(Mzamo error removed)

4 Aug 2009: Modified Setup > Company to show the Header and Footer logos at the size they will be printed.  You can now widen the form (by dragging an edge) to see the full width of the logo.

Version 2.0.0.10 – 27 July 2009

Serious Bug-328 on Soils Reports reported 24 Jul 2009 by Linda, fixed by Rick on 24 Jul 2009:
All the Soils Reports are blank! There IS data.
(In Sub form_Shown, there was an extra Case "JobSamples", with no code.)

Bug-299 on Soil Classifications reported 15 Jun 2009 by Linda, fixed by Rick on 16 Jun 2009:
TRH14 & COLTO should use UCS results if CBR not available. Check standards: COLTO makes no provision to use UCS, but does not need CBR for G1-G3. TRH14 makes no provision to use UCS, but does not need CBR for G1. (Allowed TRH14 G1 & COLTO G1-G3 if no CBR. Deon says can't use UCS instead of CBR (not in standards).)

Bug-283 on Search form reported 29 Apr 2009 by Rick, fixed by Mzamo on 22 Jul 2009:
Projects Search does not work for specified project, only for Client.
(Note: May find wrong project if there are duplicate names!)

Minor Bug-243 on Humidity form reported 11 Nov 2008 by Rick, fixed by Rick on 19 Nov 2008:
If you type a Humidity and then backspace to blank, the program has an unhandled exception. Same with temperature on the Bath Temperature.

Minor Bug-222 on Client & Projects form reported 29 Sep 2008 by Rick, fixed by Mzamo on 22 Jul 2009: When I Cancel the Client or Projects form, it asks me to save modified data, even if there is none. Carried from Bug-125

Minor Bug-181 on Projects Form reported 20 Jul 2008 by Rick, fixed by Mzamo on 16 Jul 2009:
On the billing tab, the grid must be sorted by Item Number.

Bug-175 on Login reported 11 Jul 2008 by Rick, fixed by Mzamo on 14 Jul 2009: When you change Password on the Login form, then try to log in thereafter, it stays on the Change Password part.

Develop-156 on Cubes Receiving Form reported 26 Jun 2008 by Rick, fixed by Mzamo on 21 Jul 2009:
Extra checking: Min cube size = 70, max = 300 (both sides, side1 and 2). Does not apply to cores.

Develop-154 on Search form reported 26 Jun 2008 by Civilab, to fix by Mzamo on 14 Jul 2009:
Search: We need to be able to search Crushing Diary report by date. & See Bug-153
(Only done for Crushing Diary report with previous results.)

Develop-153 on Search form reported 26 Jun 2008 by Civilab, to fix by Mzamo on 10 Jul 2009:
We need to be able to search Crushing Diary report by Batch number (ID). & See Bug-154
(Only done for Crushing Diary report with previous results.)

Wish-138 on Company Setup form reported 13 Jun 2008 by Rick, fixed by Mzamo on 16 Jul 2009:
Form should respond to F1 button for Help, or have Help button.

Bug-123 on Search form reported 6 Jun 2008 by Rick, fixed by Mzamo on 22 Jul 2009:
1. Projects Search is titled "Compressive Strength Test Report".
2. Search for a project on its own does not work - probably looking for project no instead of project no + Client IX.

Minor Bug-122 on Projects Form reported 6 Jun 2008 by Rick, fixed by Mzamo on 22 Jul 2009:
Open the form. Move to the next record. Click Cancel. Why does it think that data has changed?

Minor Bug-76 on Clients Form reported 31 Oct 2007 by Rick, fixed by Mzamo on 22 Jul 2009:
The Save and OK buttons should dim when not required, including after save
Also, "Save" lights up when moving from record to record even if nothing has changed! (RIR 23/06/2008).

Version 2.0.0.9 – 2 July 2009

Internal Bug-320 on Sample Register reported 1 Jul 2009 by Mzamo, fixed by Rick on 1 Jul 2009:
System.InvalidOperationException was unhandled
DataMember property 'FK_Jobs_Samples' cannot be found on the DataSource."
DataMember property 'FK_Samples_SampleTests' cannot be found on the DataSource."
(Relations had been renamed in LabbieDataSet2.xsd)

Bug-319 on Invoice form reported 24 Jun 2009 by Diane, noted by Rick on 25 Jun 2009:
Appears to be putting batch number in place of correct Our Reference. Wihan says Rose is still getting correct references on Cubes Receiving. Wihan spoke with Rose and they have indeed been putting in the batch no as our reference – so just a misunderstanding.

Wish-318 on MOD form reported 15 Jun 2009 by Rick, fixed by Mzamo on 1 Jul 2009:
Compactive effort now has a combo box.

Bug-317 on MOD form reported 15 Jun 2009 by Rick, fixed by Rick on 18 Jun 2009:
Final moisture content calculation: Is Geosure method according to spec, or Roadlab's?
Geosure method has been hidden (Not to THM1 A7).

Niggle-323 on All forms reported 2 Jun 2009 by Rick, fixed by Mzamo on 2 Jul 2009:
It would be nice if forms would remember their previous state (restored or maximized) so that they go back to that state when one swaps to that form using the Window menu.

Bug-231 on Cubes Receiving Form reported 14 Oct 2008 by Shawn, fixed by Rick on 16 Jun 2009:
Invoice numbers are not included: Batch numbering ignores previous invoice numbers.
(Fixed a while ago.)

Develop-212 on Login form reported 8 Sep 2008 by Rick, fixed by Rick on 16 Jun 2009:
Title bar of form should display "Log in to ". Startup should check whether the database being opened is indeed a Labbie database. (Done some time ago.)

Bug-188 on Cubes Receiving Form reported 4 Aug 2008 by Shawn, fixed by Rick on 16 Jun 2009:
Numbering Our Ref: Does not include Our Refs used in Invoice numbering. (Was fixed some time ago.)

Version 2.0.0.8 – 16 June 2009

Develop-316 on Invoicing reported 28 May 2009 by Diane, fixed by Rick on 16 Jun 2009:
It should be possible to set the Invoice Printer to "None". Leticia also needs it.
(Was already possible, though a bit hidden (Export Type on Invoices Summary). Added option to Tools menu: No Invoice Printing.)

Serious Bug-305 on MOD form reported 15 Jun 2009 by Rick, fixed by Rick on 16 Jun 2009:
Form wants database on C:\Work\Roadlab.

Minor Bug-304 on Atterberg form reported 15 Jun 2009 by Linda, no fix by Rick on 16 Jun 2009:
Closing form: Created new test for sample.(Can't duplicate.)

Minor Bug-302 on Sample Register reported 15 Jun 2009 by Linda, fixed by Rick on 16 Jun 2009:
Changes to fields in Sample Register (Job):
- Change "Position of Samples" to Comment, rearrange and fix tab order.
Changes to fields in Samples Grid:
- Remove Condition
- Make Road 80 chars.
- Add "Type of Cement" (was there, just hidden).
- "Date Made" appears as 25/00/2009 for Linda (format was dd/mm/yyyy, needs MM)
- Add checkbox "Sample Suitable for Testing?" and reason.

Minor Bug-301 on Soil Classifications reported 15 Jun 2009 by Linda, fixed by Rick on 16 Jun 2009:
Error closing form: This operation requires an IBindingList in Sub cboSampleGoTo.

Bug-299 on Soil Classifications reported 15 Jun 2009 by Linda, fixed by Rick on 16 Jun 2009:
TRH14 & COLTO should use UCS results if CBR not available. Check standards: COLTO makes no provision to use UCS, but does not need CBR for G1-G3. TRH14 makes no provision to use UCS, but does not need CBR for G1.
(Allowed TRH14 G1 & COLTO G1-G3 if no CBR. Must consult Deon for using UCS instead of CBR.)

Bug-298 on Sample Register reported 15 Jun 2009 by Linda, fixed by Rick on 16 Jun 2009:
Errors occur in right-hand grid when navigating between some jobs:
Sample Tests Data Grid Error trapped in Sub dgvSampleTests_DataError:
DataGridViewComboBoxCell value is not valid.
(Arises when item is no longer in the Price List for this Project. Improved error message.)

Wish-274 on Invoices Summary form reported 23 Apr 2009 by Diane, fixed by Rick on 16 Jun 2009:
Error in Function OpenCSVFiles when Invoicing. They changed the path to Pastel: Improve error message.  (Improved error message; also made it check earlier if folder exists (and ask if it does not).)

Version 2.0.0.7 – 15 June 2009

On the Soil Tests menu: Atterberg Limits now has a second chart, Expansiveness, plotted from a new button on the right.  The percentage clay (percent passing 2 micron sieve size) is required, either from Hydro analysis, or directly input. This chart is remembered for later printing.  The MOD graph is now remembered for later printing.

On the Soil Results menu: Foundation Indicator now shows the grading curve and, where it exists, a second chart, Expansiveness.  There are two new reports: Foundation Indicator with MDD and CBR, and Road Indicator.

Version 2.0.0.6 – 9 June 2009

Serious Bug-297 on Cubes Receiving Form reported 9 Jun 2009 by Leticia, fixed by Rick on 9 Jun 2009: Labbie hangs when choosing Client "Nesandla", Project "Weltevreden Brakpan". Reason: Function RefOurCubeBatch goes into an infinite loop when checking for duplicate Our Ref in Invoices, if the Project number has too many characters (probably because the ClientIX is too long).
(Put in code to kick out of loop and warn the user.)

Various Microsoft Report Viewer reports have been changed to Crystal Reports versions, with the ultimate aim of eliminating Report Viewer from the program.  Ongoing.

The MOD table in the database has been renamed to "MODs" to avoid a naming conflict with a built-in function.

Version 2.0.0.5 – 28 May 2009

Sieve analysis now plots a grading curve, and this is stored in the database so that the correct one displays as you move from record to record.

Version 2.0.0.4 – 24 May 2009

Various Soil Test menu items have been debugged, improved and/or adjusted to adapt to practice at Roadlab.  Sieve analysis can now be done using cumulative or individual pan masses (radio button to choose, with checks).  Atterberg graph improved and interpolation done Log-Linear, also recalculates if tin mass changes.  CBR Saving bug fixed, new option to swap Mod and Proctor.  MOD decimals reduced, now fills in sample number.  UCS arranged as Mod then Proctor, with option to swap.  Plotting has been improved in various ways.

Added a new File menu item: "Restore Connection" to re-connect to the database if connection has been lost (for example due to a power interruption or spike on a switch).  Use this instead of re-starting Labbie if you get a message that database connection has been lost.

Version 2.0.0.3 – 19 May 2009

Soil Results > Soil Test Summary now works, with search.

Version 2.0.0.2 – 17 May 2009

Bug-296 on Cubes Receiving Form reported 14 May 2009 by Wihan, fixed by Rick on 16 May 2009:
Some of the project no’s (“C” no’s) change to different no’s after the input has been done. This can be seen either when searching received cubes or viewing results for approval.

Additionally, added two small arrow buttons on the right of "Our Ref":
| Uses a Previous "Our Ref" (cycles through up to 3 previous values –useful for Civilab to re-use the same Job number), } Calculates the Next "Our Ref" for this Project.

Bug-295 on Approve Cube Results reported 14 May 2009 by Modise, fixed by Rick on 14 May 2009:
Modise wants Search button for "Approve", and print buttons re-enabled.

Serious Bug-294 on CBR reported 13 May 2009 by Rick, fixed by Rick on 14 May 2009:
Failed to Save - Function SaveAllOK in frmTestCBR: Query is too complex, CBRTableAdapter.Update. 
Problem solved by editing the DataSet Update Command.  The CBR form is now fully functional, including graphs.

Bug-292 on Projects Form reported 13 May 2009 by Rick, fixed by Rick on 13 May 2009:
On Labbie 2009 from Roadlab, from Receive Samples, […] to existing project, added prices using button. OK/Save not enabled, so added contact. Clicked OK:
"Save failed - Data can not be Saved! The record cannot be deleted or changed because table 'Jobs' includes related records on"
Looks like VB trying to unnecessarily "change" the Project No. Need cascade update & delete on Projects link to Jobs table. (Enabled BindNavSaveItem in the Add Prices button. Added cascade update & delete on Projects link to Jobs table.)

Bug-291 on Report form reported 12 May 2009 by Rick, fixed by Rick on 12 May 2009:
The Search Type "CubeDiar" has not been programmed for in rptCubeStrength.
Error occurred on "View Report" button on "Enter Cube Results", and "Invoice Details" forms.

Version 2.0.0.1 – 12 May 2009

Serious Bug-290 on Approve Cube Results reported 12 May 2009 by Leticia, fixed by Rick on 12 May 2009: The "Approve" and "Reject" Checkboxes weren't showing!  Fixed

Bug-286 on Cube Report to Client reported 5 May 2009 by Shawn, fixed by Rick on 12 May 2009:
Labels have become all lowercase on "No Letterhead" report. Fixed.

Version 2.0.0.0 – 11 May 2009

CBR Plotting and final calculations added.  Tests tables recreated in back-end with full referential integrity including Cascade Update and Cascade Delete to fix bug "The record cannot be deleted or changed because table 'MODdata' includes related records.".

Bug-289 on View Closed Invoices reported 8 May 2009 by Leticia, fixed by Rick on 8 May 2009:
When checking closed invoices I want to go to the last invoice and this is the message that I get every time I press the arrow at the top next to viewing invoice:
Unhandled Exception, object reference not set to an instance of an object.
(Appears to have been fixed already. However search for Closed Invoices was also displaying open ones: Fixed.)

Bug-288 on Cubes > View reported 29 Apr 2009 by Rose, fixed by Rick on 5 May 2009:
CubesTableAdapter.Fill failed: Cannot find column [CubeBatches.ClientIX].

Bug-285 on Cubes Receiving Form reported 30 Apr 2009 by Leticia, fixed by Rick on 5 May 2009:
Amoya JHB eye clinic account reference did not continue instead of 82 it was 83.
(No explanation unless 82 was created and then deleted.)

Bug-284 on Cubes Receiving Form reported 29 Apr 2009 by Leticia, fixed by Rick on 5 May 2009:
Cruise Construction, O R Tambo Int Airport "Our Ref" is stuck on 60, does not increment.
(Cruise Construction Ref Number 59 was /59/ not /059/. Made more robust.)

Bug-272 on Invoice Report reported 31 Mar 2009 by Diane, fixed by Rick on 30 Apr 2009:
Labbie runs out of memory after a few invoices and has to be re-started.
Error in Sub InvoicesTasks in rptCubeStrength: Exception of type 'System.OutOfMemoryException' was thrown. (Reports have been thoroughly revamped and now search only for the items required, instead of the whole database –error has not occurred since)

Version 1.2.0.15 – 30 April 2009

The Search form for all Cube Reports and View/Print has been tidied up and a new Group added to allow you to preview (and export) reports by Cube Batch (as before), by Project, or all in one report.

Bug-278 on Cubes > Cube Batches reported 29 Apr 2009 by Rose, fixed by Rick on 29 Apr 2009:
When opening form from search: "Argument 'Path' is Nothing or empty" in Sub SetColumnWidths..
When closing form, Labbie crashes on unhandled exception in Sub SaveColumnWidths.
(Also added minor improvements to grid: Allow column resizing, reordering, and freeze first three columns.)

Serious Bug-276 on Setup Form reported 25 Apr 2009 by Rick, fixed by Rick on 25 Apr 2009:
Setup Form no longer saves: Labbie.frmSetup.cmdOK_ClickClick failed:
"No value given for one or more required parameters on Microsoft JET Database Engine"
(Civilab dB has no Date/Time field "Archived" which is present in RoadLab version. Added code to add.)

Request-268 on Cubes Receiving Form reported 31 Mar 2009 by Smittie, fixed by Rick on 20 Apr 2009: Meeting Issue 6: Disallow updating of Cubes Receiving data (dates etc) after approval --or require authorisation?  (Gives warning if approved, and sets back to "not approved" if the user proceeds. Could be tightened up to demand password.)

Request-267 on Invoice form reported 31 Mar 2009 by Smittie, fixed by Rick on 28 Apr 2009:
Meeting Issue 5: Invoicing process is too cumbersome (printing is too slow). (Fixed with Bug-265)

Request-265 on Cube Report to Client reported 31 Mar 2009 by Smittie, fixed by Rick on 28 Apr 2009:
Meeting Issue 3: Output cumbersome - only one report at a time (per file). Add "Batch" option to put all results for a project into one file. (Also speeded up Crystal Reports considerably.)

Serious Bug-263 on Database reported 31 Mar 2009 by Smittie, fixed by Rick on 28 Apr 2009:
Meeting Issue 1: After updates, it seems historical data is lost? (January) How can we ensure confidence in data integrity? Earlier bug now fixed? (Created new Report > Cube List (Integrity Check) and compared cubes at three time-frames. Seem OK.)

Version 1.2.0.14 – 20 April 2009

Request-273 on Projects Form reported 4 Apr 2009 by Rick, fixed by Rick on 4 Apr 2009:
Some users find the search for Duplicate names annoying. At the same time it is not that useful since it searches only the current client. Thus the duplicate MULDERSDRIFT PRECAST SLABS for Civilab were not picked up.
(Improved search to search all clients, and unsaved data, but added checkbox "Check Duplicate Names?" to optionally turn the feature off temporarily. Contacts and Output choices brought to first Tab.)

Request-270 on Cubes Receiving Form reported 31 Mar 2009 by Smittie, fixed by Rick on 6 Apr 2009:
Meeting Issue 7: km are often omitted when required. Dangerous to just carry forward previous km for the project. Drop-down list of previous km? Checkbox for collected/delivered?
(Added Combo Box for km filled from previous entries and Project km, and for Supplier, Made by, Delivered by, filled from previous entries. Added error-checking for numeric entries – a warning [red circle with exclamation mark] appears if the data is not numeric: Hover the mouse over it for a Tooltip)

Request-268 on Cubes Receiving Form reported 31 Mar 2009 by Smittie, fixed by Rick on 20 Apr 2009:
Meeting Issue 6: Disallow updating of Cubes Receiving data (dates etc) after approval --or require authorisation?
Change: The form now locks when data has been saved, including after a search. User has to click "Edit Data" button on the form's toolbar in order to edit saved data.  The program warns the user if data was approved, and sets back to "not approved" if the user proceeds. It could be tightened up to demand password.

Request-266 on Invoice form reported 31 Mar 2009 by Smittie, fixed by Rick on 20 Apr 2009:
Meeting Issue 4: Invoicing - Quantities not generating automatically (zero cubes)? Line for zero km inserted (rather omit).
Change: Program now recalculates billing more aggressively, but omits lines where amount is zero.  When you swap to the billing tab, a new button "Recalculate Billing" appears, which you can use to recalculate and replace all the billing.  It also warns you if the Project has no Prices, and tells you to click the [...] button at the top to go to the Project form to put in the prices.

Bug-264 on Cubes Receiving Form reported 31 Mar 2009 by Smittie, fixed by Rick on 1 Apr 2009:
Meeting Issue 2: After changing a project name, it put in wrong name? (January) See various printed examples: Muldersdrift etc. Earlier bug now fixed?
Could be Bug-254 on Cubes Receiving Form reported 5 Feb 2009 by Thys? When you search for a batch, it comes up with a different Client for the batch. Thys was not sure if the cube data stays, will get back to me. I can't replicate it: This appears not to happen anymore.
(Seems to be an isolated incident: See e-mail 01/04/2009 16:24, "LABBIE Data Confidence". 4 Projects changed names.)

Bug-262 on Invoice form reported 30 Mar 2009 by Rick, fixed by Rick on 30 Mar 2009:
Found and fixed bug: "Show Data" button was not going to the right Batch(es).
Made "Show Data" and Delete buttons put data back in same Sort Order when done.

Bug-261 on Invoices reported 30 Mar 2009 by Leticia, fixed by Rick on 30 Mar 2009:
Please check batch id 640,643,657,581 for Cruise Construction, OR Tambo Airport: No "Our Ref", "Cast On", or Received.
(Batches 640, 643, and 657 do not exist, 581 exists but seems to have lost its "Our Ref". Queried with Leticia.  The creation of "Our Ref" may have been happening on record changes: Now fixed.)

Version 1.2.0.13 – 30 March 2009

Reissue to fix problem: Labbie won't run because Visual Basic Power Pack is not installed (removed Visual Basic Power Pack from References again and uninstalled from development PC).

Version 1.2.0.12 – 29 March 2009

Improved Soils Tests: Atterberg, Mech, Hydro, UCS now working well; Sieve, Field tests working; MOD, CBR and Generic data input.  Minor database changes.

Version 1.2.0.11 – 16 March 2009

Reissue to fix problem: Labbie won't run because Visual Basic Power Pack is not installed (removed horizontal line from Generic test form, and Visual Basic Power Pack from References).

Version 1.2.0.9 – 15 March 2009

Improved Soils Tests: Atterberg, MOD, Generic tests.  Added File > Import > Tins and File > Import > Moulds.

Version 1.2.0.8 – 8 March 2009

Improved Soils Tests: Sieve, Mechanical Analysis, Hydrometer.  Saving and calculations.

Version 1.2.0.7 – 4 March 2009

Beta version of Soils Tests (Phase4).  Working Sample Register Form and Search.

New buttons on Projects form: Add Default Prices (this copies the Prices from the Price List that have the Test column filled in –duplicates may result in the Bill For column, in which case the program warns you) and Open Price List (so that you can inspect and edit Prices).

New column on the Price List Form: Job Type (combo box can be All, Soil, Aggregate, Asphalt, Bitumen, Rubber, Cores, or Cubes).  This will be used later so that you only get the tests and pricing applicable to the type of job for which you are entering samples.  The Test column now has a combo box that can be set for Travel, Visit, Cubes, Set (of Cubes), any of the Soils Tests that have their own data forms, or Generic. "Generic" allows results to be entered for any test, but does no calculations.

Version 1.2.0.6 – 27 February 2009

Revised Pre-Beta version of Soils Tests (Phase4) with References for Jobs and Samples, Price List for Samples.

Version 1.2.0.5 – 9 February 2009

Serious Bug-255 on Cubes Receiving Form reported 6 Feb 2009 by Wihan, fixed by Rick on 9 Feb 2009: A batch number is not assigned when cubes are received.  The program crashes if you try to save.

Bug-256 on Updating reported 6 Feb 2009 by Wihan, fixed by Rick on 6 Feb 2009:
After the installation of 1.2.0.4 directly from Setup.zip, Labbie opens under the correct version. But when closed and reopened it opens as 1.2.0.3.
(Only on PCs with Internet access. Labbie apparently updates off the internet even if it is an older version. Uploading the full internet update fixed it.)

Serious Bug-254 on Cubes Receiving Form reported 5 Feb 2009 by Thys, marked as supeseded by Rick on 9 Feb 2009: To get around Bug-253 they tried entering the same data again, but when they search for it, it comes up with a different Client for the batch. Thys is not sure if the cube data stays, will get back to me (did not).  (Can't replicate: This appears not to happen anymore.)

Version 1.2.0.4 – 6 February 2009

Serious Bug-253 on Approve Cube Results reported 3 Feb 2009 by Wihan, fixed by Rick on 6 Feb 2009: Some batches are not appearing for approval - Wihan sent data and examples.
(It appears that using the "Mark as Printed" function with no Output checkboxes selected, marked unapproved batches as printed, so they did not appear for approval anymore. Fixed. The Search on "Approve Cubes" (toolbar button) has been changed to ignore Approval if you search on cubes or batches.)

Major enhancements to Search form: You can now search on Cube IX, Client Cube Ref, or Batch ID for all searches that involve Cubes.  All can take multiple values separated by commas.  Cube IX and Client Cube Ref can take single values with the "%" (any characters) wildcard.

The navigation buttons on the main toolbar now allow you to use shift keys to jump a number of pages: Shift = Jump by 5, Ctrl = 20, Shift+Ctrl = 100, Alt = go to First or Last.

Version 1.2.0.3 – 3 February 2009

Data Error-252 on Cubes Results Form reported 30 Jan 2009 by Leticia, fixed by Rick on 2 Feb 2009:
Error in frmCubeDiary_Load: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints on Filling on Provider=…
---------------------------
Also manifests as:
A) After approving cubes: Labbie Error in Sub SaveData in rptCubeStrength
B) On Searching Received Cubes: Error in Sub frmCbReceive_Load in frmCubeReceive
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. CubesTableAdapter.Fill(Me.LabbieDataSet2.Cubes): No Data can be Shown!
(Cube 09/00118 was duplicated in the Cubes table (only visible after a compact and repair). Removed and all is well. Also removed empty batch 53. Cube 09/00534 is missing from Batch 114.)

Version 1.2.0.2 – 30 January 2009

Serious Bug-251 on Invoices Summary form reported 29 Jan 2009 by Shawn, fixed by Rick on 30 Jan 2009: He was busy invoicing, got: Error in Function RefOurCubeBatch in Module Shared. Error -2147217900 — Syntax error in string in query expression RefOur LIKE ‘# AND DateGotCubes> =#1/1/2009# AND DateGotCubes<#1/1/2010#’.

Version 1.2.0.1 – 29 January 2009

Pre-Beta version of Soils Tests (Phase4).

Press Ctrl+F to search this page for keywords. Search this site: using Custom Search Do you want to remember this page?