Senin, 13 Agustus 2012

[MS_AccessPros] Re: Query clients against pdf doc

 

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]
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar