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
Tidak ada komentar:
Posting Komentar