Solved

Access file with attachment data types - Part 2

Posted on 2013-01-12
3
262 Views
Last Modified: 2013-01-27
Someone had helped me with my original question titled, "Access file with attachment data types" but I now realize I need a little more help.  The individual that helped me supplied a file named "Access-BasicLinkFormReportImages.mdb" which works fine but now I have to somehow make it work with PDF files.  The Access version being used is 2007.

Will it somehow work and what has to be done to change it?

--Steve
0
Comment
Question by:SteveL13
3 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 38770296
Attached you will find a simple adaption of the simple example.
Access-BasicLinkFormReportImages.mdb
0
 
LVL 39

Expert Comment

by:als315
ID: 38770304
You can't view pdf file in image control, you should use Web browser control (and you need acrobat reader installed). Look at sample
Access-BasicLinkFormReportImages.mdb
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 38770518
Yes, both are adaptations of my basic sample file.

Here is the one I made specifically for PDF's.
You can select "All file Types" from dialog box to select Images, ...etc
...or again, you can modify the code to filter for your specific file types.


Just note that the webbrowser cannot display *All* file types...
As I stated, there is a difference between "Viewing" a file and "opening" it...
Access-BasicLinkFormDisplayPDFWe.mdb
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now