Adobe Acrobat & pdf.ocx - The Paperless Office

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

moroni - 27 Dec 2005 12:01 GMT

No problem 2 set Access up to get address data from tblClients then to
use a form as a letterhead and to keyboard in the letter content then
save the letter to a tblCorrespondence
Get a scanner. Scan in your letters received to pdf format.Now insert
in a form Adobe Acrobat Control For ActiveX (the pdf.ocx). Set the src
property of the ActiveX control to the path of the pdf file you want to
view. No problem it all works fine. Now try to change the file path
programmatically to enable you to view all of the received
correspondence. It dont work.
Crazy is it not - MS Acess, Adobe Acrobat Reader and an ActiveX control
do not work 2gether to create the paperless office - solutions please -
no shelling out to Adobe Acrobat Reader - need to do it all in the
Access Form!

Reply to this Message

pietlinden@hotmail.com - 28 Dec 2005 00:32 GMT

Is this a request for help? have you seen your manners recently --
they seem to be missing. (Are the under Tools->References?)

First off, you don't use forms as letterhead. You can automate Word,
which (strangely enough) is designed to create letterhead etc. Steve
Arbaugh's website has code to save reports/Word docs to PDF.

View the received correspondence... hmm... You mean you can't use the
OpenFile or BrowseFolder APIs at Accessweb?

You *need* to do all this in an Access form? According to whom?

Reply to this Message

moroni - 28 Dec 2005 02:22 GMT

Yes the post was a request for help - please accept apologies for
curt tone.
A solution to the problem of the pdf.ocx would be appreciated.

My database is utilized in a law office where a client has many cases
and
each case has many parties and each party has many letters sent to
them.
All letters to the parties are done in an access form. They are then
easily
viewed in the access application. This is done with a list box on the
left of the form
showing the date of the letter and its description. To the right is the
letter text. The user
can easily scroll down the list box and with a click the letter text is
visible on the right.
A bit like a book if you will. Word cant touch this for speed and every
time a letter is done it is automatically time recorded.

Just need the letters in which are scanned as .pdf to be capable of
being viewed in
the same access form and hence you have all correspondence in the
database there being
no need for a paper file.

The problem is how to alter the src property of the activex control
above.
Yes I can program this eg Me!ActiveX1.src = "Path of .pdf" but
access just crashes

I have researched this group extensively - the same problem has been
referred to before
but I have seen no solution - Help please if there is one.

Reply to this Message

moroni - 28 Dec 2005 02:38 GMT

solution found

See

Rogge Heflin
Apr 28 2003, 6:36 pm
Newsgroups: microsoft.public.vb.controls
From: "Rogge Heflin" <rhef...@tuttleandbailey.com> - Find messages by
this author
Date: Mon, 28 Apr 2003 11:35:00 -0700
Subject: Re: Opening pdf files
Reply to Author | Forward | Print | Individual Message | Show original

| Report Abuse

Preferred method using the Acrobat ActiveX component:

Dim FILENAME as String
FILENAME = "C:\Program Files\text.txt"
pdfBOX.LoadFile FILENAME

thanks

Reply to this Message