Open attachment using Microsoft Web Browser in a Form (1 Viewer)

[ryanw1986]

Hi all.

I have a table in a database and each record has only 1x attachment (generally a PDF).

I need a form which has a Microsoft Web Browser on it that will show the relevant attachment.

Have seen similar posts for attachments using a file picker which doesn't work for me, all I want is to show the attachment on the actual record.

Thanks for any help.

R.

 

[bastanu]

Why web browser and not a bound object frame?

BoundObjectFrame object (Access)

Office VBA reference topic

docs.microsoft.com

Cheers,
Vlad

 

[theDBguy]

Hi. If you're talking about an Attachment field, I think it would involve extracting it to a temp folder first before you can display it in a web browser (or even a bound object frame) control.

 

[zeroaccess]

Check out:

 

[HiTechCoach]

Hi. If you're talking about an Attachment field, I think it would involve extracting it to a temp folder first before you can display it in a web browser (or even a bound object frame) control.

I agree.

Exporting the attachment is the only way I could get it to work in a Web Browser Control (WBC)

Why? Great question ... and the reason ...

Web Browsers only show files from the hard drive. Every web page is cached (downloaded) to the local computer's hard drive. The files are then loaded into the from the hard drive into the browser viewport for display. Even video streams must first download a program (code) to allow the stream to be viewed.

I have been using the Web Brower Control (WBC) it displays lots of differnt file types from disk by taking advantage of the capabilities of IE.

IIRC, the attachment field data type was added for Access Web apps published to Sharepoint. I do not use it for anything I create for the Desktop. (I only use Access on the desktop)

 

[isladogs]

Have a look at this example file viewer app. It allows you to view various types of file in a Web browser control within Access.
Depending on your Access version, you may need to run the .reg file included in the attached zip file to ensure files are opened within Access rather than externally