473,699 Members | 2,413 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Please help with multi-value text box seperated by commas

3 New Member
Greetings.
I am writing a database with a search feature to go through 1 table and extract relavant records to be displayed on a subform in spreadsheet style. I have 8 txt boxes that can all recieve data and search through the table with the search terms AND'd or OR'd together. The table has fields that are the same as the search text boxes ( 'Proj' txtBox --> 'Proj' in the table.)
My problem is that I would like to be able to put multiple values in one of the text boxes seperated by a comma and have those individual values searched. For example, Let's say I have 4 search parameters. I put the value 5286 in the text box called 'Proj', and than 48,256,39 in a text box called 'Sys'. The 5286 value will search the Proj field in my table and display the corresponding records on the subform. How could I treat 48, 256, and 39 seperatly so that I can search the 'Sys' field in the table for these 3 values?

Thank you very much.
Jul 13 '07 #1
2 2233
FishVal
2,653 Recognized Expert Specialist
Greetings.
I am writing a database with a search feature to go through 1 table and extract relavant records to be displayed on a subform in spreadsheet style. I have 8 txt boxes that can all recieve data and search through the table with the search terms AND'd or OR'd together. The table has fields that are the same as the search text boxes ( 'Proj' txtBox --> 'Proj' in the table.)
My problem is that I would like to be able to put multiple values in one of the text boxes seperated by a comma and have those individual values searched. For example, Let's say I have 4 search parameters. I put the value 5286 in the text box called 'Proj', and than 48,256,39 in a text box called 'Sys'. The 5286 value will search the Proj field in my table and display the corresponding records on the subform. How could I treat 48, 256, and 39 seperatly so that I can search the 'Sys' field in the table for these 3 values?

Thank you very much.
You can use VBA function "Split" to get substrings of a string. VBA help on this function is quite clear.

Good luck.
Jul 13 '07 #2
grahama2
3 New Member
Thank you! It worked.
Jul 17 '07 #3

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

Similar topics

4
1304
by: Lloyd Sheen | last post by:
So MS where is the error that is reported on last line, says 1 failed. No indication as to what failed. VS 2003, (reinstalled more times than should have been). ------ Build started: Project: SQLEditor, Configuration: Debug .NET ------ Preparing resources... Updating references... Performing main compilation... Building satellite assemblies...
7
1899
by: Shane | last post by:
Hi, Thanks in advance for the help. I have been to many websites and tried several solutions to my problem, but have fixed part of it. It's time to come humbly to the newsgroups for help :-) By the way, please don't reply just to tell me that my code isn't optimized and that I should use a delimited database rather than a line by line record. If I had my way, I'd do it differently too.
1
2022
by: Chris Uwins | last post by:
Hi there, i know theres a number of ways I can achieve this but want to know the best, (but still quite simple). Up until a year ago I never used Access but have designed a few databases for work. I am working on Access 2000. I have basic SQL/VB skills - and am pretty accomplished at putting the databases together. Anyway...I've created a database to keep track of "Dayworks" we are
36
1643
by: amanayin | last post by:
As i am not at school for c programming can you please tell me if there is anything bad about this program /* EX4-9.C FUNCTION TO CALL OTHER FUNCTIONS */ #include<stdio.h> float div(float a, float b); float multi(float a, float b); void call(void);
20
1597
by: C# Beginner | last post by:
I'm currently creating a database class, which contains a member called Open(). With this method users can open different databases. When a user tries to open a database which happens to be secured with useraccounts (username, password etc), the user should be notifed to login. Now, in my opinion their are 3 ways to cope with situation: 1. Exit the method nicely with an errorcode (eg access denied, specify accountinformation and try...
3
6284
by: rsouza | last post by:
Hi. Recently here in my work we added the following code in the Global.asax file to handled the session expired and redirect users to the home of the site explaining them the occurred (some thing like "Your session has expired, please restart your navigation."). public void Session_Start(Object sender, EventArgs e) { if(Session.IsNewSession && Request.Headers != null &&
0
1554
by: Ling | last post by:
I am using boost.python to wrap C++ function which includes directmusic libraries to simply play the midi, but lots of linkage errors "error LNK2001: unresolved external symbol". I wonder if it is possible to work with DirectX - directmusic libs. Are there any ways to wrap it? *********************compilation errors ************************* msvc.link.dll bin\msvc-7.1\debug\threading-multi\playmusic.pyd bin \msvc-7.1\debu...
2
4138
by: BruceWho | last post by:
I downloaded boost1.35.0 and built it with following command: bjam --toolset=msvc-7.1 --variant=release --threading=multi -- link=shared --with-system stage and it failed to compile, error message is: E:\software\development\boost_1_35_0\boost_1_35_0>bjam -- toolset=msvc-7.1 --variant=release --threading=multi --link=shared --
3
1352
by: shapper | last post by:
Hello, I am working on an ASP.MET MVC Web Application with NET 3.5 in VS 2008. I need to run some extra tasks on this project build so I download MSBuild from http://msbuildtasks.tigris.org/. I installed it but no new project type shows in my VS 2008.
1
1544
by: ITHELP85 | last post by:
Hello I am trying to get a table attribute to calculate the result of 2 attribute in another table. I am using SQL Server 2005. I got another table to do this and it works fine, but the only difference is is that the attributes are in the same table. My code is posted below but it does not Work. I get the message: ------------------------------------------------------------------------- The multi-part identifier...
0
8618
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
9035
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...
0
8885
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7752
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6534
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
5875
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
4376
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4631
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2348
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.