Specific data search

[John]

Hi
I would like to be able to search out specific data from my Table using a
select query. A sample of the Table data is shown below. All fields in the
table are formatted as Text.

Order | Description
-------------------------------------------------------------
0001 | PEAK 2GB MINI SECURE DIGITAL MLC
-------------------------------------------------------------
0002 | SAMSUNG HD IDE 80GB UDMA 100 7200
-------------------------------------------------------------
0003 | XVISION 256MB GEF 7600GS DVI AGP

I need to be able to search for all entries containing specific keywords.
i.e. "7600GS"
There are 1,000s of entries like these and I would like the filtered data
displayed in a subform.
Would it be possible to have a Text Box on a form and enter the search text
"7600GS" hit a Command Button and have the filtered list produced in a
subform?

I may be asking too much here guys, but please try your best, as always.

Kind Regards

John

 

[John]

Duane,
Sorry for the delay but got held up on a job.
As usual your comments are helpful and most welcome.

Kind regards

John

I would add a command button to apply your filter to the subform. The code
would be something like:

Dim strSQL as String
strWhere = "1=1 "
If Not IsNull(Me.txtFind) Then
strWhere = strWhere & " And [Description] Like ""*" & Me.txtFind &
"*"""
End If
' possible other filtering
Me.sfrmMySubform.Form.Filter = strWhere
Me.sfrmMySubform.Form.FilterOn = True

--
Duane Hookom
Microsoft Access MVP

Hi
I would like to be able to search out specific data from my Table using a
select query. A sample of the Table data is shown below. All fields in
the
table are formatted as Text.

Order | Description
-------------------------------------------------------------
0001 | PEAK 2GB MINI SECURE DIGITAL MLC
-------------------------------------------------------------
0002 | SAMSUNG HD IDE 80GB UDMA 100 7200
-------------------------------------------------------------
0003 | XVISION 256MB GEF 7600GS DVI AGP

I need to be able to search for all entries containing specific keywords.
i.e. "7600GS"
There are 1,000s of entries like these and I would like the filtered data
displayed in a subform.
Would it be possible to have a Text Box on a form and enter the search
text
"7600GS" hit a Command Button and have the filtered list produced in a
subform?

I may be asking too much here guys, but please try your best, as always.

Kind Regards

John