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