We want a catalog - style report but the boss is going to want drag and drop. The tables are based on a link to an image. Is this possible?
We want a catalog - style report but the boss is going to want drag and drop. The tables are based on a link to an image. Is this possible?
Hi -
First, if the tables are linked to images, what would you be dragging and to where? Second, reports are static, i.e. not editable (after they have been produced).
Can you give more detail as to what you need to do?
John
TOGO: yep, you need to provide more details really.
Just to mention, my AccessImagine component supports image drag-and-drop to the form and works with linked images.
dragging image files from a folder onto an access form, and then have the image paths extracted at that point and inserted into table. The report will display whatever images are linked in the table. Also I'm not sure why we need to worry about editability of reports, there are a multitude of ways around that.
Ok, its like I supposed. Then AccessImagine is the fastest way to implement this without getting your hands "dirty".
As alternative, you can write all this functionality with VBA (or find somewhere that code and tailor it to your needs).
I see that accessImagine uses OLE objects, and I've been having trouble making them display on reports.
It supports seamless automatic external image storage also.
Place AccessImagine on form, specify StoragePath property and bind it to some field for filenames.
It will make all the rest of work.
Hi -
Given your description of your requirement, it might be easier to use the the MS Access interface to the File Dialog object to select the file, and then extract the required data from the file name returned to Access.
Here are a couple of links I found. They refer to Windows XP, so the use in Windows 7 may be different:
http://blogannath.blogspot.ca/2010/0...cks-using.html
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
HTH
John