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