Hi Giorgio,
Sure. The ReadMe text file is nothing more than a brief description of the whole thing. It has no other function but to introduce the other 3 files in a general way.
The objective of the Access database is to provide a proof of concept for one way to determine if a character string is present in a file. The requirements were to see if the character string can be found in file with 3 different formats. Of the 3 files, I included the test files I built for both text and HTML file formats. I used each of these files to prove that a character string could be found in the selected file. Each of these test files were included in the zip file.
The data within each test file (TestFileHTML.txt or TestFileHTML.html) is totally irrelevant. I don't remember where I got the contents. There was no conscious decision to mention the find and replace or anything else in either file. It just seemed to me to be easier for anyone wanting to see how I satisfied requirements with these 2 file types to include my test files.
I subsequently posted a follow-up message that included the code I put together to open an *.pdf file in the user's default pdf file viewer to enable a manual search for a character string. This partially manual approach toward pdf files is because of the nature of the physical file structure used for pdf files and the fact that some sort of pdf file specific third party application would need to be used to interrogate that file type. Notepad, WordPad or other generic file readers wopn't work with a pdf file.
I hope this is clear. Please let me know if I've caused more wonderings and if so, I'll take another shot at an explanation.
Jeff
----- Original Message -----
Hi Jeff, I've downloaded your TestOpenSearchFile.zip. Could you please
explain what TestFileHTML.html, TestTextFile.txt and
TestOpenReadFile_ReadMe.txt are for and why Rick Fisher's Find & Replace
is mentioned in them?
Giorgio
--- 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_Assis\
tanceNeeded/ ). 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-642707\
30881E
> > > 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@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]
Tidak ada komentar:
Posting Komentar