HI i need someone who is experienced with writing vb code for ms access database, the function i would like to perform is to extract sentences that contain either of a group of phrases or keywords
so imagine this.
there will be 3 fields in the database
the first field is the primary key
the second field is my reference text field
the third field will be a memo field which has the content
now i need some sort of code or macro function that will delete any SENTENCES i.e. between "." and "." (excluding obvious abbreviations e.g. dr. mr. i.e.) and to only keep the SENTENCES which contain the keywords or phrases.
once i am satisfied i can supply you with a sample database with content.
at the moment i am using regex in my browser (findfox-firefox) and am searching for phrases using "keyword1|keyword2|keyword3+phrase|etc"
i am hoping for someone experienced who writes code quickly to get a quick job done thanks.