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.
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.
Sign in to post your reply or Sign up for a free account.
Similar topics |
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...
|
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.
|
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
|
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);
|
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...
| |
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 &&
|
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...
|
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 --
|
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.
|
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...
|
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,...
| |
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...
|
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...
|
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...
|
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...
|
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();...
|
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...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |