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.18 – 8 December 2011

Bug-521 on Cube Report No Letterhead reported 2 Dec 2011 by Leticia, fixed by Rick on 8 Dec 2011:
The report is printing about 5 mm too high on the page, as of Version 3.0.0.17 - 1 December 2011.
(Spha had not checked his work on Bug-497. Fixed.)

Version 3.0.0.17 – 1 December 2011

Program validity extended to 29 February 2012.

Bug-497 on Cube Report to Client reported 26 Jul 2011 by Warren, fixed by Spha on 7 Oct 2011:
Remove labels "Our Ref", "Your Ref", Date" from the "No Letterhead" report and line up fields with pre-printed labels on letterhead. Move Refs line up, and the checkboxes line down, on both reports to match.

Version 3.0.0.16 – 2 October 2011

Serious Bug-509 on Database reported 23 Sep 2011 by Leticia, fixed by Rick on 26 Sep 2011:
Giuricich FNB: Gettign double sample numbers on Cube report, Batch 2822.
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!
(Solved by a compact and repair of the data. Also had to recreate indexes on Cubes and Cube Batches table, remove 1 duplicate cube, and re-set up referential integrity Cube Batches to Projects!)

Bug-502 on Users form (frmUsers) reported 26 Jul 2011 by Rick, fixed by Spha on 24 Aug 2011:
Remove "Roadlab Letterhead" from the top list. When we save a new User, then add data for them and try to save again, get error: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
(Done)

Bug-485 on Columnar Report reported 26 Jul 2011 by Jan-Hendrik, fixed by Spha on 22 Sep 2011:
Still producing a blank last page.
(Fixed by Spha – No logos yet...)

Bug-477 on Soil Columnar Report reported 26 Jul 2011 by Linda, fixed by Spha on 22 Aug 2011:
For Soil Columnar Report, the Print icon on the Toolbar, and File > Print, do not work. One has to use the Print button on the Report itself.

Bug-451 on Sample Register reported 18 May 2011 by Rick, fixed by Spha on 29 Aug 2011:
Selected client S A Eartworks (PTY)Ltd, typed new project. Do you want to create project? Yes. Then:
---------------------------
Requested Client Project does not Exist
---------------------------
Could not Find ClientIX='Nuffield' ProjectNo=''
Click the Yellow Plus button to Create a New Project.

Bug-449 on Sample Register reported 18 May 2011 by Rick, fixed by Spha on 28 Sep 2011:
After changing SampleIX to 11/S0676 and selecting next (2?) cell(s):
Unhandled Exception: Operation not valid because it results in a reentrant call to the SetCurrentCellAddressCore function.

Minor Bug-429 on Soil Results Columnar report reported 23 Jan 2011 by Rick, fixed by Spha on 25 Aug 2011:
On clicking Main toolbar button to print report (2nd and later?):
Error in Sub PrintToolStripButton_Click in MDImain:
Object reference not set to an instance of an object on frmCubeDiary.ShowDialog
Try the Print button on the Report instead.

