Hi Duane and Crystal,
Yes, it is normalized in that the path to each picture is its own record in a related table. I will try the subreport advice.
Thank you.
Steve
On 1/22/2019 3:20 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:
Steve,Is your table properly normalized so that each picture is its own record in a related table? If so, a simple subreport will work well. If not, I would create a union query to normalize the table and then use it as the record source of your subreport.
Regards,Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, January 22, 2019 1:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Pictures on a reporthi Steve,
use a main report with a subreport where the subreport show the image or
images.
If you tracking images for each tool in a related table, that will be
easiest to do too!
~crystal
VBA code you can use in your projects
http://msaccessgurus.com/code..htm
On 1/22/2019 9:53 AM, Steve thaw5 thaw5@suddenlink.net
[MS_Access_Professionals] wrote:
> I have a tools database -- hammers, screwdrivers, pliers, etc. The stuff
> you'd find in a hardware store. I've run into a problem in designing a
> report for this database. Each tool can have a picture or more than one
> picture. Or no pictures. A few tools have five pictures, that appears to
> the maximum. The underlying query makes available the full Windows path
> to each picture. Pictures are in jpg format.
>
> How do I structure the report to deal with the varying number of
> pictures? I suppose one way would be to put five image controls on the
> report and populate them with pictures as needed. That seems cumbersome,
> clunky. Is there a better way?
>
> Steve
>
>
> ------------------------------------
> Posted by: Steve thaw5 <thaw5@suddenlink.net>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
------------------------------------
Posted by: crystal 8 <strive4peace2008@yahoo.com>
------------------------------------
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
__._,_.___
Posted by: Steve thaw5 <thaw5@suddenlink.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPONSORED LINKS
.
__,_._,___
Tidak ada komentar:
Posting Komentar