Picture on Report - Yet Again? - 78264

Ok,

I know I'm going to get a bunch of links posted in this one regarding see
this post here and see this help section there, but I've looked at them and I
still can't get this to work, so here I am.

First of all I am on Access 2000

I am trying to get a picture to display on a form.  The directory for the .
jpg/.bmp is located in "tblISF" in a field called "PhotoFilePath".  The name
of my unbound object frame is "ImageFrame".

On the report "rptISF", I would like the picture to display in my group
header, so I have tried placing several different variations of the below
code in the "On Format" and "On Print" events, but I have not had any luck.
I was able to get this to work pretty easily on my form, "frmISF", so I am
not sure why I am having a hard time.  Any help is appreciated.  Thanks!

Variation 1:
If Not IsNull(Me![PhotoFilePath]) Then
Me![ImageFrame].OLETypeAllowed = 1
Me![ImageFrame].SourceDoc = Me![PhotoFilePath]
Me![ImageFrame].Action = 0
Else
Me![ImageFrame].OLETypeAllowed = 1
Me![ImageFrame].SourceDoc = "C:\NA.bmp"
Me![ImageFrame].Action = 0
End If
Variation 1 Error - Type Mismatch

Variation 2
Me.ImageFrame.Picture = Me.PhotoFilePath
Variation 2 Error - Object doesn't support this property or method

Variation 3
Me.ImageFrame.Picture = Forms!frmISF![PhotoFilePath]
Variation 3 Error - Object doesn't support this property or method

Regards,
James C.
EDI Analyst

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200803/1

0
jversiz
3/14/2008 10:13:09 PM
access.reports 4434 articles. 0 followers. Follow

3 Replies
633 Views

Similar Articles

[PageSpeed] 22

I'll just go through the steps in case you've missed something out. The code
is much simpler than what you've got (yay!)
First check that PhotoFilePath really contains the path to your photo. You
can copy and paste it from the Address bar in Windows Explorer.
PhotoFilePath  should be a string field, not an OLE field, in your table
design.
It needs to contain the whole file path and the whole name of your image
including the File Extension eg MyPic.jpg

To insert your ImageFrame in Acc2000 go to Insert, Picture (not Insert
Object), From File, choose any picture. In the Properties box, on the Format
tab,  delete the line next to Picture.
Say Yes to Do you want to remove the picture.
Next to picture, it will now say (None)
Name your frame ImageFrame in Properties
Click on the grey bar above the section that contains your Image Frame
In Properties, click on the Events Tab
Click next to On Format
Above where it says End Sub put
Me.ImageFrame.Picture = Me.PhotoFilePath

Evi

"jversiz via AccessMonster.com" <u41421@uwe> wrote in message
news:8129acb76b10d@uwe...
> Ok,
>
> I know I'm going to get a bunch of links posted in this one regarding see
> this post here and see this help section there, but I've looked at them
and I
> still can't get this to work, so here I am.
>
> First of all I am on Access 2000
>
> I am trying to get a picture to display on a form.  The directory for the
..
> jpg/.bmp is located in "tblISF" in a field called "PhotoFilePath".  The
name
> of my unbound object frame is "ImageFrame".
>
> On the report "rptISF", I would like the picture to display in my group
> header, so I have tried placing several different variations of the below
> code in the "On Format" and "On Print" events, but I have not had any
luck.
> I was able to get this to work pretty easily on my form, "frmISF", so I am
> not sure why I am having a hard time.  Any help is appreciated.  Thanks!
>
> Variation 1:
> If Not IsNull(Me![PhotoFilePath]) Then
> Me![ImageFrame].OLETypeAllowed = 1
> Me![ImageFrame].SourceDoc = Me![PhotoFilePath]
> Me![ImageFrame].Action = 0
> Else
> Me![ImageFrame].OLETypeAllowed = 1
> Me![ImageFrame].SourceDoc = "C:\NA.bmp"
> Me![ImageFrame].Action = 0
> End If
> Variation 1 Error - Type Mismatch
>
> Variation 2
> Me.ImageFrame.Picture = Me.PhotoFilePath
> Variation 2 Error - Object doesn't support this property or method
>
> Variation 3
> Me.ImageFrame.Picture = Forms!frmISF![PhotoFilePath]
> Variation 3 Error - Object doesn't support this property or method
>
> Regards,
> James C.
> EDI Analyst
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200803/1
>


0
Evi
3/14/2008 11:16:37 PM
Sorry, omitted to say
 Click next to On Format
