By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,480 Members | 1,229 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,480 IT Pros & Developers. It's quick & easy.

pdf displaying

P: n/a
T
Using 97, I have a db and I also have with many scanned pdf's all
contained in one folder.

Within form view I would like a user to be able to click a browse
button and select a pdf file and have if open from and display the pdf.
If the image is a jpg, gif or bmp this isn't a problem, but it seems
with pdf there is a problem.

Any idea's on how to accomplish this?

Sep 30 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
T wrote:
Using 97, I have a db and I also have with many scanned pdf's all
contained in one folder.

Within form view I would like a user to be able to click a browse
button and select a pdf file and have if open from and display the pdf.
If the image is a jpg, gif or bmp this isn't a problem, but it seems
with pdf there is a problem.

Any idea's on how to accomplish this?
Take a look at http://www.mvps.org/access/api/api0018.htm.

I'll assume, that if you were to click the pdf file from Explorer, it
will open correctly.

Sep 30 '06 #2

P: n/a
T

salad wrote:
T wrote:
Using 97, I have a db and I also have with many scanned pdf's all
contained in one folder.

Within form view I would like a user to be able to click a browse
button and select a pdf file and have if open from and display the pdf.
If the image is a jpg, gif or bmp this isn't a problem, but it seems
with pdf there is a problem.

Any idea's on how to accomplish this?
Take a look at http://www.mvps.org/access/api/api0018.htm.

I'll assume, that if you were to click the pdf file from Explorer, it
will open correctly.
Oct 1 '06 #3

P: n/a
T

salad wrote:
T wrote:
Using 97, I have a db and I also have with many scanned pdf's all
contained in one folder.

Within form view I would like a user to be able to click a browse
button and select a pdf file and have if open from and display the pdf.
If the image is a jpg, gif or bmp this isn't a problem, but it seems
with pdf there is a problem.

Any idea's on how to accomplish this?
Take a look at http://www.mvps.org/access/api/api0018.htm.

I'll assume, that if you were to click the pdf file from Explorer, it
will open correctly.
Oct 1 '06 #4

P: n/a
T

T wrote:
salad wrote:
T wrote:
Using 97, I have a db and I also have with many scanned pdf's all
contained in one folder.
>
Within form view I would like a user to be able to click a browse
button and select a pdf file and have if open from and display the pdf.
If the image is a jpg, gif or bmp this isn't a problem, but it seems
with pdf there is a problem.
>
Any idea's on how to accomplish this?
>
Take a look at http://www.mvps.org/access/api/api0018.htm.

I'll assume, that if you were to click the pdf file from Explorer, it
will open correctly.
Not using explorer --form view of access.

Oct 1 '06 #5

P: n/a
T wrote:
T wrote:
salad wrote:
T wrote:
>
Using 97, I have a db and I also have with many scanned pdf's
all contained in one folder.

Within form view I would like a user to be able to click a
browse button and select a pdf file and have if open from and
display the pdf. If the image is a jpg, gif or bmp this isn't a
problem, but it seems with pdf there is a problem.

Any idea's on how to accomplish this?

Take a look at http://www.mvps.org/access/api/api0018.htm.
>
I'll assume, that if you were to click the pdf file from
Explorer, it will open correctly.

Not using explorer --form view of access.
Yes, but the same principal applies. Double-Clicking a file in Explorer tells
Windows to open that file with whatever program has been associated with that
file type. The API code that is found at the link salad provided above would
allow you to run code in your Access form that "opens a file with whatever
program has been associated with that file type".

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Oct 1 '06 #6

P: n/a
T
where would I place the code Function fHandleFile(stFile As String,
lShowHow As Long)
sorry I'm a novice when it comes to functions

this is my current code: (on click of a command button)
Private Sub cmdBrowse_Click()
On Error GoTo err_cmdBrowse

Me![txtPicture] = GetOpenFile_CLT("C:\", "Select the File")
Me![txtPicture] = LCase(Me![txtPicture])
Me!Picture.Picture = Me!txtPicture

exit_cmdBrowse:
Exit Sub

err_cmdBrowse:
MsgBox Error$
Resume exit_cmdBrowse
End Sub

Take a look at http://www.mvps.org/access/api/api0018.htm.

I'll assume, that if you were to click the pdf file from
Explorer, it will open correctly.
Not using explorer --form view of access.

Yes, but the same principal applies. Double-Clicking a file in Explorer tells
Windows to open that file with whatever program has been associated with that
file type. The API code that is found at the link salad provided above would
allow you to run code in your Access form that "opens a file with whatever
program has been associated with that file type".

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Oct 2 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.