Feature | Programs | Support | Training | Development | Downloads | Free Tools | Newsletter | Links | About Us

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 6.0.1.7 – 1 September 2015

Expiry date extended to 1 January 2016.  More error-trapping added to References form.

Version 6.0.1.6 – 1 June 2015

Expiry date extended to 1 August 2015.

Version 6.0.1.5 – 1 April 2015

Expiry date extended to 1 June 2015.

Version 6.0.1.4 – 1 February 2015

Expiry date extended to 31 March 2015.

Version 6.0.1.3 – 1 December 2014

Expiry date extended to 31 January 2015.

Version 6.0.1.2 – 1 November 2014

Expiry date extended to 30 November 2014.

Version 6.0.1.1 – 1 October 2014

Expiry date extended to 31 October 2014.

Version 6.0.1.0 – 30 June 2014

Expiry date extended to 30 September 2014.

Bug-728 on DCP Report reported 14 May 2014 by Phinda, fixed by Gram on 15 May 2014:
Search on DCP Reports - Phinda (Langa GeoTech)
---------------------------
Error in Sub LoadData in frmReports
No value given for one or more required parameters.
Getting DCP Report Data - DataAdapter Fill
Programmer Check: is SQL$ up to date?
---------------------------
Fix for this bug, commented code under Sub DisplayDCP
(If one searches using client name and project name the error message shows but searching using sampleIX and/or JobID or client name, project name plus sampleIX the required report is generated.)

Bug-669 on Start-up reported 16 Sep 2013 by Gram, fixed by Rick on 19 Sep 2013:
Opposite from Bug-304, when the user clicks OK button the warning message
will show up:
–––––––––––––-
Program Error in Sub frmCbReceive_Load in frmCubeReceive
Unknown Search Type 2 =''
(Press Ctrl+Insert to copy this message to the Clipboard)
–––––––––––––-

Version 6.0.0.9 – 1 April 2014

Expiry date extended to 30 June 2014.

Bug-723 on Help reported 11 Feb 2014 by Rick, fixed by Rick on 18 Feb 2014:
Help on Import Form, and new Help on File > Import menu, do not open the correct page.

Bug-722 on Import Clients reported 11 Feb 2014 by Rick, fixed by Rick on 11 Feb 2014:
"Client ID + Pastel a/c" is not recognised as a Key Field.
Clients table field names are EditedBy and Edited, not ModifiedBy and ModifiedOn!
Client ID + Pastel a/c does not fill Client ID into Pastel a/c, puts 0 instead.
First record (heading) is imported too [cannot replicate -debugging error?]

Misunderstanding-718 on Clients Form reported 14 Jan 2014 by Marshall Stevens, fixed by Rick on 14 Jan 2014:
At the moment Martie can’t capture any new client details. Please assist as a matter of URGENCY.
(Is it possible that Martie has not noticed the Edit button?)

Wish-721 on Program reported 14 Jan 2014 by Rick, fixed by Gram on 17 Mar 2014:
To prevent occurrences like Misunderstanding-718 (Martie can’t capture any new client details because of the new Edit button), Labbie should check if it is a new upgrade (check if the Ver Date has changed in the Updates table) and, if so, tell the user that it is an upgrade and ask if they would like to see what is new in the program. In which case open Help > What's New. "If you click No, we suggest that you click 'Help > What's New' later."