Choose Event Procedure
Click just left of the that line to open a code page.
Evi

"Evi" <evwool@TakeThisOutntlworld.com> wrote in message
news:pHDCj.26336$ki.19975@newsfe2-gui.ntli.net...
> I'll just go through the steps in case you've missed something out. The
code
> is much simpler than what you've got (yay!)
> First check that PhotoFilePath really contains the path to your photo. You
> can copy and paste it from the Address bar in Windows Explorer.
> PhotoFilePath  should be a string field, not an OLE field, in your table
> design.
> It needs to contain the whole file path and the whole name of your image
> including the File Extension eg MyPic.jpg
>
> To insert your ImageFrame in Acc2000 go to Insert, Picture (not Insert
> Object), From File, choose any picture. In the Properties box, on the
Format
> tab,  delete the line next to Picture.
> Say Yes to Do you want to remove the picture.
> Next to picture, it will now say (None)
> Name your frame ImageFrame in Properties
> Click on the grey bar above the section that contains your Image Frame
> In Properties, click on the Events Tab
> Click next to On Format
> Above where it says End Sub put
> Me.ImageFrame.Picture = Me.PhotoFilePath
>
> Evi
>
> "jversiz via AccessMonster.com" <u41421@uwe> wrote in message
> news:8129acb76b10d@uwe...
> > Ok,
> >
> > I know I'm going to get a bunch of links posted in this one regarding
see
> > this post here and see this help section there, but I've looked at them
> and I
> > still can't get this to work, so here I am.
> >
> > First of all I am on Access 2000
> >
> > I am trying to get a picture to display on a form.  The directory for
the
> .
> > jpg/.bmp is located in "tblISF" in a field called "PhotoFilePath".  The
> name
> > of my unbound object frame is "ImageFrame".
> >
> > On the report "rptISF", I would like the picture to display in my group
> > header, so I have tried placing several different variations of the
below
> > code in the "On Format" and "On Print" events, but I have not had any
> luck.
> > I was able to get this to work pretty easily on my form, "frmISF", so I
am
> > not sure why I am having a hard time.  Any help is appreciated.  Thanks!
> >
> > Variation 1:
> > If Not IsNull(Me![PhotoFilePath]) Then
> > Me![ImageFrame].OLETypeAllowed = 1
> > Me![ImageFrame].SourceDoc = Me![PhotoFilePath]
> > Me![ImageFrame].Action = 0
> > Else
> > Me![ImageFrame].OLETypeAllowed = 1
> > Me![ImageFrame].SourceDoc = "C:\NA.bmp"
> > Me![ImageFrame].Action = 0
> > End If
> > Variation 1 Error - Type Mismatch
> >
> > Variation 2
> > Me.ImageFrame.Picture = Me.PhotoFilePath
> > Variation 2 Error - Object doesn't support this property or method
> >
> > Variation 3
> > Me.ImageFrame.Picture = Forms!frmISF![PhotoFilePath]
> > Variation 3 Error - Object doesn't support this property or method
> >
> > Regards,
> > James C.
> > EDI Analyst
> >
> > --
> > Message posted via AccessMonster.com
> > http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200803/1
> >
>
>


0
Evi
3/14/2008 11:21:04 PM
I'm not sure how you got yourself into the struggle
you're describing. If you have an image control
on your form or report, you simply set the picture
property to nothing and set the its propery to
"Linked".

At runtime, OnFormat or OnPrint, in your report
you set the picture to the path of the image you want.

If Len(Dir(MyPicturePath)) > 0 Then
    Me.MyImageControl.Picture = MyPicturePath
    Me.MyImageControl.Visible = True
Else
   Me.MyImageControl.Visible = False
End If

Bill

