Rabu, 23 Januari 2019

Re: Re: [MS_AccessPros] Pictures on a report

 

Hi Steve,

Can you simply filter the subreport for records containing jpg files?

Duane


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Steve thaw5 thaw5@suddenlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, January 23, 2019 9:11 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Fwd: Re: [MS_AccessPros] Pictures on a report
 


Hello Duane and Crystal and all,

The subreport idea looks like it will meet my need, thanks for that advice.

One point I need  help with: many tools in my database have external files which include jpg picture files as well as pdf, bmp and text files. These files are all in the same folder.

The image control on the subreport renders the jpg files as expected. The image control does not know what to do with the non-jpg files but it inserts a blank record. Is there a way to make the subreport ignore the non-jpg entries? Or otherwise suppress the blank records?

Steve

-------- Forwarded Message --------
Subject: Re: [MS_AccessPros] Pictures on a report
Date: Tue, 22 Jan 2019 16:16:32 -0500
From: Steve thaw5 thaw5@suddenlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Reply-To: MS_Access_Professionals@yahoogroups.com
To: MS_Access_Professionals@yahoogroups.com


 

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 report
 
hi 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: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

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