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 ~
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.
What I have not done is figured out the following:1) Attach Word or Excel files2) 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 LorenziniSioux Falls, South Dakota
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar