Steve,
Open rptsubItemCost in design view to find its record source.
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 3:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Pictures on a report
Sent: Wednesday, January 23, 2019 3:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Pictures on a report
I looked for a subreport Record Source on the property sheet but do not find it. The report has a Record Source on the property sheet (a query), but the subreport does not. The subreport does have a Source Object, it is Report.rptsubItemCost.
Steve
On 1/23/2019 3:59 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:
Steve,What is the Record Source of the subreport? I would think you could use something like:
SELECT *FROM tblToolPicturesWHERE [PictureFileName] Like "*.JPG"
Regards,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 2:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Pictures on a report
Duane,
I'd like to filter the subreport. How? Something on the property sheet (I don't see it)? VBA code? Query? Something else?
Steve, slow on the uptakeHi 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
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: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
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