rbaldwin
|
| Posted: 05/14/2002, 5:09 AM |
|
My Access table has 2 fields, Branch number a 5 digit numeric and Branch Name a 40 character string. the Branch number is my Primary key.
I want to be able to search on either field.
I followed the suggestions posted earlier in this forum
Re: AND and OR Operators in Grid & Search
Author CodeCharge Support
Date Created 4/6/01 1:46:58 AM
And i've generated the page with the wizard.
I can only get it to search on my Branch number.
Any suggestions appreciated.
|
|
|
 |
Nicole
|
| Posted: 05/15/2002, 1:42 AM |
|
Hello,
I assume that you have created search form with one textbox and grid form. The most probable reason is incorrect input parameters settings. Check them. Settings for Number field should be like:
Field: Branch_number
Variable Name: Branch_number (check the name to be the same to variable you see in url string when implement search)
Type: Param
Data Type: Number
Operation: =
Setting for Text field:
Field: Branch_name
Variable Name: Branch_number (check the name to be the same to variable you see in url string when implement search)
Type: Param
Data Type: Text
Operation: Like '%...%'
If it won't help please provide more detail how specifically search does not work.
|
|
|
|
rbaldwin
|
| Posted: 05/15/2002, 5:38 AM |
|
Nicole, i've done all that.
Can i email you a zip of my project?
I'm atrbaldwin@yahoo.com
|
|
|
|
Nicole
|
| Posted: 05/15/2002, 6:18 AM |
|
Hi,
You can register on gotocode and upload it to ../UserImages/your_name folder
It let other CC experts download it and help you, not only me.
|
|
|
|
Peter
|
| Posted: 05/15/2002, 1:07 PM |
|
Find the following post, it explains how it is done.
"Re: AND and OR Operators in Grid & Search"
|
|
|
|
rbaldwin
|
| Posted: 05/16/2002, 5:09 AM |
|
Sorry, nicole, i resolved my issue. thanks/.
|
|
|
|
|