Bug-370 on Sample Register reported 29 Sep 2009 by Rick, fixed by Spha on 8 Sep 2011:
Click OK: It says it saved successfully, but then this nonsense comes up (AND Cancel doesn't work!):
---------------------------
Save Data Now?
---------------------------
Save Modified Data before Closing the Form?
If you do not save, your changes will be lost!
Cancel to stop Closing the Form

Minor Bug-364 on Search form reported 20 Sep 2009 by Rick, fixed by Spha on 26 Sep 2011:
Form does not remember which type of date was used in last search (if searched by dates), but always picks top one in list. Odd, because form should be kept open with all settings?

Bug-327 on Reports reported 3 Jul 2009 by Shawn, fixed by Spha on 21 Sep 2011:
When using Arrow Keys on Navigator (Main Toolbar) with Ctrl key to jump 5 reports, Ctrl key's effect "sticks" and user can not return to moving by single reports.
(Looked at it. To avoid it, don't release the key (Shift, Ctrl or Alt) before the processing cursor disappears. Or Key down the very same key after releasing it.)

Version 3.0.0.15 – 11 August 2011

Wish-500 on Cube Report to Client reported 26 Jul 2011 by Tammy, fixed by Rick on 11 Aug 2011: Change "km to site" to "km travel".

Wish-499 on Cube Report to Client reported 26 Jul 2011 by Tammy, fixed by Rick on 11 Aug 2011:
Underlining and Bold on the "No Letterhead" report should be same as on letterhead.

Bug-492 on Asphalt data entry reported 26 Jul 2011 by Jan-Hendrik, fixed by Rick on 10 Aug 2011:
Are some final results fields still locked for data entry? Jan-Hendrik listed. Unlocked.

Wish-490 on Asphalt reported 26 Jul 2011 by Jan-Hendrik, marked "fixed" on 10 Aug 2011:
Does the sample data get stored even if there was no sample number selected beforehand? Jan-Hendrik tested this and found that even if he enters the sample data first and selects the sample no. afterwards, the test data still gets saved into the database.

Wish-478 on Sample Register reported 26 Jul 2011 by Linda, fixed by Rick on 10 Aug 2011: Samples field lengths are now: CH - 80, Layer - 80, Description - 250, CemMixType - 40, TruckNo - 40, Lane - 40, Road - 160, WhyNotOK - 80, CemPerc - 30.

Niggle-463 on Asphalt data entry reported 5 Jul 2011 by Jan-Hendrik, fixed by Rick on 10 Aug 2011:
Pressing Enter rings the bell. Solution at http://forums.devx.com/archive/index.php/t-96491.html: e.Handled = True in KeyPress.

Bug-454 on Program reported 9 Jun 2011 by Leticia, fixed by Rick on 14 Jun 2011:
No results to Approve, but there are results not yet approved? (She printed before approval. Labbie only shows unprinted batches for approval. Go to Cubes > Enter cube crushing results, find the batch. Change Load to anything, new line, change Load back, save.)

Bug-448 on Invoice Report reported 5 May 2011 by Leticia, no fix by Rick on 7 Jul 2011: Invoice numbering - See Bug-457.

Bug-442 on Sample Register reported 28 Apr 2011 by Louis, fixed by Rick on 5 Jul 2011: Soil job is there but samples are missing or attached to the wrong batch. (Compacted and Repaired database. Problem stopped.)

Serious Bug-419 on Database reported 2 Dec 2010 by Linda, no fix by Rick on 7 Jul 2011: Labbie Storing Soil Jobs under wrong Projects: Jobs are not staying connected to the Clients originally chosen. See Bug-442.

Bug-457 on Invoice Report reported 5 Jul 2011 by Leticia, fixed by Rick on 10 Aug 2011: Our Ref numbers are still being skipped when calculating the Invoice number, e.g. Gothic Construction, Toyota Parkhaven: batches 056 to 065 are on invoice Our Ref 067 (should be 066). Batches 068 to 077 are on invoice Our Ref 079 (should be 078). 066 is totally missing! (Compacted and Repaired database. Leticia says problem stopped.)

Version 3.0.0.14 – 13 July 2011

Wish-472 on Cube Report to Client reported 5 Jul 2011 by Warren, fixed by Rick on 9 Jul 2011:
Move the "km to site" and put it stacked under the "Position" label.

Minor Bug-471 on Sample Register reported 5 Jul 2011 by Jan-Hendrik, fixed by Rick on 12 Jul 2011:
Having selected, on the Asphalt menu, "Other Tests", you then have to select "Other Tests" in the Sample Numbering drop-down list on the form too, in order to get the correct columns in the grid

Niggle-470 on Menus reported 5 Jul 2011 by Rick, fixed by Rick on 11 Jul 2011:
On the Asphalt menu, seeing "Other Tests" at the top is confusing: Not obviously the Registration form. Change to "Register Other Tests".

Bug-468 on Projects Form reported 5 Jul 2011 by Louis, fixed by Rick on 11 Jul 2011:
If, on the Sample Register, you type a new project name, Tab, answer "Yes" to "create a new project", a message comes up that it can not find that project! Requested Client Project does not Exist - Could not Find ClientIX='177a Empire Place' ProjectNo='', Click the Yellow Plus button to Create a New Project.

Minor Bug-467 on Sample Register reported 5 Jul 2011 by Louis, no fix by Rick on 11 Jul 2011:
Changes to the grid column widths are not remembered. (Could Louis be closing the form with the X and not OK or Cancel? It is working for me.)

Bug-466 on Sample Register reported 5 Jul 2011 by Jan-Hendrik, fixed by Rick on 11 Jul 2011: Changes to the Contact are not saved.

Bug-465 on Asphalt sieve data reported 5 Jul 2011 by Rick, fixed by Rick on 13 Jul 2011:
If you type in the data and THEN select the sample, the data is not stored for that sample. Either fix, or don't allow data entry until a sample number is chosen. (New Subs tsbEditData_Click and LockFormControls for Asphalt Tests form, and better code in Function SaveAllOK to Cancel the Save, or lose the sample.)

Minor Bug-464 on Asphalt data entry reported 5 Jul 2011 by Jan-Hendrik, fixed by Rick on 12 Jul 2011:
BRD Average should be calculated on rounded figures, not include hidden decimals

Bug-461 on Columnar Report reported 5 Jul 2011 by Jan-Hendrik, fixed by Rick on 10 Jul 2011:
Columnar Report for Asphalt needs signature block and remarks. Footer is falling onto top of next page. A line is too short at the right under each sub-heading.

Niggle-459 on Cube Report to Client reported 5 Jul 2011 by Warren, fixed by Rick on 9 Jul 2011:
The Cube Report sometimes runs to two pages (e.g. Batch 1807). What can be done? Add "Page n of m" to make it clearer.

Serious Bug-458 on Setup reported 5 Jul 2011 by Linda, fixed by Rick on 5 Jul 2011:
Setup will not install on Linda's PC: See Bug-458 CAHWMD57.log:
Following failure messages were detected: + The referenced assembly is not installed on your system. (Exception from HRESULT: 0x800736B3)
Solution from the internet: Delete the "%userprofile%\Local Settings\Apps" folder.

Bug-455 on Cubes Receiving Form reported 21 Jun 2011 by Leticia, fixed by Rick on 5 Jul 2011:
Some registered Batches are disappearing out of the database?
(Compacted and Repaired database. See if problem still occurs.)

Bug-443 on Sample Register reported 28 Apr 2011 by Linda, fixed by Rick on 5 Jul 2011:
UCS samples registerd for an existing client (Badiboa) appear under Lonerock. Many other samples appear to have attached to the wrong jobs.
(Compacted and Repaired database. See if problem still occurs.)

Develop-446 on Reports reported 18 Apr 2011 by Jan-Hendrik, fixed by Rick on 9 Jul 2011:
Document numbering: Discussed with Hester. Add Document Number, columns for Scale and Press to Cube Crushing Diary with previous results. Add Document Number to Cube Strength LetterHead report, NLA Logo to footer.

Version 3.0.0.13 – 30 June 2011

Request-456 on Cube Report to Client reported 22 Jun 2011 by Leticia, fixed by Rick on 30 Jun 2011: km too close to Truck Number, add LDV.

Program validity extended to 31 August.

Version 3.0.0.12 – 2 May 2011

Bug-444 on Asphalt Columnar Report reported 18 Apr 2011 by Jan-Hendrik, fixed by Rick on 2 May 2011: Removed heading "Columnar Report". Used 1 cm margins and 9 pt to fit more on one page. Added Footer logo. Made data columns wider and label (first) column narrower.

Bug-445 on Asphalt reported 18 Apr 2011 by Jan-Hendrik, fixed by Rick on 2 May 2011: Are Immersion Index (C5) and ITS on our Asphalt input and report? Yes.

Program validity extended to 30 June.

Version 3.0.0.11 – 1 April 2011

Program validity extended to 30 April.

Version 3.0.0.10 – 21 February 2011

Bug-439 on Atterberg Limits reported 7 Feb 2011 (d) by Linda, fixed by Rick on 16 Feb 2011:
PI Calculation is not right on the Columnar Report, also not on die Atterberg Limits form.
(Plasticity Index = LL - PL. Also added Plastic Limit to columnar report)

Bug-441 on UCS reported 7 Feb 2011 (c) by Linda, fixed by Rick on 16 Feb 2011:
On the Columnar Report the UCS values did not show..

Serious Bug-365 on Cube Progress report reported 20 Sep 2009 by Rick, fixed by Mzamo on 25 Sep 2009 and now approved:
Cube Progress report is not selecting data correctly: Same Batch ID shows for different Projects. "Our ref" column should be Cube IX, not Our Batch ref.
Changed our ref column to Cube IX.

Bug-361 on Cube Progress report reported 25 Jul 2009 by Rick, fixed by Mzamo on 23 Sep 2009 and now approved:
Cube Reports > Cube Progress - Search fails if one tries to search on dates (none in list):
Sub ShowChildForm failed - InvalidArgument=Value of '0' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex on Showing frmReports
Child Form not can be Shown!

Version 3.0.0.9 – 30 January 2011

Bug-437 on Soil Classifications reported 30 Jan 2011 by Rick, fixed by Rick on 30 Jan 2011:
G9 (CBR90) / G8 (CBR93) Failed to Save - Function SaveAllOK in frmTestClassify
Cannot set column 'TRH14'. The value violates the MaxLength limit of this column.
(It now lets you choose which CBR to use if there is a dual classification.)

Bug-436 on Soil Results Columnar Report reported 30 Jan 2011 by Rick, fixed by Rick on 30 Jan 2011:
Soil Results > Columnar Report with search for JobID only:
Error in Function ListValues$
The specified field 'JobID' could refer to more than one table listed in the FROM clause of your SQL statement.

Bug-435 on CBR reported 30 Jan 2011 by Rick, fixed by Rick on 30 Jan 2011:
Swell % was not being calculated for NRB if MOD's Initial or Final was blank, otherwise was being calculated from MOD's Initial and Final.
Also reported by Linda, Sheet 1 on Labbie 2010-12-14.xls

Misunderstanding-431 on Search form reported 25 Jan 2011 by Rick, no fix by Rick on 25 Jan 2011:
See Sheet 1 of Labbie 2010-12-09.xls
When searching for Sample Register Report:
No results were found for this condition:
ClientIX IN ('DIE001') AND ProjectNo=1
Plese select different data!
(This Project has no results. They might have been mislaid as a result of user changing project, or finger trouble.)

Bug-434 on Road Indicator Report reported 13 Dec 2010 by Linda, fixed by Rick on 30 Jan 2011:
See Sheet 9 of Labbie 2010-12-13.xls
Soil Results > Road Indicator Report : no result given even though it was typed.
[RIR:] Displays OK for Jobs 312, 314, 306 and 311, BUT the latter two show no Logo!
(Some Clients.CoID=Null instead of 1. Did not show logo because of no data with CiID=Null in Setup table (Outer Join with Clients).)

Bug-433 on Columnar Report reported 13 Dec 2010 by Linda, fixed by Rick on 30 Jan 2011:
See Sheet 8 of Labbie 2010-12-13.xls
Soil Results > Columnar Report sometimes gives no result even though it has data.
[RIR:] Displays OK for Jobs 312, 314, but not 306 or 311!
(Some Clients.CoID=Null instead of 1. Did not show data because of Inner Join with Setup table.)

Bug-432 on CBR Form reported 13 Dec 2010 by Linda, fixed by Rick on 30 Jan 2011:
See Sheet 1 of Labbie 2010-12-13.xls
When calculating results on Results Tab, the % compaction and Swell % are blank: Should carry through from Compaction tab's calculations.

Bug-306 on CBR form reported 15 Jun 2009 by Linda, fixed by Rick on 30 Jan 2011:
% Compaction and Swell are not carrying through to calculations during first entry. Same as Bug-432 above.

Minor Bug-430 on Projects form reported 8 Dec 2010 by Linda, no fix by Rick on 24 Jan 2011:
See Labbie 2010-12-08.xls: When entering new project:
Error in the Project Price Data Grid!
You have left something blank.
If you do not know how to fix this problem, please report it. Details: Column 'ClientIX' does not allow nulls.
(Unable to reproduce: Need details.)

Bug-426 on Clients Form reported 7 Dec 2010 by Linda, no fix by Rick on 24 Jan 2011:
See sheet 4 of Labbie 2010-12-07.xls: When entering new client, called from Sample Register: Clients Data
Unhandled exception has occurred in your application. Column 'ClientlX’ does not allow nulls.
Error in Sub SetWindowState for frmClient
Column 'ClientIX' does not allow nulls.
(Unable to reproduce: Need details.)

Bug-424 on MOD reported 7 Dec 2010 by Linda, fixed by Rick on 23 Jan 2011:
See sheet 2 of Labbie 2010-12-07.xls: when plotting the MOD and OMC graph:
Error in Sub DrawChartSplines
Overflow error.
(Added message: Identical X Values = 7.2000 at two points! Curve will be ill-conditioned: Suggest you exclude one.)

Minor Bug-415 on Setup reported 24 Nov 2010 by Rick, to fix by Rick on 25 Jan 2011:
Last part of Bug-414: If Click Once is set to look for updates on the internet, it also looks there for initial installation, even if it is told to install from a CD-ROM. A workaround is to Explore into a Zip file of the Setup, and run Setup.exe there. Note that Setup.exe only gets created if the top checkbox in Project > Properties > Publish > Prerequisites is ticked: Otherwise one has to run Labbie.application.
Ravi Shankar [ravish@microsoft.com] + Saurav Basu [sauravb@microsoft.com] looked into this under Ref: 110112437443401.
Solution (06 December 2010 21:35):
- deleting the IE cache on your machine
To clear the IE cache, open a new IE8 window and press CTRL+SHIFT+DEL together, to get a window illustrated in the image below. Select all the checkboxes and hit on Delete. It will take a while and then clear the cached data.

Bug-377 on Search form reported 22 Oct 2009 by Rick, no fix by Rick on 30 Jan 2011:
Error in Sub cmdOK_Click
Invalid bracketing of name '[CubeBatches.DateSent]'.
(Does not seem to happen anymore.)

Version 3.0.0.8 – 24 January 2011

Serious Bug-390 on MOD reported 23 Jan 2011 by Rick, fixed by Rick on 23 Jan 2011:
The grid data was still not being saved! Program does not see any changes or additions to LabbieDataSet2.MODdata (in Function SaveAllOK). Unable to tell why. (Used SQL Statements to bypass Microsoft's nonsense and Update/Insert directly in database. Must refine for changes only.)

Bug-428 on Soil Results Columnar report reported 23 Jan 2011 by Rick, fixed by Rick on 23 Jan 2011:
Output not formatted: For Stabilised needs 0=No;1=On Site;2=In Lab, and date formatting.
(Date format might differ depending on machine settings – just trimming, not formatting. Aught to use LookupDate function?)

Bug-427 on Soil Results Columnar report reported 23 Jan 2011 by Rick, fixed by Rick on 23 Jan 2011:
When searching with a Job Number:
Error in Function ListValues$: The specified field 'JobID' could refer to more than one table listed in the FROM clause of your SQL statement.

Misunderstanding-425 on Module reported 7 Dec 2010 by Linda, no fix by Rick on 23 Jan 2011:
See sheet 2 of Labbie 2010-12-07.xls: No form for ITS to be calculated. (ITS was not specified for Labbie.)

Query-423 on Atterberg Limits reported 7 Dec 2010 by Linda, answered by Rick on 23 Jan 2011:
See sheet 1 of Labbie 2010-12-07.xls: What to do if PI = NP ?
(You leave the data blank and just type "NP" in the "PI" box.)

Bug-422 on Sample Register reported 7 Dec 2010 by Linda, no fix by Rick on 23 Jan 2011:
See sheet 1 of Labbie 2010-12-07.xls.
When entering sample number 10/U4145 manually: Unhandled exception - Operation is not valid because it results in a re-entrant call to the SetCurrentCellAddressCore function.
(Unable to duplicate: Need Details!)

Bug-421 on Soil Results Columnar report reported 30 Nov 2010 by Linda, fixed by Rick on 23 Jan 2011:
Information not in The Correct Places (see Sheet 4 of Labbie 2010-11-30.xls)
In Sample Details, Lane data missing between CH and Layer.

Bug-420 on Report unknown reported 30 Nov 2010 by Linda, no fix by Rick on 22 Jan 2011:
Crystal Report Windows Forms Viewer
The remaining text does not appear to be part of the Formula.
Error in File C:\DOCUME~\Linda\LOCALS~1 \Temp\temp_45e$b46-46f-4S45-2F2-bFd4Fdd7 {86061C6?-5685-4D79-M I E-473FD$5E9413}.rpt:
Error in formula. 'ClientIX='ROA004''
(see Sheet 3 of Labbie 2010-11-30.xls)
(Unless we know what report this was, we have no hope of duplicating the error.)

Serious Bug-417 on Cubes Receiving Form reported 30 Nov 2010 by Leticia, fixed by Rick on 1 Dec 2010:
Error in Sub frmCbReceive_Load in frmCubeReceive
Not a legal OleAut date.
CubesTableAdapter.Fill(Me.LabbieDataSet2Cubes)
No Data can be Shown.
(CubeIX 10/21812 had a date = 0:00. Replaced with yesterday's date -all is well.)

Bug-394 on Startup code reported 31 Aug 2010 by Rick, fixed by Rick on 17 Jan 2011:
If one clicks Cancel instead of logging in:
Program Error in Sub frmCbReceive_Load in frmCubeReceive
Unknown Search Type 2 =''
The Cube Receiving form then opens.

Version 3.0.0.7 – 24 November 2010

Serious Bug-414 on Setup reported 24 Nov 2010 by Jan-Hendrik, fixed by Rick on 24 Nov 2010:
On Labbie 3.0.0.5: Cannot Start Application - Application Validation did not succeed. Unable to continue.
Details…
Following errors were detected during this operation.
- Reference in the manifest does not match the identity of the downloaded assembly Labbie.exe.
Microsoft Support by Saurav Basu [sauravb@microsoft.com]:
Project Explorer > Project > Clean and the Rebuild may have fixed it, or
C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin>mage -cc

Version 3.0.0.5 – 23 November 2010

Wish-409 on Sample Register reported 16 Nov 2010 by Louis, fixed by Rick on 23 Nov 2010:
The field sizes for Description, Road, and Layer need to be larger (80+, 40, 30?)
(Do on site: Description is already 250 (max). Make Road 160 (was 80), CH 40 (was 12), Layer 40 (was 20).)

Minor Bug-406 on Projects Form reported 16 Nov 2010 by Rick, fixed by Rick on 21 Nov 2010:
Closing the Projects form when opened from the Sample Register form, it asks to save modified data, but "Cancel" does not stop the form closing.
The code should work, per VB Help, but it does not, so changed the Sub to avoid the Cancel Option.
(Appears to be a bug in VS 2005: e.Cancel = True set by Function SaveAsk called from Sub form_Closing, but the form closes nevertheless!)

Bug-405 on Cubes Receiving Form reported 16 Nov 2010 by Deon, fixed by Rick on 23 Nov 2010:
Batch Our Ref numbering has gaps. Why? How to prevent?
(Added Code to warn user and let them fill gaps (Batches/Cube Invoices only). Add to Soil Jobs too?)

Bug-404 on Projects form reported 16 Nov 2010 by Jan-Hendrik, fixed by Rick on 22 Nov 2010:
A blank project number is created when creating a new Project using the […] button from the Sample Register form.
(ProjectRef may still be left blank.)

Bug-403 on Sample Register reported 16 Nov 2010 by Linda, fixed by Rick on 21 Nov 2010:
"More >" button duplicates items (should clear list first).

Bug-413 on Sample Register reported 16 Nov 2010 by Linda, fixed by Rick on 23 Nov 2010:
Moved from Bug-402: Summary of Results (Landscape) gives 2009 results too, not just 2010.
(2009 Soils data was left in the database for testing purposes when in was split 2009/2010 for Cubes. Can be removed on site.)

Bug-401 on Sample Register reported 16 Nov 2010 by Louis, fixed by Rick on 21 Nov 2010:
Sample Numbering works with UCS but not the others (S and I) - they start at 1 each time. (Not true for Investigation samples, they have just saved to 10/I0003 and no more) (In Setup > References, on Tab "Samples", for "Soil Tests", change the Format from YY/S0000 to YY/\S0000 (i.e. put a backslash before the "S"). Reason: "S" is a special format character used for seconds. The backslash forces the letter S.)

Bug-393 on References form reported 31 Aug 2010 by Rick, fixed by Rick on 21 Nov 2010: The grid(s) referred to C:\Work\Labbie\Labbie.mdb

Bug-381 on Invoices Summary form reported 25 Jan 2010 by Rick, fixed by Rick on long ago: Invoicing did not work for Soil Samples.

Version 3.0.0.4 – 4 October 2010

Bug-399 on Cube report reported 1 Oct 2010 by Leticia, fixed by Rick on 4 Oct 2010: Reporting for Cruise Construction, OR Tambo, per Project for whole of 2009: "Crystal Report Windows Forms Viewer. Query Engine Error: DAO Error Code: Oxd2O.
Source: DAO.Database
Description: Query is too complex.’
Failed to open a rowset.
Query Engine Error
(Arises because of translation of BatchID IN () [not understood by Crystal reports] to list of 266 batches. Found workaround.)

Version 3.0.0.3 – 31 August 2010

First Release of Asphalt features.

Serious Bug-395 on Reverting problem reported 31 Aug 2010 by Rick, fixed by Rick on 31 Aug 2010:
After I've installed Labbie 3.0.0.3 it runs, but then when I run it again, 3.0.0.2 runs instead. To fix: Add/Remove Programs > Labbie > Change/Remove button > Restore the Application to its previous state > OK. It seems that Windows gets confused and thinks the new version is an older one.

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.

Do you want to remember this page?