rusty.hammond at cpiqpc.com
rusty.hammond at cpiqpc.com
Fri Nov 17 13:16:34 CST 2006
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 Classification: UNCLASSIFIED If this e-mail is marked FOR OFFICIAL USE ONLY it may be exempt from mandatory disclosure under FOIA. DoD 5400.7R, "DoD Freedom of Information Act Program", DoD Directive 5230.9, "Clearance of DoD Information for Public Release", and DoD Instruction 5230.29, "Security and Policy Review of DoD Information for Public Release" apply. -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.14.6/536 - Release Date: 11/16/2006 3:51 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** 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. **********************************************************************