Michael-
That's why I suggested the Attachment data type - no code required. If you're
always going to use this as a desktop database, then no worries.
I haven't looked at Crystal's code, but it probably automates finding and
loading the file path to the picture. That code can look a bit daunting to a
"total beginner." As Crystal points out, using a Text field to store the
location of the picture is much more efficient and is portable to SQL Server and
the web. As of 2007, Access has a Control Source for the Image control. Point
that to your text field containing the file path, and the control will load the
picture for you on a form or report. The hard part is getting the correct file
path stored - which is why you need the "scary" looking code. If you're willing
to type the file path directly in the text field, then you don't need that code.
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: Wednesday, August 29, 2012 3:41 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Adding Photographs or Links to Photographs to a
Collection Database
Crystal:
I just looked at what you uploaded. Thanks for doing that. Unfortunately,
I'm a total beginner with Access, with no programming experience; so, your
upload looks like gibberish to me! I would not know where or how to begin
implementing such a solution - although I am sure it is quite elegant. I'm
a little frustrated with Access because I am able to design a database that
gets me 50% of what I want, but the missing 50% seems out of reach without
programming knowledge.
I just realized that I have one of John Viescas' books (Access 2010 Inside
Out). Maybe I should read through that again, but I did not recall much on
photos/images the last time I looked at it.
Regards,
Michael
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Tuesday, August 28, 2012 11:54 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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]
------------------------------------
Yahoo! Groups Links
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar