Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 4th, 2006, 12:19 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default Running a Query

Hi friends ,


  Is this possible for me..? , In a Ms DB i want to create a query for an table the table contain series of Name in an order . what i want to do is creating a query to run it as when i give an single value the query should take the data from the table using the value. (the value may be an Alphabet or any special characters)..
pls give me an solution for this probs..

bye,
pap
 
Old May 4th, 2006, 06:58 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

How are you entering the single value?

There are several ways of doing this. The critical information is that the query Criteria is

Like [Please enter the first letters of the last name] & "*"

For example. This criteria will run an input box with the title in brackets, then take the letter(s) entered and show you all the records (LastName) that START with the letter(s) entered.

If you want to search for a string anywhere in the text, use

Like "*" & [Please enter the first letters of the last name] & "*"

There are other ways to get the search criteria, like a combo box or text box.

In one version of this I have the underlying query display some fields of the search results in a continous form, and there is a button on the form to open the complete record, or a transaction form from the continous form.

What do you want to do?

HTH

mmcdonal
 
Old May 4th, 2006, 07:00 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Sorry, the second line of criteria should have been:

Like "*" & [Please enter any letters in the last name] & "*"


mmcdonal
 
Old May 5th, 2006, 12:16 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

Hi Mc,

  Thanks for ur reply i got the query running nice..

 Bye,
pap
-----------------------------------
If "What is truth"? the question be,
It is to speak out evil-free. 1.3.6.291(Thirukural)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Running an Access Query from ASP arholly Access ASP 0 January 25th, 2008 03:31 PM
Running query... Question... RinoDM SQL Server 2000 2 July 26th, 2007 08:49 AM
running out of field in query building yixchen Access 2 December 19th, 2005 10:19 AM
Running a query Dwizz VB.NET 2002/2003 Basics 23 May 4th, 2005 11:21 PM
Running an SQL query in VBA... Augusta Access VBA 3 December 1st, 2004 05:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.