ACCESS FEED: Re: [MS_AccessPros] Adding Photographs or Links to Photographs to a Collection Database

Hi Michael,

you're welcome -- guess it is already in Files>Crystal

Images_Access2007_070721.zip
Uses form f_Images to browse for a file and display the corresponding
image in a continuous form. Data is stored in table t_Images -- and what
is stored are the path and filenames to the images, not the images
themselves.

Well I just uploaded a new version here:
ImageControl_120828_070721_Crystal__Accdb_TXT_JPGs.zip
uses Image Control to show external files on a continuous form. FilePathName can start with "\" to be relative to current database location. ie: c:\myDatabasePath\Images\Picture.JPG would be stored as \Picture.JPG and rendered when the form is shown. Path to use is in an unbound textbox at top of form - calculated on Load. Includes Images directory with sample JPGs

> functional difference between an attachment vs. a link?

I think links are easier to deal with ... and it certainly makes the database easier to move :)

Warm Regards,
Crystal

*
(: have an awesome day :)
*

________________________________
From: Michael Davis <abbsgen@gmail.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, August 28, 2012 7:33 AM
Subject: Re: [MS_AccessPros] Adding Photographs or Links to Photographs to a Collection Database

I am certainly interested in flexibility for the future. It is conceiveable
that I might want to sell the collection someday by creating a website. Is
there any functional difference between an attachment vs. a link?

Michael
On Aug 28, 2012 9:16 AM, "Crystal" <strive4peace2008@yahoo.com> wrote:

> Hi Michael,
>
> I suggested an alternate method using linked files. Before you use
> attachments, consider if you will ever want to move the information out of
> an Access desktop database. Linking is more flexible for the future
>
> I know I have a sample database on this, I will look for it and post it in
> Files>Crystal when I find it ...
>
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
> ________________________________
> From: Michael K. Davis <abbsgen@gmail.com>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, August 27, 2012 10:16 PM
> Subject: RE: [MS_AccessPros] Adding Photographs or Links to Photographs to
> a Collection Database
>
> John:
>
> I am not sure how to get an Attachment control onto my form. I added the
> Attachment control to the Table, but I created the Form before I added the
> Attachment control to the Table. Do I need to create a new Form to bring
> over the photos, or can I update my existing Form to get the same photo
> attachments?
>
> Thanks,
> Michael
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
> Sent: Sunday, August 26, 2012 1:19 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Adding Photographs or Links to Photographs to
> a
> Collection Database
>
> Michael-
>
> I assume you're using an Attachment control on your form, correct? If it
> works in the table, it should work on your form. But the OLE error message
> implies that maybe there's a problem with the default program you have
> defined on your machine to handle that file type. What program opens when
> you double-click the photo file in Windows Explorer?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Michael
> Davis
> Sent: Saturday, August 25, 2012 11:29 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Adding Photographs or Links to Photographs to
> a
> Collection Database
>
> Yes, in my database Table, I successfully loaded some photos to the
> Attachment field. I then went to my Form and linked the new photo field to
> a
> spot on the form. However, when I click on that part of the Form, I get an
> error message (something about an OLE problem). So right now, I can only
> access the photo file from the Table, which is not the best GUI to work
> with. How can I also get the photo link to work in the Form?
>
> Regards,
> Michael
> On Aug 25, 2012 5:14 PM, "John Viescas" <JohnV@msn.com> wrote:
>
> > Michael-
> >
> > Click the Paperclip to get a menu to go find and load your photo. If
> > you bind the field to an Attachment control in a form or report, it
> > will display your picture.
> >
> > VBA = Visual Basic for Applications - the powerful coding language
> > built into Access. There are also macros to automate things, but to
> > call the Windows open file dialog, you need VBA.
> >
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Michael K.
> > Davis
> > Sent: Saturday, August 25, 2012 9:24 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: RE: [MS_AccessPros] Adding Photographs or Links to Photographs
> to
> > a
> > Collection Database
> >
> > John:
> > Thanks for the helpful reply. Strangely, Access would not let me change
> > the
> > data type of my "Photograph" field to "Attachment" (although it would let
> > me
> > change the data to other types), so I deleted the "Photograph" field from
> > my
> > Table and created new fields for the Attachments. However, now I find
> the
> > field is not labeled with the name that I selected, instead the table
> just
> > shows a paperclip icon in the title field, as well as in each row (guess
> > I'll have to remember which photo goes where).
> >
> > Ideally, I would like to have Access retrieve copies of the photos in my
> > Forms and Reports. I can live with clicking on the Attachment icons if
> > necessary, but it does make for an extra step in enjoying my collection.
> > What is "VBA" which you indicated would be needed to accomplish photo
> > retrieval?
> >
> > Regards,
> > Michael
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John
> Viescas
> > Sent: Saturday, August 25, 2012 12:36 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: RE: [MS_AccessPros] Adding Photographs or Links to Photographs
> to
> > a
> > Collection Database
> >
> > Michael-
> >
> > Consider using the Attachment data type to store your pictures. That'll
> be
> > easiest for a "newbie". You *could* store the path to the picture and
> > display it in an Image control on your forms and reports, but you would
> > need
> > some complex code to call the Windows Open File dialog to make it easy to
> > load the path to new pictures. If you want to go the more complex route,
> > let me know, and I'll give you some sample code (requires VBA).
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Michael
> > Davis
> > Sent: Saturday, August 25, 2012 6:19 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: RE: [MS_AccessPros] Adding Photographs or Links to Photographs
> to
> > a
> > Collection Database
> >
> > Sorry John, I'm using Access 2010 on a Windows 7 Ultimate machine.
> Thanks.
> >
> > Michael
> > On Aug 25, 2012 12:04 PM, "John Viescas" <JohnV@msn.com> wrote:
> >
> > > Michael-
> > >
> > > Which version of Access are you using? That makes a difference.
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out Microsoft Office Access 2007
> > > Inside Out Building Microsoft Access Applications Microsoft Office
> > > Access 2003 Inside Out SQL Queries for Mere Mortals
> > > http://www.viescas.com/ (Paris, France)
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Michael
> K.
> > > Davis
> > > Sent: Saturday, August 25, 2012 5:51 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Adding Photographs or Links to Photographs to
> > > a Collection Database
> > >
> > > Hi all. I'm a new member and a beginner with Access. I have been
> > > designing a database to manage a hobby collection. I could have
> > > purchased a pre-developed database for this purpose, but none of those
> > > available had the flexibility that I was looking for. As I am a true
> > > beginner (never worked with a database before) I expect to have lots
> > > of questions for this group.
> > > I have set up a basic working database, but need to add a few bells
> > > and whistles.
> > >
> > >
> > >
> > > One thing that has me baffled is how to add photographs, or at least
> > > links to photographs, to my Access database. Ideally, I would like to
> > > see a thumbnail photo of the collection item on screen with the data
> > > for that item. How can I do this? Also, is it more advisable to use
> > > links to the photos, rather than the photos themselves, to reduce the
> > > size of the database?
> > >
> > >
> > >
> > > Thanks in advance,
> > >
> > > Michael
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]