[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


-----Original Message-----
From: Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Friday, November 17, 2006 11:24 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] FW: [U] Soldier in Iraq needs Access Help


Anyone want to tackle this one?  Sounds like an interesting project.

 

Rocky

 

 

  _____  

From: Access Users Group of San Diego [mailto:admin at augsd.org] 
Sent: Friday, November 17, 2006 8:59 AM
To: Wayne Warren-Angelucci; Rocky Smolin; Mark J. Krisburg; Joe Anderson;
Dixon Foss; Barry Hynum (E-mail); Mike Dwyer; Ed Lance; Doug Murphy; Dixon
Foss; Jackie Murphy (E-mail)
Subject: FW: [U] Soldier in Iraq needs Access Help

 

 

-----Original Message-----
From: Newsom Lester SFC MNFI STARTEFF
[mailto:lester.newsom at iraq.centcom.mil]
Sent: Wednesday, November 01, 2006 9:12 AM
To: admin at augsd.org
Subject: [U] Soldier in Iraq needs Access Help

Classification: UNCLASSIFIED 

Greetings from Baghdad.

 

I am not one to ask for help until I have absolutely driven myself to the
edge. It is my hope that you or one of your experts can shed some light on
what I am trying to get Access to do.

 

There are actually two things, but first an explanation of what the database
does. A team of translators interpret local Iraqi newscasts which are
transcribed and input into the database. These transcriptions are referred
back to on a regular basis via requests to my office by the higher-ups. A
typical request would be along the lines of "Give me the instances over the
past two weeks Prime Minister Maliki has said he likes the U.S." or, "Give
me every article referring to IED's exploding in the past month"

 

A simple query of course, returns the date range and all articles whereas
the word "Maliki" appears. I am helped by the fact that Maliki does not
appear in the dictionary so I can scan through the articles, deleting those
that are not relevant. I cannot however discern when IED is actually part of
another word. 

 

What I would like to accomplish, is highlighting my text query, much like
Google does in its cached pages. So, those words that I search for are
highlighted, giving me a visual reference. 

 

I have tried constructing a macro to do the action and have also searched
high and low in the Help files and the Internet.. Perhaps this makes perfect
sense to you and you can point me in the right direction.

 

Thank you in advance for your time.

 

SFC Lester Newsom

Baghdad, Iraq