Print Page | Close Window

Form_Search.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=101
Printed Date: 29 Mar 2024 at 1:58am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Form_Search.mdb
Posted By: A.D. Tejpal
Subject: Form_Search.mdb
Date Posted: 08 Jul 2008 at 11:08pm
This sample db demonstrates search results with following interpretations of 
values entered in unbound cascaded combo boxes:            
        (a) " ALL" 
            No filter for the field in question.
        (b) Some specific value
            Show all records where the field in question has exact match for this value.
        (c) Some specific value having Wild card prefix and / or suffix.
            Show all records after applying Like operator with wild cards, for finding 
            matches with the field in question.

The results are displayed in a subform and get updated as soon as a new value is
 entered in any of the combo boxes.

It takes advantage of the fact that the outcome of Like operator without wild cards 
is equivalent to that of = operator.

When making a direct entry in the combo box (by typing), if the previous existing 
value happens to be " ALL", make sure to overwrite the complete contents, 
including the space prefix.

Download Access XP (A2K format): http://www.rogersaccesslibrary.com/forum/uploads/37/Form_Search.zip - uploads/37/Form_Search.zip



-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net