Calculating Page Links Please Wait for Menu Bar to Appear

TQS-9000 - Quality Systems - Quality Database Software - APQP Software - PPAP Software - Gage Calibration Software - FMEA Software - TS16949 Software - QS-9000 Software

Integrated Solution Providers Software, Inc.

Quality System Software & Training Solutions for Any Size Business
Site Map Products/Services  Training Price List Contact Us
TQS-9000 - Quality Systems - Quality Database Software - APQP Software - PPAP Software - Gage Calibration Software - FMEA Software - TS16949 Software - QS-9000 Software

Search the ISP Software, Inc. Web Site:

Now you can purchase a complete quality operating system for only $1,875.00

Below you will find a description of an issue that has recently affected some users. ISP Software has an added a button in the Security and Support Module of the TQS-9000 Program in order to test for this potential conflict. With the release of the update on 01/26/2003 we have changed all the date and page number controls for all reports contained in the program. Initial testing indicates the changes in the latest update should resolve this issue for most users. If you continue to experience this problem after applying the latest update please contact an ISP Software Solution Provider for assistance in resolving your issue.

We apologize for any inconvenience that this issue may have caused. ISP Software, Inc. is working with hard in order to permanently resolve this issue.

Regards,

ISP Software Inc., Support Team

Microsoft Knowledge Base Article - 194374

ACC97: Error Message: Function Isn't Available in Expressions in Query Expression

The information in this article applies to:
  • Microsoft Access 97
  • Microsoft Office 97 Developer Edition
This article was previously published under Q194374
Advanced: Requires expert coding, interoperability, and multi-user skills.
 

SYMPTOMS

When you run a query, you may receive the following error message:
 

Function isn't available in expressions in query expression.

You may see a "#Name" error on forms and reports in controls that use an expression for the Control Source property. This behavior can occur on forms, on queries, or on reports that use built-in functions in expressions, for example, the Format(), Left(), or Right() function.

CAUSE

You developed a database by using a particular version of a type library, and then upgraded the version of the type library on your development computer.

-or-

You referenced a type library on your development computer, and then moved the database to a computer that does not have the library, or has a newer version of the library.

NOTE: This issue often involves references to Comctl32.ocx. But this issue can also occur with other type libraries. An example of installing a newer type library version is installing newer versions of Microsoft Data Access Components (MDAC). Sometimes the upgrade of a type library is subtle, such as when you upgrade the operating system version or install a new application.

 

STATUS

Microsoft has confirmed this to be an issue with Microsoft Access 97.

MORE INFORMATION

When a type library is installed on a computer, specific information about it is placed in the registry. Microsoft Access uses this registry information to reference and use the type library. Under normal conditions, installing a newer version of a type library on a computer has no effect on the programs that use it, but in some cases, changes to the type libraries cause them to be registered differently. When this happens, Microsoft Access cannot use them until the new registry information is refreshed in the References collection.

Request a Demo

 

Request an On-line Demonstration of our Total Quality System 9000 Family of Products

 
View the Total Quality System 9000 Product Overview
View the Total Advanced Quality 9000 Product Overview
 

Downloads

 

TQS-9000 Product Brochure and Price List (Approx. 1.6 mb)

TQS-9000 PowerPoint Demo (Approx. 2.0mb)

Total Advanced Quality 9000 Presentation (Approx. 1.0 mb)

 

Additional Information and Links

 

Now you can purchase a complete quality operating system for only $1,875.00

E-Mail Your Request for Information Regarding Your Price List
 
TQS-9000 Product Brochure and Price List (Approx. 1.6 mb)
E-mail Your Request for Our On-line Training Courses
Special Pricing on Our Gage R&R Software Templates
 
Achieve Six Sigma Quality
Contact Us
 

Training and Support

 

ISP Software, Inc. is a full service supplier with the capabilities to provide complete software and training support for APQP Software, PPAP Software, Gage Control, Corrective Actions, and much more with our Total Quality System 9000 family of products. (Total Quality System 9000) Our ability to also provide on-line and on-site APQP Training, PPAP Training, Advanced FMEA Training, TS16949 Internal Auditor and ISO9001:2000 Training, Six Sigma Training, Gage R&R Training, Document Control Training, and other Workshops gives us the unique ability to be your solution provider of choice. Talk to one of our Solution Providers today to advance your continuous improvements efforts. (Contact Us)                         

ISP Software, Inc. Training Home Page: Training Support

 

Visit the Links Below to Learn More About Our Quality System Database Solutions.

 
TQS-9000 Main Program  TQS-9000 Migration Tool   TQS-9000 Report Viewer

TAQ-9000 Home Page

TGC-9000 Home Page TCA-9000 Home Page

Get to Know Us

Becoming an Associate

Legal Notices

Training

About ISP Software

News and Articles
       

Copyright © 1999 - 2008 / ISP Software, Inc.                                                Email us at: sales@ispsoftware-solutions.com