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

Michael-

Open your form in Design or Layout view and delete the old control you
originally created by selecting it and pressing Delete. On the Design tab in
the Controls group, go to the second page of controls to find the paperclip that
is the Attachment control. Click on that, then use your mouse to either place
or "draw" the control onto your form.

By the way, this won't work in a Web database. The Attachment control and data
type are available only in a desktop database.

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: Tuesday, August 28, 2012 6:17 AM
To: MS_Access_Professionals@yahoogroups.com
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