Bug-719 on UCS reported 14 Jan 2014 by Linda, fixed by Rick on 16 Jan 2014:
Linda has entered Sample 14/U0002 and it appears on Soil Summary for Diesel Power Opencast Mining cc (job 622: AMD Group Five), but it does not appear in the UCS form's combo box, so she can't enter results for it.
Reason: This arises because the Sample Register form and table confuse RefID and JobType. RefID (7) from the RefNumbers table is stored in the JobType field in the Jobs table, whereas the JobType should be 2 (soil) and RefID should have its own field. Other forms, like UCS, use JobType as Job Type (2=soil), so 7 does not appear.
Fix: Add RefID field to the Jobs table and separate the use of RefID and JobType in the Sample Register form.
(In the UCS form combo box, type the sample number and press Enter. Labbie will then ask if you want to put in that sample's results (Yes). Added new combo box "Job Type" to Sample Register form.)

Bug-717 on Crushing Diary form reported 14 Jan 2014 by Martie, fixed by Gram on 15 Jan 2014:
Labbie does not allow me to click “View Report” from the menu item: Cubes > Enter Cube Crushing Results > View Report.
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue, If you click Quit, the application will close immediately. The Microsoft Jet database engine cannot find the input table or query ‘DocumentNos1’. Make sure it?
When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.

Bug-716 on Database reported 14 Nov 2013 by Gram, fixed by Gram on 11 Mar 2014:
Loma cannot find projects for clients that previously had projects.
(Database corruption - fixed.)

Bug-714 on Database reported 28 Oct 2013 by Gram, fixed by Gram on 11 Mar 2014:
Found Corrupt records on invoices table.

Bug-713 on Database reported 28 Oct 2013 by Gram, fixed by Gram on 11 Mar 2014:
The message that popped up when opening Loma Database via access: see picture in link. The database did not open when button "No" on the message was clicked, "Yes" button had to be clicked
(Compact and Repair fixed it.)

Bug-705 on Generic Test form reported 7 Oct 2013 by Gram, fixed by Gram on 7 Oct 2013:
On form load the below error message shows up:
---------------------------
DataGridView Default Error Dialog
---------------------------
The following exception occurred in the DataGridView:
System.ArgumentException: DataGridViewComboBoxCell value is not valid.
To replace this default dialog please handle the DataError event.
---------------------------
(Added Private Sub dgvGenFields_DataError with detailed error reporting. The error is caused by referential intergrity, generic test PrIX on GenFields and on Price table is not generic)

Minor Bug-704 on Rigorous Classifications reported 7 Oct 2013 by Gram, fixed by Gram on 7 Oct 2013:
If the user searches for all classification records by using form search, the below error message shows up before loading the data:
---------------------------
Error in Sub LoadDataExt in frmTestClassify3
---------------------------
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
---------------------------
(This error message showed up as result of duplicate records on the database, hence we now have a sub GetDataSetErrors under modCommon that reads the duplicates and writes them to text file)

Minor Bug-703 on Field Data reported 7 Oct 2013 by Gram, fixed by Gram on 7 Oct 2013:
On form Load, the below error message shows up, when button ignore is clicked the field data form continues to load as required.
---------------------------
Error in Sub LoadData in frmFieldData
---------------------------
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Running Search:
---------------------------
(This error message showed up as result of duplicate records on the database, hence we now have a sub GetDataSetErrors under modCommon that reads the duplicates and writes them to text file)

Minor Bug-701 on Classifications reported 7 Oct 2013 by Gram, fixed by Gram on 7 Oct 2013:
If the user searches for all classification records by using form search, the below error message shows up before loading the data:
---------------------------
Error in Sub LoadData in frmTestClassify
---------------------------
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Running Search:
---------------------------
(This error message showed up as result of duplicate records on the database, hence we now have a sub GetDataSetErrors under modCommon that reads the duplicates and writes them to text file)

Bug-700 on Database reported 6 Oct 2013 by Rick, fixed by Rick on 6 Oct 2013:
On LomaLabbie2013, Loma Lab still has problems with classifications.
Found 2 corrupt Classifications records (new since Thursday?). Copied all good data to new Table, deleted old one, renamed new as Classifications. There was NO Relationship between Classifications and Samples. Created one-to-many relationship after deleting records that violated referential integrity.
There was NO Relationship between MODs and MODdata. Created one-to-many relationship after deleting records that violated referential integrity.
There was NO Relationship between Hydro and HydroTimes. Created one-to-many relationship (no records violated referential integrity). HydroTimes had not key fields. Created SampleIX+TimeRead as combined key.
(Check if Roadlab needs any of these changes!)

Niggle-699 on Classifications:Test Classify reported 3 Oct 2013 by Gram, fixed by Gram on 7 Oct 2013:
If one searches for a sample, then closes the form the below message shows
---------------------------
Error in Sub cboSampleGoTo_SelectedIndexChanged in frmTestClassify
---------------------------
This operation requires an IBindingList.
---------------------------
(This error message showed up as result of duplicate records on the database, hence we now have a sub GetDataSetErrors under modCommon that reads the duplicates and writes them to text file)

Niggle-697 on Field Data Form reported 2 Oct 2013 by Gram, fixed by Gram on 7 Oct 2013:
If one searches for a particular record and closes without entering data fields the below message shows.
---------------------------
Error in Sub cboSampleGoTo_SelectedIndexChanged in frmTestFieldData
---------------------------
This operation requires an IBindingList.
---------------------------
(This error message showed up as result of duplicate records on the database, hence we now have a sub GetDataSetErrors under modCommon that reads the duplicates and writes them to text file)

Bug-696 on Classifications: frmTestClassify reported 2 Oct 2013 by Gram, fixed by Gram on 2 Oct 2013:
GoTo Sample combo does not search, one has to use form search
(Code already existed from rigorous classifications, just copy and paste, named load data sub accordingly.)

Bug-695 on Classifications reported 2 Oct 2013 by Lindi, to fix by Gram on 12 Mar 2014:
So this is the third attempt to classify theses samples. I re-entered the data after Bluepoint did a compact and repair on the database.(Friday and yesterday)
Also they reloaded info from the backed up files.
---------------------------
Error in Sub cmdCalc_Click in frmTestClassify
---------------------------
Operation is not allowed when the object is closed. Classification
---------------------------
(Error was caused by database corruption, after fixing the database (deleting duplicates, corrupt records, doing compact and repair) the error was solved.)

Bug-694 on Mechanical Analysis reported 2 Oct 2013 by Lindi, to fix by Gram on 12 Mar 2014:
Getting Sieve data by clicking "Get Sieve Data" button
No sieve analysis values.
Sieve analysis for sampleIX = "13-03300" does not exist
(Error was caused by database corruption, after fixing the database (deleting duplicates, corrupt records, doing compact and repair) the error was solved.)

Bug-693 on Classifications reported 2 Oct 2013 by Lindi, to fix by Gram on 12 Mar 2014:
---------------------------
Error in cmdCalc_Click in frmTestClassify
---------------------------
Not a valid Bookmark. Classification
---------------------------
(Error was caused by database corruption, after fixing the database (deleting duplicates, corrupt records, doing compact and repair) the error was solved.)

Minor Bug-689 on Clients Form reported 1 Oct 2013 by Gram, fixed by Gram on 1 Oct 2013:
If the user clicks AddNew button on the binding navigator and decides to search while the fields are empty, the below error message shows.
Column 'ClientIX' does not allow nulls.
(Added code under Sub:FindClient If….Else…statement enabling user to search even if textboxes are empty If txtClient.Text = "" Then
TableAdapter.Fill do normal search Else Do normal search)

Bug-686 on Field Data Form reported 25 Sep 2013 by Gram, fixed by Gram on 7 Oct 2013:
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Running Search:
––––––––––––-–
(This error message showed up as result of duplicate records on the database, hence we now have a sub GetDataSetErrors under modCommon that reads the duplicates and writes them to text file)

Bug-685 on Field Data Form reported 23 Sep 2013 by Gram, fixed by Gram on 7 Oct 2013:
---------------------------
Error in Sub cboSampleGoTo_SelectedIndexChanged in frmTestFieldData
---------------------------
This operation requires an IBindingList.
---------------------------
(This error message showed up as result of duplicate records on the database, hence we now have a sub GetDataSetErrors under modCommon that reads the duplicates and writes them to text file)

Bug-687 on reports reported 20 Sep 2013 by Lindi, fixed by Gram on 13 Mar 2014:
Lindi Cannot View or Print Graphs
I plotted the Van der Merwe graphs (expansiveness button) ; then saved ; clicked okay ; opened Foundation Indicator Reports ; searched for one of the lab ref. numbers (Sample Nos ) ; then I immediately got the error message.
It occurs for all lab numbers and jobs.
Under all circumstances.
This problem has been occurring since the last time we talked about it and mentioned it as a priority.
Please refer to Alrika’s e-mail of 27 Aug. 2013.
(Apparently data corruption)

Niggle-676 on Company Setup form reported 17 Sep 2013 by Gram, fixed by Rick on 12 Mar 2014:
Company information form should be read-only, only the administrator, owner and manager will have duties and access to edit company information. So that other users do not fiddle and change the information as they see fit.
(No change will be done here, because by default company setup form was read-only and only high level users can edit company information)

Misunderstanding-673 on Projects Form & Clients Form reported 17 Sep 2013 by Gram, fixed by Gram on 17 Sep 2013:
Saved a new client for the purpose of assigning a project to that client, when I select the client from the combo box, the msg below shows, after clicking Yes it would then take me to client form to fill the details and save again BUT the msg below "Error in sub…….." would show up first
---------------------------
Labbie Message
---------------------------
Do you want to enter a new CLIENT
"GramLetoaba " ?
---------------------------
Below msg shows after clicking Yes
---------------------------
Error in Sub SetWindowState for frmClient
---------------------------
Column 'ClientIX' does not allow nulls.
---------------------------
(Uncommented "For each….. " statement that was commented enabling the program to save new client information For Each ro As Data.DataRow In modClients StatusBarSet("Updating " & ro("ClientIX") & " " & ro("Client")) Me.clientTableAdapter.Update(r)

Bug-663 on Generic Test form reported 28 Aug 2013 by Rick, fixed by Gram on 7 Oct 2013:
Error opening form:
–––––––––––––-
Error in Sub form_Load in frmTestGenData
–––––––––––––-
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Loading Generic Fields data
–––––––––––––--
(This error message showed up as result of duplicate records on the database, hence we now have a sub GetDataSetErrors under modCommon that reads the duplicates and writes them to text file)

Bug-662 on Max Dry Density reported 28 Aug 2013 by Rick, fixed by Gram on 17 Feb 2014:
Searching for tests 1 Jul 2013 to date in data from LomaLabbie2013-08-15.zip:
---------------------------
Error in Sub LoadData in frmTestMDD
---------------------------
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Running Search:
-------------------------–
(This error is caused by database corruption, specifically duplicate records. To solve this error problem we now have GetDataSetErrors sub capturing and writing corrupt records on LogFile, as soon as the corrupt records are deleted, the error will go)

Serious Bug-660 on Generic Test form reported 28 Aug 2013 by Rick, fixed by Gram on 7 Oct 2013:
When opening the form, it endlessly repeats this error:
–––––––––––––-
DataGridView Default Error Dialog
–––––––––––––-
The following exception occurred in the DataGridView:
System.ArgumentException: DataGridViewComboBoxCell value is not valid.
To replace this default dialog please handle the DataError event.
–––––––––––––-
(Added Private Sub dgvGenFields_DataError with detailed error reporting. The error is caused by referential integrity: generic test PrIX on GenFields and on Price table is not generic)

Version 6.0.0.8 – 5 January 2014

Expiry date extended to 31 March 2014.

If there is no user with a security level of 5 ('Administrator') then, if User = 'Administrator' exists, it is set to Level 5, otherwise User named 'Administrator' is created at Level 5.

Develop-692 on User form reported 1 Oct 2013 by Gram, fixed by Gram on 1 Oct 2013:
We do not provide a search for users, what if we have hundreds of users and want to search quickly for a particular user………Similar search method on clients can come in handy.
On form load, user details are read only until the user clicks button edit, allowing the user to update the user details
(Created a search field, user information can be searched using user name as search criteria.)

Niggle-688 on User form reported 30 Sep 2013 by Gram, fixed by Gram on 30 Sep 2013:
Users, Full users and Supervisors must NOT add new users, only the administrator and other high level users should be able to do that, in that way the administrator will know who is accessing the system, the manager, developer can also be able to add new users.
(Users and supervisors can only read user information. Admin, Developer, Owner, Manager are all able to do CRUD on users)

Serious Bug-659 on Visual Studio 2013 reported 28 Aug 2013 by Rick, fixed by Rick on 28 Aug 2013:
Error in Function OpenAndCheckBackend in modDatabasefrmLogin
-------------------------–
Could not load file or assembly 'Interop.ADODB, Version=2.8.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.
–––––––––––––-
Both System.Data.CTP.dll and System.Data.Entity.dll are mixed-mode assemblies (have both native and managed code in them) so they're platform-specific. For this CTP we only shipped 32-bit versions of the binaries, so you either need to run it in a 32-bit OS or you have to make your application run inside WoW64. To force the app to run in WoW64 you can go to the project properties in VS, select the "build" tab, and set the "platform target" to x86 [in Configuration manager].
Pablo Castro, ADO.NET Technical Lead, Microsoft Corporation
http://social.msdn.microsoft.com/Forums/en-US/41623cb4-107f-4bba-8167-4c78aad16e3b/systembadimageformatexception-
(Was "Any CPU". C:\Work\Labbie\Labbie2013\obj\Debug\Interop.ADODB.dll Removed refence to ODODB and replaced with latest. Visual Studio Help useless as usual.)

Bug-487 on All Reports reported 26 Jul 2011 by Jan-Hendrik, fixed by Rick on 16 Sep 2013:
Footer has a non-white background colour. Redo. Got logos from Jan-Hendrik.

Version 6.0.0.7 – 21 October 2013

Expiry date extended to 31 December 2013.

Bug-711 on Database reported 14 Oct 2013 by Rick, fixed by Rick on 14 Oct 2013:
Loma Lab data problems: The Sieve data will not import via my new Labbie "Import > Database" function, I have to do it manually. The import gives “Unrecognized database format 'P:\Labbie\LomaLabbie2013.MDB'.”, yet Access recognises the database. The Sieve table must have some corruption.
(Works OK with Monday's data.)

Bug-710 on Database reported 14 Oct 2013 by Rick, fixed by Rick on 14 Oct 2013:
Loma Lab data problems: SampleTests apparently had 182 records, yet on import, it had 1962. This is somehow different to the MODdata case, since when I open the databases in MS Access, they both have 1962 records.
(Seems OK in the new database.)

Bug-709 on Database reported 14 Oct 2013 by Rick, fixed by Rick on 14 Oct 2013:
Loma Lab data problems: MODdata apparently had 828 records, yet on import, it had 833: 5 “invisible” records for sample 13-03622 miraculously pop into existence when the table is imported. This may be the cause of the “MOD not saving” error – These “invisible” records may be confusing Labbie (they certainly confuse me!).
(Seems OK in the new database.)

Bug-708 on Database reported 14 Oct 2013 by Rick, fixed by Rick on 14 Oct 2013:
Loma Lab data problems: The Classifications had a duplicate Sample 13-020930. This should be impossible, as SampleIX is a unique key field, meaning it cannot be duplicated. Yet it is there. This could have been causing problems with Classifications.
(Seems OK in the new database.)

In solution of all the above, added a new option, File > Import > Database, to import all data from an existing database into a fresh, blank database (which Software Africa must create for this purpose).  Because of the obscure problem that can arise (very infrequently) if a database goes deeply corrupt, it is better if the import is done at Software Africa, as was done on Monday 14 October 2013 and uploaded that evening.

Serious Bug-661 on Visual Studio 2013 reported 28 Aug 2013 by Rick, fixed by Rick on 9 Sep 2013 in VS 2013 version:
Opening Licensing Form - Error in Sub frmLicence_Load in frmLicence
Could not load file or assembly 'Interop.Scripting, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.
(References: Removed Scripting Runtime and used My.Computer.FileSystem per http://msdn.microsoft.com/en-us/library/vstudio/dhc4wh9w(v=vs.100).aspx )

Version 6.0.0.6 – 21 August 2013

Bug-657 on Classifications reported 1 Aug 2013 by Lindi, fixed by Rick on 20 Aug 2013:
Unified Classification: Labbie classifies as GC, GM-GC what Loma Lab classifies as SC, SM-SC and so on.  There was indeed an error: Labbie was swapping sand with gravel. I have corrected that.  Still need clarity (moved to Bug-658) on the criteria for Gravel: Definition 1 (if R4 / R200 > 0.5, it's Gravel, where R4 = % retained on 4.75 mm sieve, and R200 = % retained on 0.075 mm sieve), or Definition 2 (if R4 > 50%, it's Gravel). For the “simple” classification, I have meanwhile programmed Labbie to ask whether to use Definition 1 or 2 where it makes a difference. For the “rigorous” classification, I have kept Definition 1 (the current definition).

Serious Bug-656 on Setup reported 31 Jul 2013 by Hannelene, fixed by Rick on 15 Aug 2013:
Cannot Start Application - Application cannot be started. Contact the application vendor.
ERROR DETAILS:
* [2013/07/31 03:16:22 PM] System.ArgumentException
- Value does not fall within the expected range.
(Uninstalled Labbie from Control Panel > Programs and Features then re-installed, which fixed the issue)

Bug-652 on Storing reported 14 Jun 2013 by Alrika, fixed by Rick on 14 Jun 2013:
This is the results for LL2057 but is saves it as LL2071 – HELP Please!
(Replied it is LL2071, but PDF is LL2057. If data really for LL2057 then job was allocated to wrong project. Should be easy to correct: go into Soil tests > Search Sample Register, search for job 644, change Client and Project. No reply from site, so closed this issue)

Version 6.0.0.5 – 23 July 2013 (Released 29 July)

Changes to File splitting to allow for inactive projects to be deleted, and projects to be made active or inactive interactively during the process (specified by Project Ref).

Version 6.0.0.4 – 10 July 2013

Wish-654 on Hydrometer report reported 8 Jul 2013 by Lindi, fixed by Rick on 9 Jul 2013:
Can we please change the hydrometer heading to: Grain Size.

Bug-651 on Sub StartUpForm reported 21 May 2013 by Rick, fixed by Rick on 21 May 2013:
When startup form for a user is set to "Receive Cubes":
Program Error in Sub frmCbReceive_Load in frmCubeReceive:
Unknown Search Type 2 =''
(Other errors result on other startup choices)
(Sub StartUpForm moved from modCommon to form MDImain and revamped.)

Bug-653 on Licence reported 4 Jul 2013 by Lindi, in progress on 10 Jul 2013:
Message "This Licence is for a different drive!" but it was set up specifically for that drive. Wrong drive in serial number from site - does not match Key Data. Why?
Added code to Licensing database and Labbie to check.

Expiry date extended to 10 September 2013.

Version 6.0.0.3 – 19 May 2013

Bug-650 on Sample Register reported 26 Apr 2013 by Lindi, fixed by Rick on 19 May 2013:
Error in Sub Form_Load - Error 5: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. Setting the Connections.
On the line Me.PricesTableAdapter.Fill(Me.LabbieDataSet2.Prices)
Error does not recur if you click "Retry" but then get Error in Sub cboSampleRef_SelectedIndexChanged in frmSampleRegister
Conversion from type 'ComboLineInt' to type 'Integer' is not valid.
Followed by (new On Error) Error in Sub cboCostCentRef_SelectedIndexChanged in frmSampleRegister
Conversion from type 'ComboLineInt' to type 'Integer' is not valid.
(To fix: Removed relationFK_SampleTests_Prices from LabbieDataSet2.xsd)

Version 6.0.0.2 – 15 April 2013

This version allows the price list to be updated in a more flexible fashion including deleting and renumbering items, and releasing new prices at a later date than the import.

Three new fields have been added to the Prices table: PrIXnew (proposed new Item Number; use "Delete" to delete), RateNew (new Rate (without VAT) that can be released later), and Delete? (checkbox to mark if Item should be deleted, and alternative to putting  "Delete" in PrIXnew).

File > Import > Prices has been improved and now imports the new fields PrIXnew and RateNew too.  Normally you will import one Rate only: Rate itself if the prices are for immediate release, RateNew if they are to be released later.  If you omit Item Number (as for a new Item), Labbie will propose new, temporary, values, starting with "New00".

The Prices form (Setup > Prices) now has three new toolbar buttons:

  • Mass Delete: Deletes all items with the "Delete?" checkbox marked or "Delete" in PrIXnew.
  • Renumber: Renumbers all Item Numbers to new PrIXnew value (if it exists).  Before doing so, it will reformat all PrIXnew values in two-digit format (NN.NN).
  • Mass Re-price (Release New Rates): This changes the Rates to the RateNew values (where they exist), and removes RateNew.

Version 6.0.0.1 – 10 April 2013

Wish-649 on All Charts fixed by Rick on 9 Apr 2013:
Arising out of Bug-648 (Roadlab request to make DCP Graph clearer), used a different routine for the text on charts, resulting in clearer text presentation. Added Main Title to all charts, and made X- and Y-Titles bold. Sizing and positioning of chart improved.
(Graphs must be re-plotted to see the effect.)

Bug-647 on Foundation Indicator Report reported 2 Apr 2013 by Lindi, fixed by Rick on 9 Apr 2013:
Foundation Indicator Report needs Client reference, as on Columnar Report. Also the layer as well. Done on all three Indicator reports.

Bug-648 on DCP Report reported 14 Mar 2013 by Linda, fixed by Rick on 9 Apr 2013:
Changes to DCP Report Beta for First Release:
• Client info block on top of each page
• Alignment of client's info (Project & Client)
• Font for results made smaller (changed from 10 pt to 9 pt)
• Date at bottom of page OK, time not needed (removed).
• Improve graph quality – can be controlled by user, by plotting a larger graph. Added a button to DCP Form to use optimum graph size.
• Signature line a bit shorter.
• Under the ‘’signature’’ Roadlab wanted the person's name, his position in the company and under that ‘’Technical Signatory’’.
(Added “Technical Signatory” but the rest can not be done at present as we do not have approval process yet, when Labbie will know whose name (and signature) to use, as on Cube side.)

Bug-646 on CBR reported 27 Feb 2013 by Lindi, fixed by Rick on 27 Feb 2013:
"Go To Sample" list not sorted: SQL "ORDER BY Samples.SampleIX" statement in wrong place.

Bug-645 on Foundation Indicator Report reported 26 Feb 2013 by Lindi, fixed by Rick on 9 Apr 2013:
The columnar report is correct. But the Foundation Indicator Report should be 0.026 as well and not 0.260 (just one value).

Version 6.0.0.0 – 19 February 2013

Bug-644: DCP Snag List reported 30 Jan 2013 by Linda, fixed by Rick on 19 Feb 2013:
First release of Phase 6: Detailed Classifications form with COLTO C-Class, ITS (on UCS form) and DCP.

Bug-642 on Classifications reported 13 Feb 2013 by Lindi, fixed by Rick on 18 Feb 2013:
The combo box list for Go To Sample is not sorted.
(Also in 3 Asphalt forms, Atterberg, CBR, DCP, Generic, Hydro, MDD, Mech, and UCS.)

Bug-641 on Max Dry Density reported 13 Feb 2013 by Lindi, fixed by Rick on 19 Feb 2013:
On Sample 13-00226, changed mould volumes on first tab. Labbie does not change previously-calculated results on 2nd tab. This is by design, as first tab data is supposed to be done first. Dangerous! Changed to recalculate 2nd tab if first changes.

Bug-640 on CBR reported 13 Feb 2013 by Lindi, fixed by Rick on 13 Feb 2013:
Moulding Moisture Content: The average (to 1 decimal) often does not match hand calculations.
(Changed to display 2 decimals for the individual results, and do the average on the full (instead of rounded) numbers.)

Bug-638 on Atterberg Limits reported 13 Feb 2013 by Gladys, fixed by Rick on 19 Feb 2013:
Type a sample number in Go To box, Labbie says "No Atterberg Limits as yet, add?". Answer Yes - won't save (no diskette, duplicate sample no). Have to answer "NO" to get it to save. Also on CBR and all other Soil & Asphalt forms.
(Evaded the "as yet" question if Sample number has already been set. Also changed AutoCompleteMode from SuggestAppend to Append to avoid 2nd List.)

Misunderstanding-637 on Search form reported 13 Feb 2013 by Joseph, fixed by Rick on 13 Feb 2013:
Search does not always work, e.g. for sample 13-00329.
(Joseph was connected to the wrong database: Backups\Lomalabbie.mdbusy – So was Bertie!)

Bug-633 on Hydro form reported 5 Feb 2013 by Hannelene, fixed by Rick on 6 Feb 2013:
Data Gnd Error in Hydro Data in frmTestHydro
Error: System.Data.ConstraintException: Column SampleIX, TimeRead is constrained to be unique. Value '12-03924, 2' is already present.
Sender: System.WindowsForms.DataGridView
Starting Function SaveAlIOK
(Replied 06/02/2013 10:49 with guidelines. Unable to duplicate error (compiled and development versions) but put in a lot more error-checking.)

Version 3.1.0.12 – 4 February 2013

Bug-631 on New Classifications form reported 23 Jan 2013 by Lindi, fixed by Rick on 3 Feb 2013:
Error in sub cmdCalc_click: Operator '>' not defined for type DBNull and type integer

Bug-630 on Max Dry Density report reported 22 Jan 2013 by Lindi, fixed by Rick on 4 Feb 2013:
Change the MOD reports so all 3 dates are day/month/year.
(Also renamed report to rptSoilMDD.rpt, but can't rename Query to qrySoilMDD without losing Crystal Report fields)

Bug-615 on Labels report reported 4 Dec 2012 by Lindi, fixed by Rick on 4 Feb 2013:
The Labels print but without some information. It prints the word Project – but there is no project information: Client, Project, or Client Ref.
(Re-created using qrySoilSummary (same as Sub DisplaySoilReports) to make all data display. Does not work using individual tables)

Minor Bug-606 on Indicator reports reported 13 Nov 2012 by Lindi, fixed by Rick on 4 Feb 2013:
"Sampled" shows the hour as well as the date –remove.

Bug-632 on Database reported 30 Jan 2013 by Hannelene, possibly fixed by Rick on 4 Feb 2013:
CBR frequently will not save, despite several attempts. I think the database needs a compact and repair, which will make it more efficient.
This did not work.  Blue Point Africa also did a disk scan to see if the hard drive was problematic.
I picked up the database from Dropbox and tried some tests over the weekend. My development version had no problems saving CBRs, but the release version did have problems sometimes, so we are issuing a new release today.  Added some traps to prevent saving attempt if there is no SampleIX, and report as an error if the SampleIX disappears.

Version 3.1.0.11 – 16 January 2013

Develop-622 on Database reported 8 Jan 2013 by Rick, fixed by Rick on 12 Jan 2013:
Allow Admin user to move entries for the new year to a new database.
Procedure: (1) Warnings, check if Admin user, all others must be logged off. (2) Ask for new name, suggest with year at end. (3) Close database. (4) Copy Database (5) Open old database: Remove entries for this year. (6) Open new database: Remove entries prior to this year.
(This option is currently only available for Roadlab. Need to add licensing for other labs)

Develop-624 on Soil Test forms reported 9 Jan 2013 by Rick, fixed by Rick on 15 Jan 2013:
Make "Go to samples" drop-down list more versatile:
1) Loosen the list to show samples registered within the last two months.
2) Let user type in (or paste) any sample number even if it is not in the list, as already works on the Classifications (rigorous). In this case, one of the following happens:
(a) If the Sample exists and has test data, Labbie loads it up and displays it.
(b) If the Sample exists but has no test data, Labbie offers to let you enter it now.
(c) If the Sample does not exist, Labbie asks you to check your typing.

Bug-627 on Generic Test form reported 15 Jan 2013 by Rick, fixed by Rick on 15 Jan 2013:
Search was getting Sample list from Sieve table instead of GenResults.
After Search, Redo Field visibility (Added Sub DisplayFields()).
Go to SampleIX list was not showing samples in last 2 months.
In Go To Price IX list, now display just the Generic tests that have Defined Fields (in Setup > Generic Tests), instead of all Generic Tests from Price List.

Bug-626 on Soil Test forms reported 14 Jan 2013 by Rick, fixed by Rick on 15 Jan 2013:
After Bug-625, if one clicks the "Yellow Plus", the program crashes on "System.Data.NoNullAllowedException was unhandled" but there is no indication, in Help or the Internet, of how one "handles" it. (Fixed by fixing Bug-625.)

Bug-625 on Soil Test forms reported 14 Jan 2013 by Rick, fixed by Rick on 15 Jan 2013:
On trying to create a new record via typing into Go To Sample when there is already data in the form added by typing into Go To Sample:
Error in Sub cboSampleGoTo_KeyDown in frmTestSieve - Column 'SampleIX' does not allow nulls.
(Solved by inserting code to check if we are on a blank new record –if so, remove it!)

Bug-623 on Max Dry Density report reported 8 Jan 2013 by Lindi, fixed by Rick on 8 Jan 2013:
Searching for sample number (12-02921) and then the job number (248) on MODs or Columnar Report:
Program Error in Sub form_Shown in frmReports - Report Type "ViewSample" on Search Type "Samples" has not been programmed for!
Please report this Program Error to rick@softwareafrica.co.za!
(This bug only occurs if you opened the Sample Registration form just before the search. However if you click OK, close (blank) report, and search again, the problem does not recur. Temporary solution: Just search again. Now fixed properly by removing gTempReportType$)

Security tightened: Changes on the Setup > Company form can now only be saved by the Administrator, though anyone can view.

Version 3.1.0.10 – 6 January 2013

Beta version of Phase 6, Classifications form, for testing.  The old form has been retained as "Classifications (simpler)", while the new one has been added as "Classifications (rigorous)".  The old one does not do COLTO C-Classifications (stabilized samples), and ignores some COLTO criteria.  The new form makes fewer assumptions for the COLTO Classification, and hence requires more data. It does both G-Classifications (natural samples) and C-Classifications (Stabilised samples).

Version 3.1.0.9 – 6 December 2012

Beta version of Phase 6, ITS (on UCS form) and DCP, for testing.  A new field, pH, was added to the CBR form for use by the expanded COLTO classification.

Bug-618 on MOD Report Search reported 6 Dec 2012 by Rick, fixed by Rick on 6 Dec 2012:
Search with JobID. "Error in Sub cmdOK_Click: No value given for one or more required parameters."
"…WHERE Jobs.BatchID IN (278,279) AND JobType=2"

Bug-617 on MOD Report Search reported 6 Dec 2012 by Rick, fixed by Rick on 6 Dec 2012:
"Labbie Error in Sub DisplaySoilMOD in frmReports - No value given for one or more required parameters. Getting MOD Report Data - DataAdapter Fill.
"...WHERE Jobs.Projects.ClientIX IN ('LL072') AND Jobs.Projects.ProjectNo=18"

Bug-619 on Soil Reports reported 6 Dec 2012 by Rick, fixed by Rick on 6 Dec 2012:
"Labbie Error in Sub DisplaySoilReports - No value given for one or more required parameters.
"...WHERE Jobs.Projects.ClientIX IN ('LL072') AND Jobs.Projects.ProjectNo=13"

Bug-616 on DCP form reported 6 Dec 2012 by Lindi, fixed by Zinhle on 6 Dec 2012:
When I open DCP this message appears: "Error in Sub form Load in frmTestDCP: Error 5 - C:\Work\Labbie\Labbie.mdb’ is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides". When I click Abort or Ignore it goes to the DCP input form.

Bug-611 on All Reports reported 2 Dec 2012 by Rick, fixed by Zinhle on 6 Dec 2012:
Using the binoculars Search from an open Report, error: Object reference not set to an instance of an object.
(frmReports lacked a Sub LoadData.  Fixed. Search button now works for all reports)

Percent Passing for sieve sizes 2 and 0.425 mm were not showing on Indicator Reports for Sieve and Mech.  Now fixed.

Minor improvements to Verification of Press (Cubes) Report.

Version 3.1.0.8 – 5 December 2012

Beta Version of DCP (Dynamic Cone Penetrometer) form and report, on the Soil Tests and Soil Results menus respectively.

Beta Version of ITS (Indirect Tensile Strength) added to the UCS (Unconfined Compressive Strength) form on the Soil Tests menu, and relevant reports on the Soil Results menu.

All the Test Results forms (Sieve, Mech, Hydro, etc.) now behave differently: They no longer load up all existing data when opened.  Instead they display only a blank record ready for you to enter data.  Start by selecting your sample number from the "Go to Sample No." Combo Box at the top as you have always done.  This list now shows only the samples registered in the last month that do not yet have results on the system.  To find existing results on the database, first open the relevant results form, then click the "Binoculars" button on the toolbar.

Other changes and bug fixes:

Wish-610 on Update Table Structure reported 30 Nov 2012 by Rick, fixed by Rick on 30 Nov 2012:
The message "Log off Other Users to Update Table Struture!" is too restrictive if, for example, one has a database from site where users were logged onto Labbie. Added hidden option to Click 'Retry' four times to Override and Upgrade Anyway, if you are sure no-one else is logged on.  Fixed spelling of "Struture".

Bug-608 on Foundation Indicator Report reported 28 Nov 2012 by Lindi, fixed by Rick on 2 Dec 2012:
Cannot print the reports of project LL1986 (client : Engeolab), Job 278. Only the first three print then there is an error. It seems it is only a problem for this specific job. I tried to skip the problem samples by selecting to print only the pages where there are no error messages – but it didn’t work.
Labbie doesn’t give you an option to select certain samples only – for example if you want to print sample 5 it displays samples 1 to 5 (as with the MODs).
This isn’t actually a problem but if we could select certain samples only maybe we could skip the error samples.
–––––––––––––-
Crystal Report Windows Forms Viewer - on Sample 12-03052
–––––––––––––-
Error in File C:\Users\Rick\AppData\Local\Temp\temp_b10d6dc3-265e-47ea-88fc-31516020b768 {050DBB43-5083-467E-95AD-B7AADB8A96C3}.rpt:
The request could not be submitted for background processing.
––––––––––––-–
(Added New "Samples ONLY" search to find problematic sample. The problem lay with Sample 12-03053’s Atterberg Limits, with the Van der Merwe diagram.)

Bug-609 on Columnar Report reported 20 Nov 2012 by Lindi, fixed by Rick on 29 Nov 2012:
The columnar report's hydrometer "grain size" information is incorrect. A zero needs to be added. For example - it should be 0.003 as in the foundation indicator report and not 0.03 – checked and adjusted accordingly.

Bug-604 on Soil Summary Report reported 4 Nov 2012 by Rick, fixed by Zinhle on 6 Nov 2012:
Vertical lines do not all extend to bottom of Job, just bottom of 1st sample.

Bug-601 on Report form reported 1 Nov 2012 by Zinhle, fixed by Rick on 1 Nov 2012:
The % of soil mortar (<2mm) is displaying one way on the Mech form but then on the report the data under % soil mortar seems to be the % passing of the total sample.
Changed the subheading to “Percent Passing Sieve Size” and not “Percent of Soil Mortar (<2 mm) for Grain Size range” and then changed the row names to the following:
Coarse Sand (0.425 – 2.0 mm)
Coarse-Fine Sand (0.250 – 0.425)
Medium-Fine Sand (0.150 – 0.250)
Fine-Fine Sand 10 (0.075 – 0.150)
Silt and Clay (< 0.075 mm)

Bug-600 on Module reported 26 Oct 2012 by Zinhle, fixed by Zinhle on 1 Nov 2012:
modDatabase, updating the database. Add RefID field in Jobs Table, using values in JobType for the RefID in the Jobs table and replacing the JobType with the true JobType Values

Wish-599 on Max Dry Density reported 25 Oct 2012 by Rick, fixed by Zinhle on 25 Oct 2012:
Loma Lab wants to add the unit of measurement on the graph itself to become True Dry Density (kg/m³).
(Also "Approximate Dry Density (kg/m³)" - RIR 121130)

Wish-598 on CBR reported 25 Oct 2012 by Zinhle, fixed by Zinhle on 25 Oct 2012:
Loma Lab want to change the description from “Hygroscopic Moisture Content” to “Moulding Moisture Content” and check the calculation of the average % moisture.

Bug-597 on Cube Register form reported 11 Oct 2012 by Rick, fixed by Zinhle on 1 Nov 2012:
Toolbar "Binoculars" search button does not work anymore. Fix, and let the form just load the records it needs, rather than loading all records and then filtering (check what happens with the menu item for Search).

Develop-596 on Soil Test forms reported 8 Oct 2012 by Lindi, fixed by Zinhle on 1 Nov 2012:
Max Dry Density takes too long to Save. We need to prefix the MDD (and the other data entry forms) with a search [for samples without results for that test], so that it is not saving all the results but only new (or searched-for) ones, as currently happens with the Sample Register. "Binoculars" search button needs to be activated for Soil and Asphalt test forms. Sample IX combo box must show only items in current search i.e., by default, new results only, and only for samples registered in last month.

Bug-593 on All Forms reported 26 Sep 2012 by Rick, fixed by Zinhle on 3 Oct 2012:
We need successive copies of the each Cube and Asphalt form to retain their screen position and Window State, without interfering with other forms. Like Wish-588, but for non-soil forms. Also identify SampleIX in Title bar (Like Wish-587). DeleteSetting in FormClosed, not FormClosing!
(Not working for Asphalt Binder form, otherwise seem OK. - RIR 04/11/2012 Zinhe has sorted out the Asphalt Binder form)

Develop-592 on Report form reported 26 Sep 2012 by Rick, fixed by Zinhle on 3 Oct 2012:
We need successive copies of the same Report to retain their screen position and Window State, without interfering with other Reports. Like Wish-588, but for reports. DeleteSetting in FormClosed, not FormClosing!

Version 3.1.0.7 – 26 September 2012

Wish-590 on Main Form reported 26 Sep 2012 by Rick, fixed by Rick on 26 Sep 2012:
Labbie should restore the screen state (Restored/Maximized), size and position it had when last closed.
(If Program is not visible on screen, tick the new "Maximize" checkbox on the Login form.)

Serious Bug-587 on Classifications reported 26 Sep 2012 by Lindi, fixed by Rick on 26 Sep 2012:
There is data but the program says there is not: Critical Sieve Analysis Data Missing - Unable to Calculate AASHTO Classification & Group Index! % Passing is zero for 2 mm and/or 0.425 mm and/or 75 micron sieves. (Now using Mechanical Analysis.)

Bug-585 on Print Label from Sample Register reported 25 Sep 2012 by Lindi, fixed by Rick on 26 Sep 2012:
Report Type "ViewSample" on Search Type "JobSample" has not been programmed for!

Bug-588 on Classifications reported 25 Sep 2012 by Rick, fixed by Rick on 26 Sep 2012:
Classification is not using Hydrometer: Extrapolating Grain Size: Unified may be inaccurate - Warning: % Passing for 75 micron (No. 200) sieve is xx (>10%). Grain size for 10% passing will be extrapolated from 425 and 75 micron.
(Now using Hydrometer. Same as Wish-582.)

Wish-582 on Classifications reported 23 Sep 2012 by Rick, fixed by Rick on 26 Sep 2012:
Extrapolating Grain Size: Unified may be inaccurate. Warning: % Passing for 75 micron (No. 200) sieve is 98.2 (>10%). Grain size for 10% passing will be extrapolated from 425 and 75 micron.
If there are Mech or Hydro results, use them if necessary! (Same as Bug-588)

Bug-384 on ShowChildFormNew reported 25 Jan 2010 by Rick, fixed by Zinhle on 25 Sep 2012:
We still need a way of identifying successive copies of the same form and letting them retain their screen position. Mzamo's identification of window via Title bar was ineffective/incomplete. See Bug-383.
20/09/2012 Rick undid Mzamo's shortening of Title in Sub ShowChildFormNew.
23/09/2012 Rick modified Sub SaveWindowState and Sub SetWindowState to remember settings for different copies of same form. Implemented on Sieve form. 25/09/2012: Zinhle Fixed in all Soils forms.

Develop-357 on Soil Test forms reported 24 Jul 2009 by Rick, to fix by Zinhle on 26 Sep 2012:
(split from Bug-331) Sample number should show in title bar of form; keep title short so sample number shows when form is minimized.
Code commented out RIR 17/09/2009: Shows successive sample numbers, and only if chosen from combo.
RIR rejected Mzamo's "fix" of 02/10/2009. Code commented out RIR 17/09/2009: Shows successive sample numbers, and only if chosen from combo. 26/09/2009: Zinhle Fixed in all Soils forms.

Wish-280 on Crushing Diary report reported 29 Apr 2009 by Modise, fixed by Mzamo on 22 Sep 2009:
Need a version of New Crushing Diary report that shows all overdue cubes (should have been crushed before today, and weren't), with all results in order by test-on date and cube ID (search criteria: datedue< today and dayMPa is null)
Done but could be improved by putting on one page: This would require a new report.
(Put on Cube Reports menu at bottom of Crushing Diary reports group: "Cube Crushing Diary - Missed Cubes".)

Version 3.1.0.6 – 24 September 2012

Bug-584 on Projects Form reported 24 Sep 2012 by Rick, fixed by Rick on 24 Sep 2012:
Data changes are not being noticed - fLoading staying True - can't save.  Now fLoading = false after record navigation.

Bug-580 on Hydrometer form reported 20 Sep 2012 by Rick, fixed by Rick on 21 Sep 2012:
We are not interpolating from the user's results to the Standard sizes. Added, with Graph to check results.

Wish-559 on Hydrometer reported 30 Aug 2012 by Lindi, fixed by Rick on 19 Sep 2012:
It will help a great deal if we are able to enter/edit hydrometer results manually without having to enter data. (Same as Wish-572)

Wish-572 on Hydrometer form reported 22 Aug 2012 by Lindi, fixed by Rick on 19 Sep 2012:
Lindi needs to be able to type in Hygroscopic Moisture Content and last 2 columns of grid –and avoid it recalculating. Times must always be entered; this is a required field. Leave Hydrometer Reading and Temperature blank, and it will not recalculate.

Wish-581 on Printing Single Labels reported 6 Sep 2012 by Dinah, fixed by Rick on 22 Sep 2012:
Dinah sometimes needs to print only one extra label for one specific sample. But then it prints all the labels for that job again.
Change options to allow just one label for one sample. (Can now print: Several sets, one set, or one label.)

Minor Bug-578 on Grading Reports reported 17 Sep 2012 by Rick, fixed by Zinhle on 22 Sep 2012:
GM to be rounded off to 2 decimals on Reports (done in Minor Bug-542 but redid as part of moving Grading Modulus from the Sieve table to the Mech table: All reports containing GM had to be altered).

Wish-577 on Soil Report reported 5 Sep 2012 by Bertie, fixed by Zinhle on 19 Sep 2012:
Add Client Ref on the Summary of soil test results: make the Description narrower to fit it in.

Wish-579 on Soil Summary Report reported 5 Sep 2012 by Bertie, fixed by Zinhle on 22 Sep 2012:
The Summary of Soil Test Results “look” as it is now should be adjusted as it is NOT easy to read, the information is cropped and I suggest we should add column lines (vertical & horizontal) as this will ease the process. (Added column lines (vertical) between result groups, also on the Indicator reports.)

Wish-575 on Soil Classifications reported 23 Aug 2012 by Rick, fixed by Rick on 22 Sep 2012:
Rather give a blank result instead of question marks, if classification can not be determined. (Used dashes instead of "??")

Bug-574 on Projects Form reported 22 Aug 2012 by Rick, fixed by Rick on 24 Sep 2012:
Billing tab, Check Dup, second dialog box not working? Also, get it to ignore "Generic" duplicates.
(Got it to ignore "Generic" duplicates, 24/09/2012. Fixed to check for Project Price items with missing/null prices that have Sample Tests, but not for Sample Tests without Project Price items.)

Serious Bug-573 on Price List form reported 22 Aug 2012 by Rick, fixed by Rick on 24 Sep 2012:
Price list changes are not saving! "Update Successful" is not true! Limited to some columns: Combo boxes "Job type" and "Test" columns will not clear once a non-null value has been set. The former does not have "blank" in the list, the latter has but it seems not to work.  Fixed to save nulls.

Bug-569 on Max Dry Density reported 22 Aug 2012 by Rick, fixed by Rick on 19 Sep 2012:
On form and report, Label "Description" should become "Remark" to distinguish from description on sample register details. (Internally it is still MODs.Description)

Bug-568 on Soil Report reported 22 Aug 2012 by Rick, fixed by Zinhle on 19 Sep 2012:
Summary of Soil Test Results: Swel is not shown? E.g. Loma 12-02095/6. It was not in the SQL.  Added.

Serious Bug-567 on Mech Analysis reported 22 Aug 2012 by Rick, fixed by Zinhle on 19 Sep 2012:
Values in the 1st column (Cumulative Mass Retained) change change after Saving or clicking button "Get Sieve Data".
(Last column was linked to Retained values instead of Passing values.)

Bug-557 on Mechanical Analysis reported 30 Aug 2012 by Lindi, fixed by Zinhle on 19 Sep 2012:
When saving on the Mechanical Analysis tab – data changes. Thus incorrect data on the report. As Bug-567.

Wish-566 on Sieve form reported 22 Aug 2012 by Rick, fixed by Zinhle on 20 Sep 2012:
Ideally, along with Wish-565, we want to plot sieve sizes from the Mech Analysis and the Hydrometer Analysis, if they exist. (Done.)

Wish-565 on Sieve form and Mech form reported 22 Aug 2012 by Rick, fixed by Zinhle on 19 Sep 2012:
Can we move the Grading Modulus from the Sieve form to the Mech Analysis form, and remove 0.075 mm from the Sieve form? Also see Wish-566. Nico at Roadlab says (Tue 04/09/2012 11:03) "The suggested change should not cause a problem and can be done".  Done.  Indicator reports, Columnar reports, and Soil Summary Report modified to suit.

Wish-558 on Grading Modulus reported 30 Aug 2012 by Lindi, fixed by Zinhle on 19 Sep 2012:
Can Grading Modulus calculation be moved from Sieve Analysis to Mechanical analysis. As sieve analysis actually only goes to the 0.425 mm sieve. (Re-e-mailed Nico and Linda to ask if OK. OK'd. Same as Wish-565.)

Bug-552 on Classifications reported 6 Aug 2012 by Rick, fixed by Rick on 6 Aug 2012:
Description containing the word 'crush' is not recognised. (Was case-sensitive.)

Bug-520 on Main form reported 26 Oct 2011 by Spha, fixed by Zinhle on 10 Sep 2012:
Clicking close/cancel button on the login form, on second login: "Program Error in Sub frmCbReceive_Load in frmCubeReceive"
Unknown Search Type 2 =''.

Bug-512 on Columnar Report reported 30 Sep 2011 by Rick, fixed by Zinhle on 18 Sep 2012:
Hydrometer Test Results do not show on Report. They should.

Bug-511 on Columnar Report reported 30 Sep 2011 by Rick, fixed by Spha on 7 Oct 2011:
Can not view two columnar reports at the same time. Eg Job 16 on screen; asking for columnar report for job 735 does nothing. Close 16, then 735 works. Also: Blank title bar on report (may be related problem). Done.

Version 3.1.0.5 – 22 August 2012

Develop-531 on Print Labels reported 9 Apr 2012 by Rick, fixed by Rick on 22 Aug 2012:  Improvements to print Sample labels: Arial font, Zebra bar code.

Version 3.1.0.4 – 21 August 2012

Develop-531: Start of Label printing: New menu items – Tools > View Sample Labels, Set Label Printer, No Label Printing, and Number of Copies on Tools menu, plus new Print Labels button on Sample Registration form.

Serious Bug-387 on Open Database reported 20 Apr 2010 by Rick, fixed by Rick along with Bug-530 on 5 Sep 2012:
Civilab can not open MDB file on 64-bit Windows 2008 Server:
Error in Function OpenDatabase on rnodDatabase
Error 3706: Provider cannot be found. It may not be properly installed.
on Ad.Open \\MAINDUDE\Civilab\Labbie\Labbie.mdb
Solution: Run under WOW as 32-bit application.  Setup has been altered to suit.

Bug-511 on Columnar Report reported 30 Sep 2011 by Rick, fixed by Spha on 7 Oct 2011:
Can not view two columnar reports at the same time. E.g. Job 16 on screen; asking for columnar report for job 735 does nothing. Close 16, then 735 works. Also: Blank title bar on report (may be related problem). Done.

Wish-489 on Columnar Report reported 26 Jul 2011 by Rick, fixed by Spha on 7 Oct 2011:
Can Groups be set to not split across pages?  Spha's fix did not work - Redone: OK.

Bug-486 on Columnar Report reported 26 Jul 2011 by Jan-Hendrik, fixed by Spha on 12 Oct 2011:
Asphalt Columnar Report is missing second sample data for jobs 733 & 747. (Currently no data for the samples concerned!)

Bug-453 on Sample Register reported 18 May 2011 by Rick, fixed by Spha on 7 Oct 2011:
Clicked [Duplicate this sample and its tests], got "No Tests to Copy!"
Then (and this is the bug): "Unable to Paste some Tests!"
Done. It now says: "No Tests to Paste! There are no Tests to Paste. Tick the required tests in the list for one Sample, then Click 'Copy Tests' and Paste again. Otherwise just Duplicate a Sample with its tests."

Version 3.1.0.3 – 7 August 2012

Develop-554 on Columnar Report reported 6 Aug 2012 by Rick, fixed by Rick on 7 Aug 2012:
Currently-built-in Soil Test Remarks must become data.  This can now be edited in Setup > Company, on the new third tab "Remarks".

Wish-544 on Columnar Report reported 22 May 2012 by Linda, fixed by Rick on 7 Aug 2012:
Smaller font, to fit on one page (if possible). 8 pt. is acceptable (used 7.25 pt). Same as Wish-553
Wish-553 on Columnar Report reported 3 Aug 2012 by Lindi, fixed by Rick on 7 Aug 2012:
Loma Lab needs a smaller version of the Columnar report, i.e. one using a tiny font so that more will fit on a page, as Roadlab want this too (Wish-544). The new report is found under Soil Reports > Columnar Report (small).

Wish-551 on MOD Report reported 3 Aug 2012 by Lindi, fixed by Rick on 7 Aug 2012:
We need all the registered sample information on the Max Dry Density report – not all of it is currently reflected.

Version 3.1.0.2 – 2 July 2012

Minor Bug-542 on Grading Curves reported 22 May 2012 by Linda, fixed by Rick on 2 Jul 2012:
Grading output: No decimals, GM: 2 decimals on Soil Columnar Report.

Bug-537 on Sieve form reported 22 May 2012 by Linda, no fix by Rick on 29 Jun 2012:
Sieve analysis: 0.075% not recalculating (Unable to duplicate the problem.)

Bug-536 on Clients Form reported 17 Apr 2012 by Leticia, fixed by Rick on 18 Apr 2012:
Error in Sub SaveAll in frmClient - Data can not be Saved!
Cannot perform cascading operation. Since related records exist in table 'CubeBatches', referential integrity rules would be violated.
on Update modified Clients.
Problem arises because the update is trying to update ClientIX, which will never change, but VB seems to be too stupid to notice this.
Fix: In Labbie Database relationships, set Cascade Update ON between Projects and 'CubeBatches' tables.
(Same problem as Bug-528)

Bug-530 on Compile on 64-bit reported 1 Apr 2012 by Rick, fixed by Rick on 24 Jun 2012:
The application platform does not match the existing application on the server. Do you want to overwrite it? Yes (changing from Project > Properties > Compile > Advanced > AnyCPU to x86)
When running Setup:
The deployment identity at the deployment provider is not the same as the original deployment identity.
You changed your target CPU from CPUAny to x86:
You will have to reinstall the application.
(Done to solve Bug-529) But Labbie was not ON the laptop, so can't be uninstalled!
Trick: Run Setup.exe from INSIDE a Zip file –it then does not look on the internet for part of the installation, and installs OK (but the next time it runs it reverts to the internet version).
(Click-once confuses itself by running part of the setup from the web. Uploading the same version cures it.)

Bug-527 on MOD report reported 15 Feb 2012 by Rick, fixed by Rick on 29 Jun 2012:
MOD report can not select by Job number.
On Demo Lab (Roadlab 2011), Running report for JobID = 718: Crystal Report Windows Forms Viewer
The remaining text does not appear to be part of the formula.
The MOD Report is working again.

Bug-479 on Columnar Report reported 26 Jul 2011 by Linda, fixed by Linda on 2 Jul 2012:
ITS (Generic result) is not printing on Soil Columnar Report - Fixed.

Bug-308 on Soil Summary reported 15 Jun 2009 by Linda, fixed already:
Use UCS results if no CBR (Done 2009-12-11 in Sub DisplaySoilReports)

Version 3.1.0.1 - 25 June 2012

Bug-547 on Classifications reported 25 Jun 2012 by Rick, fixed by Rick on 25 Jun 2012:
TRH14 C-Classifications: UCS is in kPa but criteria from spreadsheet are in MPa.

Bug-546 on MOD reported 20 Jun 2012 by Loma Lab, fixed by Rick on 25 Jun 2012:
Remove the list that appears after saving MOD. Gets too long!

Version 3.1.0.0 - 24 June 2012

First Release that will run on 64-bit PCs as well as 32-bit ones. Note that we have gone from the 3.0-series to the 3.1-series.

Added TRH14 C-classifications (new fields: ACV and SandEq) and fixed several bugs:

Bug-483 on Soil Classifications reported 26 Jul 2011 by Linda, fixed by Rick on 24 Jun 2012:
Still need "C" Classifications using UCS (for compacted soil). Only have "G" Classifications at present.

Serious Bug-548 on Setup reported 24 Jun 2012 by Rick, fixed by Rick on 25 Jun 2012:
Difficulty with the installation or if PCs on the internet do not install automatically, if there is an error message similar to this:
Application Cannot be started. Contact the application vendor [OK / Details…]
and if you click Details, one of the messages in the text file that opens, reads:
+ The deployment identity does not match the subscription.
Solution: Uninstall/Remove Labbie first before installing. Done in Control Panel > Add or Remove Programs (Windows XP) or Programs and Features (Windows 7).

Serious Bug-545 on Certificate reported 13 Jun 2012 by Rick, fixed by Rick on 19 Jun 2012:
Trying to release from new Laptop. The project won't publish. It gives the error:
SignTool reported an error 'Key not valid for use in specified state.'.
"This CA Root certificate is not trusted because it is not in the Trusted Root Certification Authorities store. To enable trust, install this certificate in the Trusted Root Certification Authorities store."
To fix, double-click C:\Work\Labbie\Labbie2\LabbieKey3.pfx to import into the Trusted Root Certification Authorities store using the Certificate Import Wizard (See also Bug-218, where the Certificate was created.)

Bug-529 on Open Database on 64-bit reported 1 Apr 2012 by Rick, fixed by Rick on 1 Apr 2012:
Error in Function OpenDatabase on modDatabase
Error 3706: Provider cannot be found. It may not be properly installed.
On Ad.Open P:\Labbie\Labbie 2011.mdb
Choose Retry to Change Provider, currently:
Provider=Microsoft.Jet.OLEDB.4.0
(Same problem with Provider=Microsoft.ACE.OLEDB.12.0)
–––––––––––––-
Solution: There is not a 64 bit version of jet that is why you get that error. To force your app. to use the 32 bit change the target cpu to x86 in the advanced compiler options.

Bug-543 on CBR reported 22 May 2012 by Linda, fixed by Rick on 8 Jun 2012:
CBR Swell: Must be MOD < NRB < Proctor. Roadlab prefers "Final" then "Initial", Lomalab uses "Initial" then "Final": How to suit both? Take Absolute (Nico says swell can never be negative).

Develop-540 on Letterhead reported 22 May 2012 by Nico, fixed by Rick on 8 Jun 2012:
Roadlab needs a new header (with new address), and new footer (without Kaempffer).

Bug-534 on CBR reported 9 Apr 2012 by Rick, fixed by Rick on 9 Apr 2012:
Sequence: MOD -> NRB -> Proctor. Need to swap existing.
MOD density (around 100%) > NRB density > Proctor density (around 90%).
Swell = Final - Initial, not reverse.

Bug-528 on Projects Form reported 7 Mar 2012 by Leticia, fixed by Rick on 18 Apr 2012:
Data can not be saved! The record cannot be deleted or changed because table 'CubeBatches' includes related records
on Running Search: ocon Projects.
[bad error message. Occurs if there are cubes, e.g. for Project=Willows Retirement Village]
After changing error-handling from Try/Catch to On Error:
Error in Sub SaveAll in frmProjects
Data can not be Saved!
The record cannot be deleted or changed because table 'CubeBatches' includes related records.
on ProjectsTableAdapter.Update(modProjects)
Fix: In Labbie Database relationships, set Cascade Update ON between Projects and 'CubeBatches' tables.
(Same problem and fix as Bug-536)

Version 3.0.0.22 - 8 June 2012

Extend the validity of the program.

Version 3.0.0.21 - 1 May 2012

Extend the validity of the program. and address a number of concerns at Loma Lab, notably around the CBR. It also has an improved Help file.

Serious Bug-524 on Crystal Reports Setup reported 2 Feb 2012 by Alrika at Loma Lab: Crystal Reports Setup from the web says CAB file is corrupt. Seems to be sorted out.

Version 3.0.0.20 - 2 April 2012

Extend the validity of the program.

Version 3.0.0.19 - 1 March 2012

Extend the validity of the program.

Serious Bug-522 on Invoice form reported 30 Jan 2012 by Wihan, fixed by Rick on 31 Jan 2012:
We’re having some problem when invoicing with Labbie-it has reached INV1000 and won’t generate INV1001 for subsequent batches, i.e. still reverts to INV1000 for subsequent batches. (He means the CSV numbering, which stops at "LabbieInv1000.csv". Fixed.)

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-513 on Maximum Dry Density Report reported 6 Oct 2011 by Spha, fixed by Spha on 13 Oct 2011:
Searching for job 735. Crystal Report Windows Forms Viewer:
The remaining text does not appear to be part of the formula.
Error in formula: The remaining text does not appear to be part of the formula.

Bug-510 on Columnar Report reported 30 Sep 2011 by Rick, fixed by Spha on 7 Oct 2011: No logos (Done)

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: Getting 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.


| Back to top | ©2015 Communication in Action cc t/a Software Africa. All rights reserved.  Updated 25 September 2015 e-mail Webmaster.