ACCESS FEED: Re: [MS_AccessPros] Re: Query clients against pdf doc

You are very welcome Toukey,

Don't hesitate to ask any questions you may have once you' ve looked at the uploaded database.

Based on the assumption that everyone has a pdf reader installed, my recommendation is to use the sample code to open the pdf file in the local reader and then to do a manual search. It might be that if the extra manual step is enough of a pain in the database, your users will try to download just text or HTML formatted files. It's also cheaper than buying a 3rd-party app.

My test database here has a button to open the pdf file in the local reader. If you'd like that copy, let me know. I didn't upload it after building the pdf logic. Your other option is to take the sample code and add a button to a form for it. It ought to be a nit.

Oh, and there's a number of alternative approaches in the form to get the downloaded file. The hidden option frame is present in case a standard file open window will be used although I didn't add the file open window logic because it's fairly standard across the various Office apps.

Jeff

----- Original Message -----

Jeff / Bill

Thank you so very much for the time and effort you have both put into this. Seems as though I have given you both a good challenge!

Jeff - I'll have a look today at what you uploaded.

Thanks again.
Toukey

--- In MS_Access_Professionals@yahoogroups.com , Jeff Jones <jpjones23@...> wrote:
>
> Bil,
>
> LOL, I'm not surprised. I didn't think of that although I've used a hex editor to change data in the MS Word executable to fix something that had decided to bug me with a pop-up window.
>
> Jeff
>
> ----- Original Message -----
>
>
>
>
>
> Jeff
>
> I even tried a Hex editor and couldn't see anything usable.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com , Jeff Jones <jpjones23@> wrote:
> >
> > Bill,
> >
> > Thank you. This seemed like the easiest way to meet the stated requirement.
> >
> > The only rub is the pdf file requirement but either one needs purchase a 3rd-party app, or convert the pdf to another format, or do what I did in the code example and that to just open it in the default pdf reader and do a search from there. The manual search seemed to be easiest and cleanest. I tested that code in the database I shared to know that it works. I use FoxIt and have it set up to have the Find Toolbar separate from the other toolbars in the body of the opened file so that it stands out. Then it's a simple matter of just entering the search string. Rather than try to replace the database I uploaded, I just shared that code. I did this wonderfulness for 2 reasons. They follow.
> >
> > 1. First, as Clive mentioned, the file structure of a pdf file is horrific. The manual describing it is around 1,100 pages from what I understand and I'm not about to wade through that.
> > 2. Second, the code that opened the Text or HTML files doesn't recognize the EOF so it always hits an error with the "Beyond End Of File" wonderfulness.
> >
> > I did open a pdf file in notepad prior to sharing anything but the hieroglyphics within do not allow for a successful find of any character string.
> >
> > Jeff
> >
> > ----- Original Message -----
> >
> >
> >
> >
> >
> > Jeff
> >
> > Thanks for the sample. I see you are dumping the entire text into a string and then using InStr to search it. Clever!
> >
> > Bill Mosca
> >
> > --- In MS_Access_Professionals@yahoogroups.com , Jeff Jones <jpjones23@> wrote:
> > >
> > > Hi Toukey and Bill, et al or anyone else,
> > >
> > > I've uploaded a zip file to the Assistance Needed folder ( http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/2_AssistanceNeeded/ ). The name of the file is: TestOpenSearchFile.zip.
> > >
> > > Within the file are 4 files. Their names and descriptions follow, although I believe that the file names are self explanatory.
> > >
> > > OpenTextFile.accdb <- test database
> > > TestFileHTML.html <- Test HTML file
> > > TestOpenReadFile_ReadMe.txt <- Requested ReadMe file with a few pithy pontifications within.
> > > TestTextFile.txt <- Test Text file
> > >
> > > If the zip file is somewhere down a bunch of pages in the folder, my Yahoo User Name is pdcaregiver. I already had the ID when I joined because I built and sorta maintain a web site ( http://www.pdcaregiver.org/ ) for people who are caregivers of people with Parkinson's although there is a lot of generalized caregiver information that anyone can use.
> > >
> > > I built the database because it was easier than trying to explain what is needed and besides I didn't remember what to do until I put the thing together. I never try to remember everything as long as I can remember how to or where to look for what I need. After 30 some years cutting code, my head is getting full. LOL
> > >
> > > Jeff
> > > ----- Original Message -----
> > >
> > >
> > >
> > >
> > >
> > > Hi Jeff,
> > >
> > > Thanks for your response. I too would appreciate an example of how this can work.
> > >
> > > Also to further answer your questions, the pdf /xml / html file(s) would be downloaded from the internet onto the user's machine. The access database in this instance is not split.
> > >
> > > Regards
> > > Toukey
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com , Jeff Jones <jpjones23@> wrote:
> > > >
> > > > Hi Bill,
> > > >
> > > > First, you're welcome for the pdf reader info.
> > > >
> > > > Maybe I used instr instead of find. I'll look for an example of how I did this sort of thing in the past.
> > > >
> > > > Jeff
> > > >
> > > > ----- Original Message -----
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Jeff
> > > >
> > > > Thanks for the information on the PDF reader. Do you have any idea how using a Find in any program can be read by Access?
> > > >
> > > > Bill
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com , Jeff Jones <jpjones23@> wrote:
> > > > >
> > > > > Toukey,
> > > > >
> > > > > First, the message below doesn't specify where the pdf, HTML, or XML files are. My suggestion is based on the assumption that each type of file is on a local drive or LAN and not on some server somewhere in the world.
> > > > >
> > > > > Both the HTML and XML files can be opened in Notepad or WordPad depending on their size. Once opened, the code ought to be able to do a "find".
> > > > >
> > > > > The pdf file is more problematic in that just opening one in Notepad or WordPad will not result in a text-based representation of the contents so a "find" will not work with a pdf file. You will need a third party pdf reader. I have been using FoxIt Reader for pdf files as it has a smaller footprint than Adobe's and it does have some command line capabilities. I am in no way affiliated with FoxIt and all I'm doing is sharing what I've been using. Doing an Internet search will easily let you read about or download FoxIt. I am using the free version.
> > > > >
> > > > > A separate consideration, beyond the physical file locations, has to do with the number of users and their geographic dispersion as well as the Access configuration. Is the database split with separate front and back ends?
> > > > >
> > > > > These are the immediate things that come to mind. I hope you find a solution.
> > > > >
> > > > > Kind regards,
> > > > > Jeff
> > > > >
> > > > > ----- Original Message -----
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Toukey
> > > > >
> > > > > PDF & HTLM probably not without a third-party program if one exists.
> > > > >
> > > > > XML maybe. I haven't used XML wish Access yet. Someone else might have an answer for you.
> > > > >
> > > > > Regards,
> > > > > Bill Mosca, Founder - MS_Access_Professionals
> > > > > http://www.thatlldoit.com
> > > > > Microsoft Office Access MVP
> > > > > https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> > > > > My nothing-to-do-with-Access blog
> > > > > http://wrmosca.wordpress.com
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com , toukey1 <no_reply@> wrote:
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Is it possible in Access to check the names in a client table against names in a pdf, HTML or XML document? If so, how does one approach this?
> > > > > >
> > > > > > Regards
> > > > > > Toukey
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > >
> > > > >
> > > > > Jeffrey Park Jones
> > > > > Excel, Access, Word, Office Expert
> > > > > Excel and Access, LLCÃƒÆ'Ã†'ÃƒÂ¢Ã¢â€šÂ¬Ã…Â¡ÃƒÆ'Ã¢â‚¬Å¡Ãƒâ€šÃ‚Â®
> > > > > Christopher@
> > > > > http://ExcelAndAccess.Com
> > > > > Toll Free 877-392-3539
> > > > > Direct Line 714-262-6893
> > > > >
> > > > > 919-671-9870
> > > > > 5109 Deer Lake Trail
> > > > > Wake Forest, NC 27587
> > > > > jpjones23@
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > >
> > > >
> > > > Jeffrey Park Jones
> > > > Excel, Access, Word, Office Expert
> > > > Excel and Access, LLCÃƒÆ'Ã¢â‚¬Å¡Ãƒâ€šÃ‚Â®
> > > > Christopher@
> > > > http://ExcelAndAccess.Com
> > > > Toll Free 877-392-3539
> > > > Direct Line 714-262-6893
> > > >
> > > > 919-671-9870
> > > > 5109 Deer Lake Trail
> > > > Wake Forest, NC 27587
> > > > jpjones23@
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > > --
> > >
> > >
> > > Jeffrey Park Jones
> > > Excel, Access, Word, Office Expert
> > > Excel and Access, LLCÃƒâ€šÃ‚Â®
> > > Christopher@
> > > http://ExcelAndAccess.Com
> > > Toll Free 877-392-3539
> > > Direct Line 714-262-6893
> > >
> > > 919-671-9870
> > > 5109 Deer Lake Trail
> > > Wake Forest, NC 27587
> > > jpjones23@
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > --
> >
> >
> > Jeffrey Park Jones
> > Excel, Access, Word, Office Expert
> > Excel and Access, LLCÃ‚Â®
> > Christopher@
> > http://ExcelAndAccess.Com
> > Toll Free 877-392-3539
> > Direct Line 714-262-6893
> >
> > 919-671-9870
> > 5109 Deer Lake Trail
> > Wake Forest, NC 27587
> > jpjones23@
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> --
>
>
> Jeffrey Park Jones
> Excel, Access, Word, Office Expert
> Excel and Access, LLCÂ®
> Christopher@...
> http://ExcelAndAccess.Com
> Toll Free 877-392-3539
> Direct Line 714-262-6893
>
> 919-671-9870
> 5109 Deer Lake Trail
> Wake Forest, NC 27587
> jpjones23@...
>
>
>
>
> [Non-text portions of this message have been removed]
>

--

Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.Com
http://ExcelAndAccess.Com
Toll Free 877-392-3539
Direct Line 714-262-6893

919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net

[Non-text portions of this message have been removed]