Have a Question?
-
FAQs
-
- Creating a New Excel Template Message Style in LIMS Messaging
- Timed Shutdown of LIMS Messaging
- Clearing Messaging’s Queue
- Updating Messaging v6 ODBC Driver and Database Connection
- Configuring A New Profile For Messaging
- LIMS Messaging: Clicking Start Causes The Application To Close
- Messaging and New Outlook
-
- Advanced Sample Queries Using SQL
- Finding Samples Missing Analysis Costs Using SQL
- Simplify Queries with SQL Expressions
- Using Wildcard Pattern Matching in Queries
- SQL for Unique Queries
- Error: Unable to open database [LIMSdatabaseName] on [ServerName] via [ODBC Driver Name/Server Native Client] for SQL Server
- Querying the Most Recent N Samples
- Query by Sample Status
- Query Unapproved Samples
- Query Multiple Sample Batches
- How to Query Completed, Unreported, and Unapproved Batches
- Work Load Report
- Investigating Analysis Use
- Updated LIMS Data Query Workbook Now Available
- SQL Expression for Today’s Samples
- Automated Backups with SQL Server Express
- Error: "Cannot Connect To SQL Server" When Trying To Connect Other Workstations
- Error: "Microsoft Excel Is Waiting For LIMS To Complete An OLE Action"
- Creating Scheduled Backups Using SQL Server Express
- Creating A Backup Of Your LIMS SQL Database
- LIMS Upgrade Task Checklist
- Troubleshooting SQL Server Connection Errors
- Connect To SQL Server When System Administrators Are Locked Out
- Show All Articles (8) Collapse Articles
-
- Error: "Undefined function 'Replace$' in expression" when Importing from Excel
- Error: Unable to Attach LIMSDATA.MDB or its Location May Have Changed
- Issue: LIMS VBA Project is Not Fully Compiled
- Creating an LIMS 4.x Edit LimsCode Shortcut
- Installing LIMS under Citrix or Remote Desktop Services
- Creating an LIMS 3.x Edit LimsCode Shortcut
- Moving LIMSDATA to a New Location
- Creating a Development Version of LIMSCODE
- Optimizing Microsoft Access Performance
- Using Barcodes With Other Windows Applications
- Using a Read-Only Version of LIMSDATA
-
- Use a Text List to Enter Special Symbols
- Simplify Queries with SQL Expressions
- Using Wildcard Pattern Matching in Queries
- SQL for Unique Queries
- Copy Only Subtotals in Excel
- Quick Data Analysis with Excel
- Use a Dynamic Batch to Speed Login
- Adding a Label Number to labels
- Understanding the Hyperlink Base
- Inactive Items in Pick Lists
- Splitting One Sample Batch into Two
- Compact LimsData Regularly to Improve Performance
- Sending Preliminary Reports with Messaging
- Use a Project to Save Control Chart Lines
- Prevent Samplers and Technicians from Adding or Editing Locations
- Use Analytes to Bill for Services
- Understanding Analysis Specifications
- Values Imported from Excel
- Configuring Instrument Methods
- Create Excel Templates by Copying Other Templates
- Using Customer Sample Login Options
- Verify Your Version 4.0 Setup Folder
- Using the Record Navigation Search Field
- How to Move LimsData to a New Folder
- Creating Electronic Data Deliverables from a Report Template
- Find Projects with a Specific Analyte
- Delete or Inactivate a Customer
- Query Unapproved Samples
- Using the Zoom Window
- Sample Approval by Specific Users
- Keyboard Shortcuts Are Your Friend
- LIMS Users May Benefit from Thin Client Computing
- Date and Time Analyses
- Refine Queries by Selecting Samples
- Adding New Analyses in Specific Order
- Organizing Analyses
- Project vs. Analysis Costs
- Database Size Metrics
- Sample Documents
- Understanding Analysis Costs
- Clean Up your Error Log
- How Large is your Database?
- Adding or Deleting an Analysis from all Batch Samples
- Logging One-Time Customers
- Add Samples to an Existing Batch
- Query Multiple Sample Batches
- How Reliable are your Backups?
- Compact Routinely
- Result Value Formatting for Custom Numbers
- How to Use Location-Specific Analyses
- Database Maintenance and Performance
- Speed Data Entry with Text Lists
- Use the Ditto Keyboard Shortcut
- Integrating LIMS and ERP Systems
- How to Use Default Sample Descriptions
- Entering Results with Scientific Notation
- Sample Schedules
- Linking a Document to a Sample
- Custom Bar Code Not Printing
- Computer Configurations When No Domain Active Directory Present
- Analysis Values "H", "L", and "BDL"
- Creating Scheduled Backups Using SQL Server Express
- Creating A Backup Of Your LIMS SQL Database
- Configuring A New Profile For Messaging
- LIMS Upgrade Task Checklist
- Using Windows Authentication to Connect to SQL Server from Outside the Domain
- Error: "Unable to open database" Troubleshooting Guide
- Removing Users From LIMS
- Pinning J Street LIMS To Your Taskbar
- Installing J Street LIMS v6.0.1.7+ For Remote Desktop Use
- Deleting Samples
- Editing Sample Data on Sample Login Screen
- How To Copy Pop-Up Screen Data To Excel
- Update License Key - v6
- Minimum Reporting Limit Information
- Adding Start Date/Time and End Date/Time of the Analysis
- Adding "Chain of Custody" Field
- Including EPA Hazardous Waste Codes on Reports
- Connect To SQL Server When System Administrators Are Locked Out
- Show All Articles (64) Collapse Articles
- Use a Text List to Enter Special Symbols
- Error: "Undefined function 'Replace$' in expression" when Importing from Excel
- Error: Unable to Attach LIMSDATA.MDB or its Location May Have Changed
- Issue: LIMS VBA Project is Not Fully Compiled
- Creating an LIMS 4.x Edit LimsCode Shortcut
- Installing LIMS under Citrix or Remote Desktop Services
- Creating an LIMS 3.x Edit LimsCode Shortcut
- Moving LIMSDATA to a New Location
- Creating a Development Version of LIMSCODE
- Optimizing Microsoft Access Performance
- Using Barcodes With Other Windows Applications
- Using a Read-Only Version of LIMSDATA
- Advanced Sample Queries Using SQL
- Finding Samples Missing Analysis Costs Using SQL
- Reducing Lock Conflicts With NetWare
- Reducing Multiuser Database Lock Conflicts
- Creating a New Excel Template Message Style in LIMS Messaging
- Timed Shutdown of LIMS Messaging
- Ctrl-; (semicolon) Keyboard Shortcut Does Not Work in Date Fields
- Entering Dates Using Keyboard Shortcuts
- Populating Sample Pick Lists
- Results by Analyte Display Column
- Result High and Low Warning Flags
- Add an Analysis to Many Projects
- Graph a Single Analyte
- Internal Data Analytes
- Reporting Specific Analytes for Multiple Samples
- When to First Archive Your LIMS Database
- Results by Analyte ‘Display’ Field
- Sampler vs. Employee
- Compact LimsData without LIMS
- Emailing Preliminary Results
- Using Barcode Hardware
- Conclusions Field Character Limit
- Report Results to more Decimal Places
- Synchronize Workstation Configuration Settings
- Incomplete Analyses Organized by Analyst
- Can We Rename The LIMS Database?
- Analysis Values "H", "L", and "BDL"
- Creating Scheduled Backups Using SQL Server Express
- Creating A Backup Of Your LIMS SQL Database
- Error: "Unable to open database" Troubleshooting Guide
- Update License Key - v6
- Minimum Reporting Limit Information
- Adding Start Date/Time and End Date/Time of the Analysis
- Adding "Chain of Custody" Field
- Including EPA Hazardous Waste Codes on Reports
- Troubleshooting SQL Server Connection Errors
- Show All Articles (33) Collapse Articles
-
Error Messages
- Error: "Undefined function 'Replace$' in expression" when Importing from Excel
- Error: Unable to Attach LIMSDATA.MDB or its Location May Have Changed
- Error: "Error running LIMSDATA .AfterTransferFromLIMS procedure in template… Type mismatch"
- Error: "in LoadWorkstation Configuration"
- Error: "The expression you entered has a function name that microsoft access can't find..."
- Error: Unable to open database [LIMSdatabaseName] on [ServerName] via [ODBC Driver Name/Server Native Client] for SQL Server
- Error: "The database cannot be opened because the VBA project…"
- Error: New User Login Account Fails
- LimsCode Size Warning
- Error with a Period in Messaging Attachment File Name
- Error in GetCurrentUsers: Unrecognized database format
- Unwanted MIN and MAX Warnings
- View Current Users Fails
- Messaging’s Email Subjects
- Understanding the LimsCode Size Warning
- Startup Errors
- Error: in CopyRecordsetToWorksheet
- Error in FrmSetupUsers.Form_Open
- Error Querying Samples: "DateTime2"
- Error: "Date And Time Entered Is Earlier Than The Sample's Collected Date And Time"
- Error: "A Runtime Error Has Occurred. "Contact Your LIMS AdministratorError: LoadWorkstationConfiguration"
- Error: "ErrorRunning LIMSDATA.AfterTransferFromLIMS"...
- Error: "Cannot Connect To SQL Server" When Trying To Connect Other Workstations
- Error: "Microsoft Excel Is Waiting For LIMS To Complete An OLE Action"
- LIMS Messaging: Clicking Start Causes The Application To Close
- Users Missing From Admin>User Screen in LIMS
- Error: "Unable to open database" Troubleshooting Guide
- Pinning J Street LIMS To Your Taskbar
- Error in SigDigits in Excel Data Import
- Error: "BeforeTransferFromLIMS function either is not there, or cannot execute"
- Error: "Automatic Configuration of the Current Version of Microsoft Access Has Failed. Your Database Might Not Function..."
- Error: FrmSampleDeleteSetup.cmdDelete_Click
- Show All Articles (17) Collapse Articles
-
Troubleshooting
- Error: "Undefined function 'Replace$' in expression" when Importing from Excel
- Error: Unable to Attach LIMSDATA.MDB or its Location May Have Changed
- Issue: LIMS VBA Project is Not Fully Compiled
- Issue: Excel Cell Formats Change After Copying Data From LIMSData Worksheet
- Incomplete Samples with All Results
- Who Deleted Samples and When
- Results by Analyte Display Column
- Results Entry Inserting Login Name Instead of Initials
- Understanding the LimsCode Size Warning
- Troubleshoot Network Problems with a Local LimsData
- Cannot Log In After New Workstation Install
- Error: "Cannot Connect To SQL Server" When Trying To Connect Other Workstations
- Computer Configurations When No Domain Active Directory Present
- Issue: Receiving Flagged Results After Changing Analysis Specs
- Analysis Values "H", "L", and "BDL"
- Creating A Backup Of Your LIMS SQL Database
- Users Missing From Admin>User Screen in LIMS
- Using Windows Authentication to Connect to SQL Server from Outside the Domain
- Error: "Unable to open database" Troubleshooting Guide
- Error in SigDigits in Excel Data Import
- Error: "BeforeTransferFromLIMS function either is not there, or cannot execute"
- Error: "Automatic Configuration of the Current Version of Microsoft Access Has Failed. Your Database Might Not Function..."
- Troubleshooting SQL Server Connection Errors
- Show All Articles (8) Collapse Articles
-
User Defined Reports
- Developing and Testing a UDR Without Requerying Data
- Hiding a UDR Column
- Issue: UDR Summary Statistics Do Not Work On Columns With Expressions
- UDR Formula and Expression Dependency Rules
- Create an Invoice Summary Report
- Save LIMS Reports to PDF Files
- Automated Final Report Footnotes in Excel
- Calculate Sample Turnaround with a UDR
- Sample Turnaroun
- Adding Start Date/Time and End Date/Time of the Analysis
-
File Library
-
Downloads & Documentation Library
-
- LIMS Installation Guide v6
- LIMS User Guide v6
- Computer Configurations When No Domain Active Directory Present
- Downloads
- LIMS Release Notes v6
- LIMS Programmer's Guide v6
- LIMS Messaging Guide v6
- INSTALLING J STREET LIMS v6 ON YOUR WORKSTATIONS - Step By Step Guide
- Updating Messaging v6 ODBC Driver and Database Connection
- LIMS Upgrade Task Checklist
- Instructions for Updating Custom LIMS Excel Templates
- J Street LIMS v6 System Requirements Addendum
- Using Windows Authentication to Connect to SQL Server from Outside the Domain
- Error: "Unable to open database" Troubleshooting Guide
- J Street LIMS v6.0.1.7 Changelog
- Installing J Street LIMS v6.0.1.7+ For Remote Desktop Use
- Update License Key - v6
- Show All Articles (2) Collapse Articles
- LIMS Annual Maintenance & Support Policy
- Add LIMS Analyses
- Add LIMS Customers
- CofA Example by Requirement
- View Index Fragmentation
- Downloads
- Computer Configurations When No Domain Active Directory Present
- INSTALLING J STREET LIMS v6 ON YOUR WORKSTATIONS - Step By Step Guide
- LIMS Upgrade Task Checklist
- Instructions for Updating Custom LIMS Excel Templates
- Error: "Unable to open database" Troubleshooting Guide
- Updating Messaging v6 ODBC Driver and Database Connection
-
-
Bench Sheets
-
QuickBooks
-
Excel Interface
- Issue: Excel Cell Formats Change After Copying Data From LIMSData Worksheet
- Interface BAX Instrument with LIMS Software
- How to Display Sample Characteristics in an Import by Sample Template
- How to Read the Contents of a LIMS Report Control from Excel
- How to Remove a Template's LIMS Infrastructure
- How to Use Customer and Outside Lab Lists in a MS Word Mail Merge
- Query Data with the LIMS Data Query Workbook
- Importing formatted analysis results from Excel
- Current Example Excel Export Templates
- Creating a Basic Excel Export Template
- Create Custom Container Labels with Excel
- Values Imported from Excel
- Create Excel Templates by Copying Other Templates
- Using Excel’s Formula Evaluator
- Accessing Excel’s Name Manager
- Significant Figure Rounding in Excel
- Importing Result Types from Excel
- Excel Template’s ‘LIMS Access Version’ Setting
- Date and Time of Results Imported from Excel
- Getting Started with Excel Template Reports
- Improve Excel Reports with Conditional Formatting
- Introduction to LIMS’ Excel VBA Macros
- Creating a Basic Excel Import Template
- Using Date and Time Analyses
- How to Copy and Open an Excel Template
- Export Analysis Results to Excel
- Importing Dates from Excel
- Check your Excel Template’s LIMSAccessVersion
- AnalysisResultFormatted and AnalysisResult Fields in Excel
- Create a Tabular Report with an EDD Template
- How to Debug an Excel Template Macro
- Creating Protected Excel Workbooks
- Round or use Excel’s “Precision as Displayed”
- Changing a Sample Pick List’s Column Contents
- Log Samples from Excel
- Export a Customer List
- How to Evaluate Excel Formulas Incrementally
- Quick Data Export to Excel
- Selecting Excel Template Folders
- Excel Template Report Disclaimers
- Excel Template Folders in Version 5.x
- Showing LIMSData Sheet Data in an Excel Template
- Custom Bar Code Not Printing
- Error in SigDigits in Excel Data Import
- Show All Articles (29) Collapse Articles
-
Labels
-
Table/Field Names
-
Newsletters
- February 2022: Newsletter
- August 2021: Newsletter
- January 2021: Newsletter
- July 2020: Newsletter
- January 2020: Newsletter
- August 2019: Newsletter
- February 2019: Newsletter
- August 2018: Newsletter
- January 2018: Newsletter
- August 2017: Newsletter
- February 2017: Newsletter
- August 2016: Newsletter
- February 2016: Newsletter
- August 2015: Newsletter
- February 2015: Newsletter
- August 2014: Newsletter
- January 2014: Newsletter
- August 2013: Newsletter
- February 2013: Newsletter
- July 2012: Newsletter
- February 2012: Newsletter
- August 2011: Newsletter
- February 2011: Newsletter
- August 2010: Newsletter
- February 2010: Newsletter
- August 2009: Newsletter
- January 2009: Newsletter
- August 2008: Newsletter
- February 2008: Newsletter
- July 2007: Newsletter
- January 2007: Newsletter
- August 2006: Newsletter
- August 2005: Newsletter
- January 2005: Newsletter
- August 2004: Newsletter
- January 2004: Newsletter
- Show All Articles (21) Collapse Articles
-
User Roles
-
Templates
-
ARCHIVE - OLDER VERSIONS
- Editing a Large Group Of Samples After They Are Entered In LIMS
- Installing Existing LIMS v4 On A New Workstation
- Access-to-SQL Server Database Migration Instructions
- Error: The Microsoft Access database engine could not find the object 'MSysDb'
- MSC-LIMS v4 to SQL Server Migration Files.zip
- Updating LIMS 3.x Installation for Windows 7 and Office 2010 Compatibility
- How to Update Template References for LIMS 3.x
- Installing LIMS 2.x on a Machine with Access 2000
- Installing LIMS 2.x on a Machine with Access 2000
- Issue: Missing Logos on Windows 2000 Workstations
Table of Contents
< All Topics
Print
Downloads
Below are a variety of downloads to assist you in maximizing your LIMS system:
| Document | Download File Name & Link | Version | Size | Date |
| LIMS Empty Database | The J Street LIMS empty database “JStreetLimsEmpty.bak” is automatically installed on each computer during the LIMS install. You can find this .bak file in your computer’s “C:\Users\Public\Documents\JStreetLIMS” folder. | v6 | NA | June 2023 |
| Excel Templates | These templates are automatically installed on each computer during the LIMS install. You can find these files in your computer’s “C:\Users\Public\Documents\JStreetLIMS” folder. | v6 | NA | June 2023 |
| J Street LIMS Messaging | An optional component of the J STREET LIMS product. Using messaging, sample information can be sent automatically via email or fax when a sample or sample batch is logged or completed. – Download Now | v6 | August 2023 | |
| PDFCreator prior to 6x versions | PDFCreator has changed how the COM interface works in version 6x, making 6x versions unusable with LIMS Messaging at this time. You will need to use the previous version 3.5.1 (all other versions seem to cause issues as well), which can be found here: https://filehippo.com/download_pdfcreator/history/ Please note that this is not on the PDFCreator site, so use diligence when clicking on links and installing on your system. *Notes on installing: the installer is kinda broken but manageable (Skip updated version || uncheck FF and IE integration || press retry when it fails to download something during install). We are in process of updating Messaging to work with PDFCreator versions 6x, but this will take some time. | |||
| Single-sample Certificate of Analysis example Excel export template that lists analyses grouped by requirement similar to the Sample Summary report. This template works with versions 4.x and 5.x. | CofA Example by Requirement.xltm | v4 – v5 | 53 KB | 18-Jan-21 |
| SQL Server Managment Studio script to view index fragmentation in your LIMS version 5.x database. See also “Database Maintenance and Performance“. | IndexFragmentation.sql | v5 | 2 KB | 12-Jan-21 |
| SQL Server Managment Studio script to rebuild all indexes in your LIMS version 5.x database. See also “Database Maintenance and Performance”. | IndexRebuildAll.sql | v5 | 2 KB | 12-Jan-21 |
| Script to back up version 5.x database. See “Automated Backups with SQL Server Express”. | BackupSQLServerDatabase.cmd | v5 | 2 KB | 30-Jul-20 |
| Example Excel final report template with a sample header preceding each sample’s results (see workbook’s ReadMe sheet for details). | Final Report – N Samples per Page.xlt | v4 – v5 | 81 KB | 08-Aug-17 |
| Example Excel final report template with QC data (see workbook’s ReadMe sheet for details) | Final Report Example with QC.xlt | v4 – v5 | 100 KB | 28-May-15 |
| Excel workbook for general-purpose LIMS data queries (see workbook’s ReadMe sheet for details) | MSC-LIMS Data Query.xls | v4 – v5 | 57 KB | 09-Feb-15 |
| Create custom sample container labels using one of these example templates (see template’s Read Me sheet for details). | Excel Container Label Examples.zip | v4 – v5 | 54 KB | 12-Aug-13 |
| Create custom invoices by exporting data from an LIMS’ invoice report (see template’s Read Me sheet for details). | Invoice Templates.zip | v4 – v5 | 79 KB | 01-Aug-12 |
| VBScript to shut down Messaging (see Timed Shutdown of LIMS Messaging for more information). | ShutdownMessaging.vbs | v4 – v5 | 1 KB | 30-Jan-12 |
| Create your own work sheet and work order reports from one of these examples (see each template’s Read Me sheet for details). | Work Order Work Sheet Templates.zip | v4 – v5 | 63 KB | 29-Jul-10 |
| Create your own electronic data deliverables (EDD) from one of these examples (see each template’s Read Me sheet for details). | EDD Templates.zip | v4 – v5 | 69 KB | 03-Aug-09 |
| Create your own sample login workbooks from one of these examples and log LIMS samples from Excel (see each template’s Settings sheet for details). | Excel Sample Login Examples.zip | v4 – v5 | 52 KB | 30-Jan-09 |
| Create backlog reports by exporting data from the Sample Tracking report (see each template’s ReadMe sheet for details). | Sample Tracking Templates.zip | v4 – v5 | 54 KB | 24-Jul-07 |
| Create your own final reports from these examples (see each template’s ReadMe sheet for details). | Final Report Templates.zip | v4 – v5 | 103 KB | 20-Oct-06 |
| An LIMS import template used to import results from a BAX data file (see template’s ReadMe sheet for details) | MSC-LIMS BAX Data Import.xlt | v4 – v5 | 80 KB | 16-Oct-06 |
| Alter layout, tabular data, statistics, and graph appearance of LIMS control chart reports (see template’s ReadMe sheet for details). | Control Chart Templates.zip | v4 – v5 | 56 KB | 17-Aug-06 |
| A LIMS export template used to create a BAX pre-run file (see template’s ReadMe sheet for details | MSC-LIMS BAX Rack Setup.xlt | v4 – v5 | 135 KB | 17-Feb-05 |
| Create in-house, sent out, internal data, and inactive analyses lists from LIMS’ Analyses report (see template’s ReadMe sheet for details). | MSC-LIMS Analyses.xlt | v4 – v5 | 76 KB | 07-Jan-04 |
| Excel example templates | ExcelExamples.exe | v4 – v5 | 131 KB | 25-Oct-99 |
| System Configuration Options | SysCfg Options | v5 | 49 KB | 15-Sep-04 |
| LIMS Data Query – Excel workbook for general-purpose LIMS data queries | LIMS Data Query article LIMS Data Query Worksheet | v4 – v5 | 74 KB | 09-Feb-15 |
| Petrifilm Data Import | Petrifilm Data Import | v4 – v5 | 54 KB | 18-Jan-23 |
| GetLIMSUsers | GetLIMSUsers | v4 | 48 KB | 18-Jan-23 |
| J Street LIMS v6 Excel Example Templates | J Street LIMS v6 Excel Example Templates | v6 | 2.12 MB | 28-Nov-23 |
Table of Contents