"jversiz via AccessMonster.com" <u41421@uwe> wrote in message 
news:8129acb76b10d@uwe...
> Ok,
>
> I know I'm going to get a bunch of links posted in this one regarding see
> this post here and see this help section there, but I've looked at them 
> and I
> still can't get this to work, so here I am.
>
> First of all I am on Access 2000
>
> I am trying to get a picture to display on a form.  The directory for the 
> .
> jpg/.bmp is located in "tblISF" in a field called "PhotoFilePath".  The 
> name
> of my unbound object frame is "ImageFrame".
>
> On the report "rptISF", I would like the picture to display in my group
> header, so I have tried placing several different variations of the below
> code in the "On Format" and "On Print" events, but I have not had any 
> luck.
> I was able to get this to work pretty easily on my form, "frmISF", so I am
> not sure why I am having a hard time.  Any help is appreciated.  Thanks!
>
> Variation 1:
> If Not IsNull(Me![PhotoFilePath]) Then
> Me![ImageFrame].OLETypeAllowed = 1
> Me![ImageFrame].SourceDoc = Me![PhotoFilePath]
> Me![ImageFrame].Action = 0
> Else
> Me![ImageFrame].OLETypeAllowed = 1
> Me![ImageFrame].SourceDoc = "C:\NA.bmp"
> Me![ImageFrame].Action = 0
> End If
> Variation 1 Error - Type Mismatch
>
> Variation 2
> Me.ImageFrame.Picture = Me.PhotoFilePath
> Variation 2 Error - Object doesn't support this property or method
>
> Variation 3
> Me.ImageFrame.Picture = Forms!frmISF![PhotoFilePath]
> Variation 3 Error - Object doesn't support this property or method
>
> Regards,
> James C.
> EDI Analyst
>
> -- 
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200803/1
> 


0
Bill
3/14/2008 11:59:36 PM
Reply:

Similar Artilces:

picture is not showing up in Excel
I have a picture that is in an Excel worksheet. I can see the handles and if I move the handles some, the picture will show up. However, it will not show up in print preview at all or page break preview. I can open the same file on another computer and it will show up fine. Any help would be appreciated. thanks. Check Tools -> Options ->General Do you have "Show All" selected for Objects? "cab58" wrote: > I have a picture that is in an Excel worksheet. I can see the handles > and if I move the handles some, the picture will show up. However, it > will...

Cutome Report
I am working with one of the report and need to have double space in between the rows, and need a line break between the group. Can someone help me. Thanks Chirag Thakkar NetLink Cosnulting, Inc. 732 548-6300 www.netlink-usa.com ...

Embedded pictures
Hello! I noticed that the when we set the picture property of a button or another control as embedded, it takes a lot of place. Is there an explication that show why the Access file encrease in size by more than the picture size (even if it is a bitmap, a format that is normaly heavy) Exemple: An mdb without picture would take 4 MB the same file with pictures would increase to 40 MB with only 400 KB of pictures. In JPEG format. Is it because Access uses a non efficient compression to include the image file? Thank you in advance for any suggestion! PS: I know that I can set the pictur...

Pictures don't print in outlook 2000 or 97
How do I get pictures to print when I print messages for Outlook 2000 or Outlook 97. I'm using XP Home. Thanks, Chris Hi Chris, Have you checked to make sure you have all of the latest Windows and Office Service Packs installed? I remember this issue from a whle back, and it was corrected in one of the service pack releases. Regards, Scott Atkins MCSE, MCSA Partner Technical Lead - Outlook Microsoft Technical Support for Platforms and Business Applications -------------------- >From: socialism001@yahoo.com >Newsgroups: microsoft.public.outlook >Subject: Pictures don't...

Inserting picture from "My Pictures"
When I add a pic from "My pictures" the entire picture does not appear on the slide and when I try to format it it is impossible to get it back to the same pic I am attempting to add. If I am trying to add a pic I might only get a nose or a blade of grass instead of the original picture from "My Pictures". Reduce the zoom to 10%. Coul be a too large image "PP Neophyte" <PP Neophyte@discussions.microsoft.com> a �crit dans le message de news: CA5F97E6-D4D8-401B-B066-E261024F082F@microsoft.com... > When I add a pic from "My pictures" t...

Picture in Publisher
When inserting pictures in publisher the picture does not show. I can see the frame. The same thing when I load a publisher file created by someone else. All the inserted pictures does not show. View>pictures is set to detailed display. Any suggestions for a solution? -- Thor Read the third FAQ here http://ed.mvps.org/Static.aspx?=Publisher/FAQs -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Thor" <Thor@discussions.microsoft.com> wrote in messag...

On-Sale Items report
Does anyone have a report that will show me all products that are on sale? I would like one that would shows me items on sale, when the sale expires, gross markup for the sale, and # of sold on sale. If anyone could write that for me I would be willing to pay I'm not schooled enough to do it. If not I would settle for one that just shows me active sale items. You can get most of this information except for # of sold on sale by filtering the Item Value List Report for Sale Start Date is less than or equal to today period and the Sale End Date is equal or greater than today. &quo...

