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