agwalsh
asked on
Tagging photos in Access 2010 - is it possible and how can it be done?
hi
I have a form (Access 2010) which is mapped to an attachment field. The plan is for the user to add photos to the form. Is there any facility for them to tag the photos within Access and if so how?
I have a form (Access 2010) which is mapped to an attachment field. The plan is for the user to add photos to the form. Is there any facility for them to tag the photos within Access and if so how?
I don't work with Access 2010 much, but what do you mean by 'tagging' the photos?
Nope, access is not a photo arcvhiving system, its a vanilla database. You need specialist apps for doing things like that.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@mbizup - the user wants to be able to add keywords with the photo like descriptions, dates etc. I didn't think you could but wanted to check..
@neilsr - I had suspected as much but wanted to get confirmation. Any recommendations around specialist apps?
@neilsr - I had suspected as much but wanted to get confirmation. Any recommendations around specialist apps?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@neilsr. So when the person creates the photo, they can add the tags then, but it's only when they open the photos from within Access and view them in the photo gallery that they can view the tags. They don't appear as popups within Access. I think this is enough for the user.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@neilsr. I'm not going there with the user. I'll tell the user that it can't be done via Access but that they can add tags i.e. keywords etc via their media library and that will have to do. Thanks for your input.
ASKER
It's good to know that (a) it really can't be done from within Access and (b) they can be tagged - but not in Access and (c) if I really really wanted to I could get a specialised app.
One possible issue here.
Each record can have multiple attachments.
A lot of people don't know this.
From a few questions I participated in I discovered that there is no easy way to "display" all of the attachments associated with a file (Images specifically).
What does this mean...?
If a record will have more than one image, your system would also have to associate the tags to each of that records multiple attachments...
But like the other Experts have commented, the "Tagging" functionality is something you will probably create yourself.
JeffCoachman
Each record can have multiple attachments.
A lot of people don't know this.
From a few questions I participated in I discovered that there is no easy way to "display" all of the attachments associated with a file (Images specifically).
What does this mean...?
If a record will have more than one image, your system would also have to associate the tags to each of that records multiple attachments...
But like the other Experts have commented, the "Tagging" functionality is something you will probably create yourself.
JeffCoachman