473,382 Members | 1,424 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,382 software developers and data experts.

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

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 911
PhilOfWalton
1,430 Expert 1GB
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
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...
4
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...
1
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...
4
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
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...
3
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...
1
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...
1
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...
5
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

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.