Search results

Hi I have an Age calculated field. I would like to find either the max or min value for age. I know I have to set the Max() and Min() right? But where do I place these? In the query or in VB? Any help would be appreciated.....

Here it is.....it's in xp...

Hi Mile, I tried out your method and have the following now: Private Sub Reset_Click() Filter = vbNullString List.RowSource = "" End Sub Private Sub Search_Click() If IsNull(Me.Filter) Then MsgBox "You have not entered any Filter Criteria.", vbExclamation, "Title" Exit Sub End If With List...

Jon, How do you go one step further and specify what u want to search for in a earch box after clicking the criterias thru a combo box?

This is the whole thing i have right now..... Private Sub Reset_Click() Filter = vbNullString List.RowSource = "" End Sub Private Sub Search_Click() If Filter = vbNullString Then MsgBox "You have not entered any Filter Criteria.", vbExclamation, "Invalid Search" End If If (1 = True) Then...

Yap...they are checkboxes and there are actually 11 of them bt i pasted the codes for 2 just to illustrate the gist of what i did. My fields are in tha same order as the table and I have ended each part with the "End With", but i'm still getting the same error msg. When u mentioned option...

mile, i would like to check with u abt your example. I was trying to adapt it such that in the form interface i can choose exactly which field i want to search in via a option list, then key in the filter criteria and search. I tried using the If...Then...Else thinggy, is that correct? I typed...

hi mile, 2k will do....thanx again and sorry for the trouble...:p

hey mile, can u email me that file u attached? i can't open it....my email is zekiel@hotmail.com Thanx.....