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 January 20th, 2006, 06:14 PM
Authorized User
 
Join Date: Jan 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default HELP! FIXING MY QUERY

First of all I have only two weeks of experience running MS Access so this is all new to me.

I'm using a form to enter in search criteria. I'm using an option group to select the type of search. Option 1 has 3 text boxes to enter in criteria for my query. I've added 2 more text boxes which each has its own option group to select what criteria you want in those txtboxes. before I added the 2 txtboxes the query ran fine. With the new txtboxes I cant get the original txtboxes to filter properly. the new txtboxes seem to be filtering properly. In my query under each 5 fields my criteria is simply:

[Forms]![Fsearch]![txtQtr2]or [Forms]![Fsearch]![txtQtr2]is null

of course each criteria refers to the appropriate txtbox.

Is my criteria wrong? Do I have too many? Do I need a different expression? I would like to use the new txtboxes no matter what option group I select.

any help will be greatly appreciated!!


 
Old January 21st, 2006, 02:46 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

I think u want to select the data for searching through an front end by using an combo Box or by text box (or) directlly by running the query . Right on that ? ..
Then u have to use the table for creating the query and use "Like[Forms]![Fsearch]" in criteria
through Expression builder

If ur an Front end user then following commands.,ill be
Enter to specified front end (i.e.Formview -FSearch)- Then go to design view ,Properties , Data tab ,give data entry "yes".
         This may be help full for u , But i am able to understand ur concept marginally.

Anyway try the above said concept..

bye,

P.A.P.Raguv
 
Old January 21st, 2006, 03:24 AM
Friend of Wrox
 
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try this:

[Forms]![Fsearch]![txtQtr2] or Is Null

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Fixing An Overbloated MDB - HELP!! dpm39560 Access 4 October 14th, 2014 05:59 AM
Urgent...need help fixing this error! riki_gill ASP.NET 1.x and 2.0 Application Design 0 October 27th, 2006 08:23 AM
fixing the 'headers already sent' warning/error ire BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 1 August 21st, 2006 07:35 AM
Fixing header, and first column of table. rupen CSS Cascading Style Sheets 5 October 21st, 2005 08:33 AM
Fixing Header & Footer shazia1 CSS Cascading Style Sheets 3 July 4th, 2005 12:22 AM





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