[AccessD] FW: [U] Soldier in Iraq needs Access Help

Good point.  Hmmm, I wonder if there is a way to do what he wants in Access?



-----Original Message-----
From: Bobby Heid [mailto:bheid at sc.rr.com]
Sent: Sunday, November 19, 2006 8:16 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] FW: [U] Soldier in Iraq needs Access Help


Rusty,

The only problem with this is IED is at the start of a sentence or is
followed by a period, commas, etc.

Bobby 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
rusty.hammond at cpiqpc.com
Sent: Friday, November 17, 2006 2:17 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] FW: [U] Soldier in Iraq needs Access Help

Rocky,

These ideas aren't what he's asking for but they might help him speed up his
search a little bit.

To help his search he could in a query put Like "* IED *" in the criteria of
his query.  That should only return those records where IED is surrounded by
spaces on either side thus not being part of another word.

Another option, which isn't as nice as the Google search he refers to, is to
flag each article that has an instance of IED via an update query, export
those flagged records out to a word document via a report, then run Find and
Replace in Word and use the "Highlight All Items Found In" option. I know
this option is found in Word 2003 and not in 97.  I don't about the versions
in between.

HTH,

Rusty



**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************