[AccessD] Photo Management

William Benson vbacreations at gmail.com
Fri Feb 1 22:59:26 CST 2013


Thanks Jim, I am aware of that program's existence but not so much its
function. I had rather imagined it was more relative to cloud storage. I
wanted some way to be sure I was moving (or planning moves) of items on my
hard drive, not on the internet. No doubt you've found that you can arrange
items on your hard drive without having to put them on the cloud to create
your albums, and just synchronize as you go along.

Currently all my files have names like 2010-12-31 21.47.16.jpg, which
doesn't help organize. So I wanted to, let's say, have a listbox showing
files of this nature, loaded from one or more folders, click on one or
more, tag them in a way to help me organize them later... then I could
search by tags or combination of tags and all the files tagged with words
like family or travel could appear in one location in my dashboard with a
preview window and a text box which after selecting any of the returned
items, lets me rename it which would affect its true name on the file
system, as well as give me some meta data. Essentially this is everything
that windows explorer already does except for the deficit that windows
explorer does not really show items from more than one folder (ie,
location) at a time, unless in Search mode.

I am trying to create something which acts like windows explorer and also
lets me establish list boxes representing new target locations which I can
drag and drop or move items to through button clicks, which won't actually
move them until I click Execute... and even after doing so, stores in a
database table, where the item came from, where I put it, when I did that
(note, file last moved is NOT a date field stored by Windows, whereas file
last accessed is.... the former being more important to me).

I think I can build an application like this in MS Access so long as I can
cause an image control to show a jpg or launch a video in a little window
(perhaps via a Flash plug-in). I don't really need to store the file(s),
the OS is doing this... I would just be keeping a history of the meta data
and giving myself a transport mechanism to move selected items from
location to location.

I'll have a look at what Picasa does and see if I am really adding any
value or not.

Thanks!!!




On Sat, Feb 2, 2013 at 5:18 AM, Jim Lawrence <accessd at shaw.ca> wrote:

> Hi William:
>
> I am not sure precisely what you want but the wife (and I for a small part)
> keep a lot of photos; many from travelling, art and family. We have well
> over 30,000 photos.
>
> The program we use to manage all these photo, from anywhere in the network,
> has an excellent cataloguing system, a good set of filters, format options,
> sending, emailing, printing, even face recognition, is Picasa, from Google:
>
> http://picasa.google.ca/
>
> It can also, to the best of my knowledge work or be made to work on any
> platform.
>
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
> Sent: Friday, February 01, 2013 1:10 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Photo Management
>
>  I would not be surprised if this has been tackled either here or on other
> forums, but I am looking for a way to manage photos and move them from
> wherever I encounter them in the windows explorer (often showing in preview
> mode) to distinct folders in a variety of locations without performing all
> required actions at one time. For example, if I encounter 6 among 36 files
> which I think should be moved to a folder called "Friends" I would like to
> tag them in a way that I can move them all at one time, wherever they are,
> even when I am no longer looking at the folder they are located in. So I am
> envisioning some sort of file managing system which is part database, part
> OS file system manager. I thought Access might be able to do this, perhaps
> showing me the contents of folders (items which are images) and loading an
> image control with the image, then I would choose something from a drop
> down which would help me tag the item while also storing information about
> where it had been, what it had been named, perhaps giving me a field which
> lets me rename it (while testing that I am not duplicate naming it) - but
> doing nothing to the original file until I am ready to execute the
> operation hich moves and renames all files at one time.
>
> I have found I cannot do this conveniently through the Operating System,
> and I cannot review planned changes without of course actually executing
> the changes - by which point in time it is too late. Such as moving
> something from folder A to folder B and renaming it from X to Y... all the
> original information is lost and there is no way to undo the change later.
> But if I could retain the old name and location, I could "reset" the
> operation" by reversing what I had done.
>
> I think a VBA application would help with a project of this nature. Anyone
> have any ideas how to approach this without reinventing the wheel?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
*Regards,*
**
**
*Bill Benson*
*VBACreations*
**
PS:  You've gotten this e-mail *because you matter to me!*


More information about the AccessD mailing list