Search string for "all" or "any"

[Wexus6]

I'm trying to automate my search process and can't come up with an all inclusive seach string. So rather then waste more time I thought I'd ask you nice people.
Thanks,
Wes [sig][/sig]

 

[rafe]

Wes,

i'm willing to try & help but i need some more info on the particulars of the search you're trying to do, tables etc.

nothing too elaborate but a little less cryptic

fyi:

select queries can pull up just about anything & you can use them to feed all sorts of objects & all w/o a search string too

also are you using access 2000 or what? [sig][/sig]

 

[Wexus6]

I'm actually doing this in coldfusion for a web page. Previously I've tried to do it in access VBA but couldn't figure it out there either. I tried to use different combinations of wildcards but couldn't find a combination that would work. For example, I would think that "*,!,*"
would search a feild returning all records, but it doesn't seem to work. Since coldfusion uses select statments, the same priciples should apply.
Thanks...
Wes [sig][/sig]

 

[rafe]

i don't know cold fusion.

actually Wes it should be easier than that for access. the trick here is **don't** use a wildcard. so something like the following will fill a list box called docList with ALL records from the document file (provided you set up the listBox to get query input)

Private Sub mySub()
Dim queryStr as String

'pulls ALL records from Documents file getting DocID
'& description fields
queryStr = "SELECT Documents.DocID, Documents.Description
FROM Documents;"

docList.RowSource = queryStr
docList.Requery
End Sub

am i getting warm? [sig][/sig]