pdf displaying

[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?

[salad]

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.

[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.

[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.

[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.

[Rick Brandt]

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

[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