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