473,698 Members | 2,643 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Filter a query, based on multiple lines of text entered into a text box.

9 New Member
I am virtually new to access, I'm creating something to help the business through a project.

I have a table and queries containing thousands of products. I want to be able to apply a filter against the product numbers, using multiple products entered into a text box.

So I want a form, with a text box, where a user could paste in 20 product numbers & the query reads those products and filters to just the records that the user has pasted in. I was going to do this through a simple form.

I can get as far as filtering on one product using a text box, but not when the text box has more than one product in it.

Does anyone have a link to a similar problem and solution? I have trawled the internet but not had a lot of joy finding anything simple enough that I understand it.
Oct 24 '16 #1
1 924
PhilOfWalton
1,430 Recognized Expert Top Contributor
See if

https://bytes.com/topic/access/answe...h-single-field

Is of any help

Phil
Oct 24 '16 #2

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

Similar topics

1
2785
by: Matthew | last post by:
I have a form with fields that act as user specified criteria for a form. Two of the fields are start and finish date. The fields in my query are "ID", "TimeStart", "TimeEnd", etc. Currently, I have the following: Between !! And !! Currently, the user will specify the start and finish date, and the query will find data where both TimeStart and TimeEnd fall between that date. However, I want the user to be able to specify, with a
4
8872
by: tshad | last post by:
I have a textbox that I am storing as text (or as a varChar). The field has multiple lines in it (not wrapped). When I read it back into a multiline textbox, it works fine. But when I read it back into a label, it shows all lines together. Is there a way to get the Label to display the lines separately? I could use textbox and get rid of the border and set enable to false, but then it greys the text, which I don't want.
1
3496
by: SomebodyElse | last post by:
Hi. Apologies if this has been asked here before - I've searched & searched but can't find anything. It's probably my serach parameters, but I'm having trouble even describing it to a search engine! I'm sure this is a very simple problem, with straighforward solution. It certainly is in classic asp/ado, but I'm finally learning this .NET business. I like it, but can't get my head around some concepts. Anyway....
4
1418
by: rj | last post by:
Hi All, How do I query based on a value in a text box? eg: "select username, tel, email from users where user_id = userid.text" something like that.. thanx in advance..
3
1437
by: ad | last post by:
I have set a TextBox to MultiLines and set the rows to 10. I assigned the Text of the TextBox some lins of text at desgin time, but only the first line remain in the TextBox. How can I assign some lines of text at desgin time?
3
1364
by: =?Utf-8?B?am9obmFicmFoYW0xMDE=?= | last post by:
hello all, I've already posted a thread with the same problem but couldn't satisfactory answer. Let's come to the point. I can write some text to a text file with WriteAllText method. How can I start new lines? Example, c:\test.txt is a file, then: "This text should be written in 1st line of c:\test.txt" "This text should be written in 2nd line of c:\test.txt"
1
5644
by: BEETHOVEN | last post by:
Is there a way to count how many lines are in a text box on a Access 97 report? I have a report that has a text box and sometimes the box will be 2 lines long and sometimes 3 lines long. I need some other text boxes to adjust depending on how many lines are in the text box. Below is some code I found in this forum but does not work. It does not matter if I use a CR (Carriage return) Chr$(13) or LF (Linefeed) Chr$(10) or both. Dim n...
1
3284
by: Karen D | last post by:
Help Again!! I’m using Access 2003 and I have a form that allows users to enter criteria for selecting tables and queries as well as the query parameters that will be used to generate a report. The report includes some minor but essential statistical information in its summary. One of the parameters I need to allow the user to provide is the maximum number of records to include in the report’s analysis (e.g., should the report include 30, 45,...
5
3712
by: Sandy1992 | last post by:
Hi friends, I am using A2010. I have completed preparing the whole application but stuck with reports. what I want to do: There is 1 command button and 1 textbox/combobox(happy if works with any of the control) . When I type employeeId(which is numeric) in that control and click on command button, it should filter the query and display the result in report. It sounds easy , but not for me. I tried lots of ways to get it done. But from...
0
8683
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8611
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9031
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8904
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6531
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5867
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4624
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3052
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2341
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.