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: 20 Oct 2017 at 1:43pm


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