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

Selasa, 28 Juli 2015

Re: [MS_AccessPros] Working with pictures in Access

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