Re: Search by parts of keywords

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

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 07/26/04 

Date: Mon, 26 Jul 2004 11:24:40 +0800

Hi Mike. There are so many things to learn, that this will take you a while,
particularly if you have not used VBA before.

There are some sample databases in this link:
    http://msdn.microsoft.com/library/officedev/bapp2000/mdbdownload.htm
Particularly, solutions.mdb contains a help of examples of how to do various
things. 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mike" <duh@127.0.0.1> wrote in message
news:u9McmUmcEHA.1652@TK2MSFTNGP09.phx.gbl...
> Hi Allen. Thanks for your reply.
>
> Just a bit of background. I've just started using Access, having worked
with
> databases (many) years ago. So getting back into the layout/design part of
> it should pose no problem.
>
> However, scripting is another kettle of fish, as it was very basic in
those
> days - dBase was what I was using then.
>
> Is there any place that I could get a blank database containing the
> scripting part of what I had mentioned ? I have been searching all over
for
> a few weeks without any luck.
>
> Many thanks.
>
> Mike
>
>
> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
> news:OEl0KBkcEHA.2352@TK2MSFTNGP09.phx.gbl...
> The Like operator can search for parts of words.
>
> Simple example:
>     "[MyMemo] Like ""*arch*"""
> where "MyMemo" represents the name of your memo field.
>
> For the example you gave, you would need to generate a string like this
and
> apply it as the Filter for your form:
>     "([MyMemo] Like ""*arch*"") AND ([MyMemo] Like ""*act*"") AND
([MyMemo]
> Like ""*200*"")"
>
> If the user enters the words into one text box, use the Split() function
to
> parse the words into an array, and loop through the array from LBound to
> UBound to build up the filter string.

Relevant Pages

  • Re: Upgrade Planning - SQL
    ... Mark Mahacek ... > Mike Walsh, Helsinki, Finland ... >>> MSDE database if WSS is installed on the same system to use WMSDE. ... >> than the Sharepoint Configuration and Content databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Comparing table structures between databases
    ... Regards, ... Mike ... > If you have connection to the internet log on to the site ... > two databases? ...
    (microsoft.public.sqlserver.server)
  • Re: External USB Drive for backups
    ... Mike wrote: ... servers running NTbackup? ... I do - but I run a very small system, only two users plus a few databases. ...
    (microsoft.public.windows.server.sbs)
  • RE: Can not open attachments
    ... is it excluded from scanning the databases? ... "Mike" wrote: ... Once rebooted users can ... > open/send attachments. ...
    (microsoft.public.exchange.admin)
  • RE: Converting an Array to values
    ... "Mike H" wrote: ... "Gunti" wrote: ... Function listvalues(key As Integer, Rng As Range) ... Now the list of numbers is in an array. ...
    (microsoft.public.excel.misc)