473,396 Members | 2,037 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Can't Search data from table

101 100+
Hi,
My project is in MS Access.
In that I have one Form(Search) which I am using for Search data in my Table(PRODUCTION).
Now in this form I have one Combobox(PalletNo) and one button(Search)
When I select an item from combobox and click on Search button then it will generate report based on search criteria.
In my combobox items are like
PFI
LPL
LPL/AVON
LPL/EL
LPL/PFI
VIC
ZERTH
etc
Now when I select anything except LPP/PFI
then it will shoe me result whatever I nedd.
But when I select LPL/PFI then it will show me error that Data Tyoe Mismatch in Criteria Expression.
Only for perticular item it shows me Error.
Even I check Table also but there is no such problem in it also.
I think there is /P in LPL/PFI so may be because of that it will show error.Or is there any other problem?
I am using this code on click event of Search Button

Private Sub Search1_Click()
On Error GoTo Err_Search1_Click

Dim stDocName As String

stDocName = "PRODUCTION1"
DoCmd.OpenReport stDocName, acViewPreview, , "PRODUCTION.CustomerCode = '" & Me!CustomerCode_Combo1 & "'"

Exit_Search1_Click:
Exit Sub

Err_Search1_Click:
MsgBox Err.Description
Resume Exit_Search1_Click

End Sub

Plz Help Me.
Thanks.
Dec 18 '07 #1
1 1424
billa856
101 100+
I got the answer so no reply plz.
Dec 19 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: nydefender | last post by:
I have one table with 300,000 records and 30 columns. For example columns are ID, COMPANY, PhONE, NOTES ... ID - nvarchar lenth-9 COMPANY - nvarchar lenth-30 NOTES - nvarchar length-250 Select...
1
by: Andy | last post by:
Say given the linearizer table and the key as tbl = {1, 10, 12, 25, 35, 47}; KEY = 1 Can Binary Search be used to find the enclosing segments? In this case KEY is enclosed by the segments 1 and...
11
by: Ron L | last post by:
I have a data table that lists a series of items in my database. In my user form, I want the user to be able to filter by a number of criteria (e.g. location, contract, date modified, etc). Other...
12
by: Divick | last post by:
Hi all, does any one know of any data structure in which I can search the key and value equally fast? Though I could use hashes, but I can only search in constant time on key but not on value. If...
4
by: sharadksh | last post by:
Can anyone let me know the aggorthim to seach a table by any of it's fields. All the fields are of different types. Plz Help me..
5
by: Mark | last post by:
Hi - I've a data table that I want to save to an external Access database. I'm interested in sample code that would perform this save. Thanks, Mark (VB.NET, .Net framework 1.0)
4
by: ManningFan | last post by:
Let's see if I can ask this without confusing you or myself. I need to be able to type a tablename into a box, and search my entire database to see which queries are using that table. Is this...
1
by: jane2007 | last post by:
Hello, Here is my current code ... Dim rstStk As Recordset Set rstStk = CurrentDb.OpenRecordset("Select * from stk where PartNum = '" & strPrt & "'") The problem with this code is that i...
7
by: sathyashrayan | last post by:
Dear group, A mysql wrapper class, which just uses the CRUD operations for large scale php development. Is the same advisable for the mysql stored procedure? Following is a link I got from...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.