Anthony Trotter
|
Posted: 05/31/2001, 6:55 AM |
|
I have a field "active" in my users table that I am trying to use in
my search results grid. It is an Access Yes/No field type. In my
search results grid I have made the field hidden, but I cannot get the
"Form Properties / Default Value" to recognize that I want ONLY active
users to appear in the results.
I have tried the following to no avail:
----------------------------------------------
Field Type: number
Default Value: 1
Field Type: number
Default Value: yes
Field Type: text
Default Value: yes
Field Type: text
Default Value: true
----------------------------------------------
Do I need to add a "Before Show" Event or modify the Where clause? If
so, how should I do it? Should I modify my database to an integer
field type with "1" or "2" being the only options?
FYI - my search form is on a seperate page that posts to my results
grid.
I know this is more my ignorance of SQL than CC, so I appreciate your
indulgence.
Thanks in advance.
Anthony
|
|
|
Hellen
|
Posted: 05/31/2001, 8:09 AM |
|
Anthony,
on Grid form go to Form/Properties/SQL tab and set in 'Where' box
active = yes
this criteria will be added to where clause of generated sql statement using
to display grid.
Regards,
CC Support
"Anthony Trotter" <support@worldnetcity.com> wrote in message
news:9f5ig3$87c$1@mail.tankhill.com...
> I have a field "active" in my users table that I am trying to use in
> my search results grid. It is an Access Yes/No field type. In my
> search results grid I have made the field hidden, but I cannot get the
> "Form Properties / Default Value" to recognize that I want ONLY active
> users to appear in the results.
>
> I have tried the following to no avail:
> ----------------------------------------------
> Field Type: number
> Default Value: 1
>
> Field Type: number
> Default Value: yes
>
> Field Type: text
> Default Value: yes
>
> Field Type: text
> Default Value: true
> ----------------------------------------------
>
> Do I need to add a "Before Show" Event or modify the Where clause? If
> so, how should I do it? Should I modify my database to an integer
> field type with "1" or "2" being the only options?
>
> FYI - my search form is on a seperate page that posts to my results
> grid.
>
> I know this is more my ignorance of SQL than CC, so I appreciate your
> indulgence.
>
> Thanks in advance.
>
> Anthony
>
>
>
|
|
|
|