Re: How to create a pop-up search field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You can't really search a database that way. Each search works on one field
at a time. You can write code that will iterate through fields in a table
and check their datatype, then do a search if the datatype is correct. You
could possible iterate through tables as well. Or you could use a form and
predefine which fields and table you wish to search in by checking off
values. In no case will it be like searching Adobe Acrobat which only
searches a single document. That would be similar to searching a single
value in a single record in a memo field.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"reeve13" <reeve13.20fgdz@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:reeve13.20fgdz@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> I have an extremely large database which is in a continuous form format,
> and what I would like to happen is, instead of using the find button
> that would just find a word, I would like to have a pop-up search box
> that would yield actual texts throughout the DB (something like the
> search feature in Adobe Acrobat). In addition, I would like to use the
> "and" or "plus" together to search for additional data if needed.
> Please, unless there is a sample I could download and use in my db,
> please be specific in your instructions since I am new to all this.
>
> Thanks!!
>
>
> --
> reeve13
> ------------------------------------------------------------------------
> reeve13's Profile: http://www.hightechtalks.com/m120
> View this thread: http://www.hightechtalks.com/t2314878
>


.

Relevant Pages

  • Re: ADO.NET performance at deleting records
    ... > to a dataset which corresponds to a table from a MySql database. ... > a certain filter. ... > If I iterate the Rows from the table and check for each one the filter ... > second DataView having as RowFilter the condition for the delete. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Exclusive Access Conflict
    ... it's a simple sql command to populate a listbox on a form. ... "You do not have exclusive access to the database at this time. ... If they have Adobe Acrobat Writer 7.0 installed, ...
    (microsoft.public.access.modulesdaovba)
  • Delphi 2005 dbGo with VCL.Net vs dbGo with VCL.Win32
    ... top N rows of a very large database table and then iterate throught the ... the current implementation of dbGo in VCL.Net is unusably slow ... for buffers and copying of data back and forth between the DataSet buffers ...
    (borland.public.delphi.database.ado)
  • Re: Corruped data
    ... The database is splt with a front end on each desktop. ... >> corruption are both generally manifestations of the same reason, ... >> Free Access downloads ...
    (microsoft.public.access.forms)
  • Re: Help Text in Forms
    ... You might check out David Liske's Help website: ... Microsoft Access ... Free Access downloads ... I'd like to add in a database a simple help tool. ...
    (microsoft.public.access.forms)