ACCESS FEED: Re: [MS_AccessPros] Working with pictures in Access

Rabu, 29 Juli 2015

Re: [MS_AccessPros] Working with pictures in Access

Art -

Give me a couple of days and I will throw together a quick demo for you,

On loading the form I check the last three characters of the file name if "PDF" then hide one window and make the other visible,

I use two viewers, one over the other, one for PDF files and the second for image files. I like PNG files as those use a lossless compression. Are small and easy to work with the files. PDF files have a bit more overhead needed to futz with. With PDF's need to add a delay here and there as PDF's are a bit slow to open, also need to be careful on moving and renaming files, as the file lock can be a pain in the ass.

In the PDF viewer have full control can zoom in and out of the document and scroll through pages plus open the document, perhaps even save a copy all from within you forms...

Mike

From: "Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, July 29, 2015 8:41 AM
Subject: Re: [MS_AccessPros] Working with pictures in Access

Will this allow for PDFs? In other areas of my application I need to attach legal documents and such.

With Warm Regards,

Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."

From: "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, July 28, 2015 11:57 PM
Subject: Re: [MS_AccessPros] Working with pictures in Access

nice video, Mike

Art, you can use an Image control. Assign the field with the path and filename as the ControlSource and the pictures will render, even on a continuous forms :)

My free contact management template has a feature that you can get to by clicking the red pushpin on yellow background icon that opens a form :

1. browse for a file
2. copies the chosen file to an Attachments directory below the database and links it
3. If the file is a JPG or PNG, the image will be rendered when you choose pictures (you can change the code to render more image formats)

Since, in this case, the (relative) path is always the same, just the filename is stored and the path is added when needed

free Contact Template for Access including Project Management and Common Business Needs
http://msaccessgurus.com/Contacts.htm

Access Contact Template, Contact Management System (CMS) Music by Ken Gaines (cc)
https://www.youtube.com/watch?v=wVYnIM2oYkg
- Watch this video to learn how to take advantage of the most powerful free contact template you can download for Microsoft Access.

Projects, Tasks, and Time in contact Template for Microsoft Access (cc)
https://www.youtube.com/watch?v=0PupznJcrWU
- Keep track of projects, tasks, and time spent on projects

Warm Regards,
crystal

Microsoft MVP Virtual Conference Presentation on Access Web Apps, and linking to web databases from Access, Excel, and SSMS (53 min video)
https://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps

~ be awesome today ~

On 7/28/2015 3:31 PM, Sac City Plumbing saccity101@yahoo.com [MS_Access_Professionals] wrote:

Art -

I started with the demo by John V. pictures something, and used that to build on.

It works well, I have updated it to handle PDF files and such...

I store the path to the network drive, I load all the images into a temporary directory, to be processed before storing the name and path in the database. As only limited file paths are allowed I have added a path table to help keep everything organized.. '

I have issues with TIFF files for some reason, prefer working with PNG files as most of my images are for document control, PDF files can be a pain.

When opening an image I first make a copy and then open the copy. This was done in that I would open an image and then try to have my system move or save the file so having a copy open just made it easier. I also created an export folder where images/files are copied when they need to be accessed for emailing to clients. One folder to look in with only a few files to find the images rather than having to look through working directories with thousands of files.

For a naming convention I used the date and the image number within the database, ie. 20150728 000958

Here is a YouTube clip of where I was at back in 2009, a lot of work since then... But all in Access not Server.

https://www.youtube.com/watch?v=piFaUW-euXQ

What I have not done is figured out the following:

1) Attach Word or Excel files

2) Link to Gmail to automatically email billing.

Mike

From: "dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, July 28, 2015 11:28 AM
Subject: [MS_AccessPros] Working with pictures in Access

Here is my scenario. I have a form called frm_UnitDetails which contains summary information for a house. The frontend is a Access 2013 application and the backend is SQL Server. I need to be able to display pictures of front, rear, left side, right side, yardage on the form. From what I have researched it is best to just to keep the path for the picture in the table reach points to each storage location. How would I achieve this?

I will also need to keep a multiple pictures from inspection on a tab control on this form. Do you know any examples or advice on how I can get this done?

Thank you,

Arthur Lorenzini

Sioux Falls, South Dakota