473,499 Members | 1,931 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

search record from data entered in a text box

1 New Member
how do i search a record that i have specified in textbox
Oct 11 '13 #1
1 1291
zmbd
5,501 Recognized Expert Moderator Expert
eddy4:
1) with a parameter based query
2) via VBA by building a valid SQL string using the value from the textbox in the WHERE clause and then opening a recordset based on that string.
3) using VBA, calculated field in a query, and/or a calculated control on a form and DLOOKUP() in the criteria string. In VBA I prefer to build the criteria string first first. The value returned depends on what you want to do with the information.
4) Microsoft has several good tutorials on its website and there are other very good tutorials around the net that will also show you this.
5) Visit Allen Browne's website for some basics.
6) goto the VERY bottom of this page, click on the VBA INSIGHTS sitemap link for tons of other helpful information.
Oct 11 '13 #2

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

Similar topics

1
1773
by: Mojca | last post by:
I have a problem with a report of data entered on the current day. Data are enter in a continous form. In this form I have field named Current_date_entered_data – text box which has default value...
1
2647
by: Methven | last post by:
File - Get External Data - Import - Text Type - Advanced - Specs PROBLEM Can anyone assist me with a problem ? When attempting to specify an import specification using ; File - Get External...
1
4831
by: jrs_14618 | last post by:
Hello All, This post is essentially a reply a previous post/thread here on this mailing.database.myodbc group titled: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode I was...
1
1345
by: gazelle04 | last post by:
I have a rich text box control on a form and I wanted to make a print out of the data entered on thet field. I tried the normal format for the report using text boxes but I can't see the data. I also...
4
3983
by: Steven | last post by:
Hi, Would need some thought about using a button of the existing form to search record before deleting it. Any quick help is very appreciated. Steve
2
848
by: mavi | last post by:
user wants to search the data, he enters the the desired data in the text box and clicks the search button, behind the search button the code matches the data enyered in the textbox with the database...
1
2900
by: StinkyDuck | last post by:
Is there a record type in vb.net which is similar to the record data type in delphi? -StinkyDuck
0
1166
by: Tequilaman | last post by:
Hi everybody! I want to search some data string of 3 to 11 characters within a hich number of files. tese files are text files with names that are not .txt but .10F etc. All are in one ffolder,...
1
4699
by: Rohullah | last post by:
hello i am new with oracle form 6i, I want to search record in oracle form6i i am using this code but i dont know it is not working what is the reason....
0
7134
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
7180
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
7225
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...
0
7392
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...
1
4920
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...
0
3101
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1429
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 ...
1
667
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
307
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.