More Using MS Access Answers
Question Library
Ask a question about Using MS Access
Volunteer
Experts of the Month
Expert Login
Awards
About Us
Tell friends
Link to Us
Disclaimer
|
| |
|
|
| |
| | | |
About Manish Batola
Expertise
ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions and many more being added every year.
Experience
24 yrs in the Software industry with 18yrs completely dedicated on more than 200 Various Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.
Organizations
Worked in various multinationals catering from Aerospace, Oil & Gas etc.
Education/Credentials
-MSAP (Master in Software & Applications Programming)
-BPRE (Business Process Re-engineering Engineer)
-SQAE (Software Quality Assurance Engineer)
-STIE (Software Testing & Inspection Engineer)
-Project Engineeer (Software Development)
Past/Present Clients
Catered to various clients in the following industries
Oil & Natural Gas (BPM/CRM/Access Development)
Sales / Marketing (CRM)
Automotive (Automobile Dealers)
Indenters (Import/Export)
HealthCare / Hospitals
Hotels 3* & 5*
Restaurants
Construction Cos (Project Billing)
Clubs (Concept Selling)
Shoe-Chains
Solicitors/Lawyers
Call Centers
Aerospace (Preventive Maintenance)
Travel & Tourism
Computer Vendors
Manufacturing
Music Shops
Education
Data Warehousing
| | |
| |
You are here: Experts > Computing/Technology > Business Software > Using MS Access > criteria
Expert: Manish Batola
Date: 9/5/2008
Subject: criteria
Question
I want to find a table entry with two criteria and edit a field at the same entry. For this I use findfirst criteria expression like below:
*******
Criteria = "[HemProNo]=" & Val(Me!Text104)_ And "[AnaSelected] = True"
rsPrint2.FindFirst Criteria
*******
But I encounter the error message "Run-Time Error 13: Type mismatch"
What is the wrong thing in expression
Please help me
Thanks in advance
A. erdinη Yalın
Answer
Hi Erdinc,
The datatype for the underlying field [HemProNo] should be numeric if its a non-aphunumeric value, and secondly the field [Text104] should contain a numeric value if the underlying fields datatype is strictly numeric. You will not be able to search for text on a numeric datatype field.
This is one reasons for your type mismatch error.
Also check what are you referring rsPrint2 <--- what reference ??
Let me know,
Best regards,
Manish Batola.
Add to this Answer
Ask a Question
|
|