Report available for items IN a stock count?
Is there any report already built in to Dynamics that will show us a particular vendor's items that are currently in a stock cycle count? Or show us if it's ever BEEN in a stock count (other than annual inventory) Is there something in SmartList? We are using v9.0 I could create one via MS Access if someone could tell me which tables would be the ones to use? Pam, From http://victoriayudin.com/gp-reports/inventory-tables/: IV00103 - Item Vendor Master IV10300 - Unposted Stock Count (header) IV10301 - Unposted Stock Count (line detail) IV30700 - Stock Count History (header) IV...

picture in picture
Have to digital pictures & would like to put a couple of people on one picture into the other picture. How do i do this? Anyone got any ideas? TIA "ted medin" <n6trf@arrl.net> wrote in message news:OaNwFXQeKHA.2596@TK2MSFTNGP04.phx.gbl... > Have to digital pictures & would like to put a couple of people on one > picture into the other picture. How do i do this? Anyone got any ideas? > TIA Well not with Vista. You need a Graphic editing application. The Gimp may be able to do this. (It's free, Open Source but is a bit tricky yo get to lear...

Picture Link
Appreciate some help here and thanks in advance. I link my pictures to the following folders C:\Documents and Settings\MyName\Desktop\Picture.jpg C:\Documents and Settings\MyName\My Documents\Picture.bmp My code: If Me!pic1a = "X" Then Forms!startpg!fmpPic!Img.Picture = "" Else Forms!startpg!fmpPic!Img.Picture = Me!pic1a End If It works on my PC but when I copied the program to another PC, it does not work. This is because of "MyName" and the other PC has a different name. Is there a way to ignore "MyName" for any PCs Regards "ChoonBoy&quo...

Sending pictures with text and then another picture with text.
I receive some e-mails with text and then a picture with more text and again a picture. Some of these will have 8 to 10 pictures with text under each picture. But when I send it out it is received with all of the text in a group and the pictures are all sent as attachments. How do I get my e-mails to send the pictures and text the way I receive them? Thanks for any help you can give me. Bob ...

Picture in header
How do I get a picture in the header? This was added in xl2002. File|Page setup|header/footer tab|custom header There's an icon that looks like a picture near the far right. Steve wrote: > > How do I get a picture in the header? -- Dave Peterson If you are using a version of Excel before 2002 then check out: http://www.nwarwick.co.uk/Excel2000GraphicalHeaders.htm for a workaround. HTH Neil www.nwarwick.co.uk "Dave Peterson" wrote: > This was added in xl2002. > > File|Page setup|header/footer tab|custom header > There's an icon that looks lik...

Can pictures be centered in a picture frame in a catalog?
I have created a catalog for items we sell. I have added the pictures to the catalog through the Excel worksheet. When the worksheet is imported, all of the pictures left-justify in the picture frame. Can this be centered? ...

Create picture catalog from current product codes
Any one who knows how to create a catalog of pictures in a=20 spreadsheet, from a list of product codes, that=20 automatically adds the pictures from a specific product=20 code list and creates links from the product code to the=20 specific cell in which the picture is positioned. Thanks=A1 Hi Julio, Merge Pictures and Words - Oh My!, by Cindy Meister, creates a catalog from text wording and external pictures from an Excel database. [photos, photographs] http://www.computorcompanion.com/LMMArticle.asp?ID=126 Also see extracting JPG / GIF files from an Excel document (charts). htt...

report not grouping correctly
i set up a report with grouping on Repair, Employee. My Employee isnt grouping right. Say the employee name is Stephen, it will group half of everything with Stephen, then another half with Stephen... I have looked at the form to make sure it is entered correctly and it is.. I cant figure it out? Thanks -- Message posted via http://www.accessmonster.com I do not understand. It seems like it is grouping like it is suppose to as Stephen, is not the same as Stephen... and would be another group. Am I missing something or reading what you wrote incorrectly? Try ...

attaching pictures as an icon
Hi I am trying to save memory in an excel report and I wish to include a picture in this report as an icon that shows the picture when selected. If you're going to try to save memory in the workbook, then it sounds like the big picture will be outside excel (a common LAN folder???). If yes, then maybe you could create thumbnails of each of your pictures (using ????) and then add a hyperlink to each thumbnail. The hyperlink would use whatever program is associated with the extension to open the big picture--outside of excel completely. (I don't know how you'd include the big p...

Picture download to picture taken date folders
Maybe somebody could direct me to a proper newsgroup if this isn't it. When I download pictures from my digital camera, it stores them all in one folder. Is there a way that I could download them into folders that it created by picture-taken date? Ken W <KenW@discussions.microsoft.com> wrote: >Maybe somebody could direct me to a proper newsgroup if this isn't it. > >When I download pictures from my digital camera, it stores them all in one >folder. Is there a way that I could download them into folders that it >created by picture-taken date? No...

Report all accounts with multicurrency checked on
I need to build a report that reflects following info for each account: Multicurrency checked: Yes or no Revalue option : Yes or no Please let me know which table contains this info for each account string? Thanks. GG, you should be able to get this information from the GL00100 (account master) and MC00200 (multicurrency account master) tables . -- Victoria Yudin Dynamics GP MVP Want to use Crystal Reports with GP? http://www.flex-solutions.com/gpreports.html blog: http://www.victoriayudin.com "GG" <GG@discussions.microsoft.com> wrote in mes...

count weeks in report
Hi! I have a report that is grouped by week. Week 1 with various totals, week 2 with various totals etc. Now, at the bottom of the report I want to count the actual number of weeks the report shows. Please help -- BS If you have an actual date field in your report's record source, you can use the DateDiff() function. =DateDiff("WW",Min([DateField]),Max([DateField])) -- Duane Hookom Microsoft Access MVP "Kantor" wrote: > Hi! > > I have a report that is grouped by week. Week 1 with various totals, week 2 > with variou...

picture in background show multiple images
When formatting a picture in background, it shows up as multiple images. How can I get just the one image? Thank you! My bad! Forgot about the 'master page' insert. "Anita" wrote: > When formatting a picture in background, it shows up as multiple images. How > can I get just the one image? > > Thank you! ...

No longer able to view pictures in Publisher Document
I am creating a document with many inserted photos. Everything was fine until I opened it today. All the photo areas are blank (the frame is there, but no photo). I checked the View menu and Pictures, but everything was set correctly. Why did this suddenly happen? What else can I try so the photos can be viewed (and most importantly, printed)? TN I checked further down in the "problem list" and found Ed Bennett's solution to move the hardware acceleration down 3 notches for my video driver. That Worked. I can see the photos OK in my other publisher documents with ful...

Crystal Report not found on File Repository Server
I recently upgraded our MSCRM server to a new server. We don't typically use the internal CRM reports, we have some custom ones created with PowerTrack that we primarily use. The CEO tried today though to open one of the canned MSCRM reports and got this error message. I tried the others and I get it on all of them. CrystalReportViewer File frs://Input/a_063/021/000/5439/6ac34043c58b1112.rpt not found on File Repository Server. I checked the input folder in c:\program files\crystal ent 9\filestore\input and it is empty. I would have copied them from the old server, but it is ...

Modified Report Modified with VBA (Blocked)
Hi to all, I have a the message "Modified Report Modified with VBA (Blocked)" on Maintenance of customizations screen on each VBA modifed report. This does not allow me to Export the report. What should I do to remove the "Blocked" message? Regards This happens when you have references in your project and its lost. For example you can have ADO "reference, or RetrieveGlobals reference. You only have to reasign the reference and the "Blocked" message disapears. Regards, Takashi "Jeantex" <Jeantex@discussions.microsoft.com> escribi� en el...

Picture referencing
I am currently trying to produce a spreadsheet and within it is the need for a database of pictures. The problem comes is that I need to be able to reference the pictures for use with VLOOKUP/HLOOKUP/IF. Can anyone shed some light on this issue. Richard, I will send you an example spreadsheet that does what you want. HTH, Bernie MS Excel MVP "Richard Riley" <richard.riley@consultant.volvo.com> wrote in message news:145301c3fbae$1db55450$a301280a@phx.gbl... > I am currently trying to produce a spreadsheet and within > it is the need for a database of pictures. T...

Setting default program for viewing pictures
How do I set the default program for viewing picture attachments? I use Outlook Express 6 and when I click to open an attached picture it opens to JASC Paint Shop Pro 8 but no picture appears. In the past Explorer opened up my pictures. Can any one give me the steps to change the default from paint Shop to Explorer?? Hi Digitdan, Change the program that starts when you open a file http://office.microsoft.com/assistance/preview.aspx?AssetID=HP051925951033&C TT=1&Origin=EC790000701033&QueryID=bSa5KrD4N0&Query=Change+the+program+that+ starts+when+you+open+a+file&Scop...