Displaying PDF Files in a Form

[Kevin Baker]

Hi Everyone,

I have a form with two fields, Title and Path. I'm also using the pdf.ocx
and have a OLE object in my form. In code for "On Current" I have the
following:

On Error Resume Next
Dim strPath As String

strPath = Me.Path
Pdf2.src = strPath

When I first open the form, my first record is displayed correctly, however,
when I go to my next record, the OLE Frame just goes blank. Any ideals?

This little program will act as a PDF database and viewer, I just hated
having to open each PDF to see it's contents.

Thanks,
Kevin

[Mike Krous]

Im not sure that I understand correctly, but you say you have two fields
(title, path) but I only see you using one of those two fields to assign to
the source of your pdf ocx control. Maybe you need something like

'add
strTitle = Me.Title 'or whatever field holds title

'change from
Pdf2.src = strPath
to
Pdf2.src = strPath & strTitle

Just a thought.

Mike Krous

"Kevin Baker" <sh******@cox.net> wrote in message
news:6jQxb.10064$dO2.4369@lakeread03...

Hi Everyone,

I have a form with two fields, Title and Path. I'm also using the pdf.ocx
and have a OLE object in my form. In code for "On Current" I have the
following:

On Error Resume Next
Dim strPath As String

strPath = Me.Path
Pdf2.src = strPath

When I first open the form, my first record is displayed correctly, however, when I go to my next record, the OLE Frame just goes blank. Any ideals?

This little program will act as a PDF database and viewer, I just hated
having to open each PDF to see it's contents.

Thanks,
Kevin

[Tom Wickerath]

For troubleshooting, I'd recommend losing the On Error Resume Next statement. If you have
an error, you'll never know about it with that line of code included.....

________________________________

"Mike Krous" <m.krous@nospam_comcast.net> wrote in message
news:Tu********************@comcast.com...

Im not sure that I understand correctly, but you say you have two fields
(title, path) but I only see you using one of those two fields to assign to
the source of your pdf ocx control. Maybe you need something like

'add
strTitle = Me.Title 'or whatever field holds title

'change from
Pdf2.src = strPath
to
Pdf2.src = strPath & strTitle

Just a thought.

Mike Krous

________________________________

"Kevin Baker" <sh******@cox.net> wrote in message
news:6jQxb.10064$dO2.4369@lakeread03...

Hi Everyone,

I have a form with two fields, Title and Path. I'm also using the pdf.ocx
and have a OLE object in my form. In code for "On Current" I have the
following:

On Error Resume Next
Dim strPath As String

strPath = Me.Path
Pdf2.src = strPath

When I first open the form, my first record is displayed correctly, however, when I go to
my next record, the OLE Frame just goes blank. Any ideals?

This little program will act as a PDF database and viewer, I just hated
having to open each PDF to see it's contents.

Thanks,
Kevin

[Mike Krous]

Good Eye Tom! I missed that one!

Mike

"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:rf********************@comcast.com...

For troubleshooting, I'd recommend losing the On Error Resume Next statement. If you have an error, you'll never know about it with that line of code included.....

________________________________

"Mike Krous" <m.krous@nospam_comcast.net> wrote in message
news:Tu********************@comcast.com...

Im not sure that I understand correctly, but you say you have two fields
(title, path) but I only see you using one of those two fields to assign to the source of your pdf ocx control. Maybe you need something like

'add
strTitle = Me.Title 'or whatever field holds title

'change from
Pdf2.src = strPath
to
Pdf2.src = strPath & strTitle

Just a thought.

Mike Krous

________________________________

"Kevin Baker" <sh******@cox.net> wrote in message
news:6jQxb.10064$dO2.4369@lakeread03...

Hi Everyone,

I have a form with two fields, Title and Path. I'm also using the pdf.ocx
and have a OLE object in my form. In code for "On Current" I have the
following:

On Error Resume Next
Dim strPath As String

strPath = Me.Path
Pdf2.src = strPath

When I first open the form, my first record is displayed correctly, however, when I go to my next record, the OLE Frame just goes blank. Any ideals?

This little program will act as a PDF database and viewer, I just hated
having to open each PDF to see it's contents.

Thanks,
Kevin