Pictures still icons. 1

[jaslr]

I have posted here a while ago about not being able to see pictures in Access. I create a table with one text field and one OLE field. To test it I then write 'Hummer' into the text field and link the OLE field to a picture of a hummer(C:\Pictures\hummer.jpg).

I then create a report with design view with the text box above the OLE object box and make sure I select - Display Item: Content".

I then look at the Report in Form View at it is still an icon. I can double click the icon and the picture appears. However this is not what I want, I want the picture to be visible when the Report is made.

What am I doing wrong?

Regards

 

[jaslr]

No one knows this answer to this question?

 

[gusbrunston]

Hi:

I recently printed this procedure from microsoft, followed it to the letter, and can load a picture from a file into a table for form or report.

recommend you look at this:[tt]

http://support.microsoft.com/default.aspx?scid=kb;en-us;198466

[/tt]

I hope this is helpful. Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[gusbrunston]

And, by the way, this is the code I ended up with for the function:
[tt]
Function setImagePath()
Dim strIP As String
On Error GoTo NoPicture
strIP = "C:\AAAPicts\" & Me.ImageID & ".jpg"
Me.ImageFrame.Visible = True
Me.ImageFrame.Picture = strIP
Exit Function
NoPicture:
Me.ImageFrame.Visible = False
End Function[/tt]

and I put [tt]=setImagePath()[/tt] in the On Current event.

I had some problems with a flashing message box; if you have the same problem, let me know. Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[jaslr]

Thanks For you help but it doesn't change the pictures from being icons. That was a good tutorial and easy to follow although when it added my pictures they were all still icons. I am puzzled to why this seemingly 'easy' task is so hard!

 

[jaslr]

No one still knows?

 

[gusbrunston]

[tt]
Why don't you cut and post your code? And...

Are you sure you started out with a default picture? And...

Are you using an image frame, not an unbound or bound OLE frame? And...

I did not test it with a report, only a form. Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[gusbrunston]

[tt]
Let me know if you'd like me to email you a very small database and three image files that will demonstrate the use of the code above.

Written in Access 2000.

Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[jaslr]

Yes Gus I would like you do email me a small database with the examples in it...that'd be great.

email: c3000252@studentmail.newcastle.edu.au

 

[gusbrunston]

[tt]
Hi:

I'm glad you got the files and that they were helpful. Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[NorthNone]

Gus, I've been looking everywhere for what to do about the flashing message box you mentioned in one of your posts above:
"I had some problems with a flashing message box; if you have the same problem, let me know. "
When my put my application on a network drive, sometimes when scrolling through records very quickly, the message box hangs up on the screen. I CANNOT have that in my application, so I've tied my users hands (no mouse wheel, no page up/page down, no record navigation bar).
I'd really prefer to turn off that darned message box instead.
I hope you read this and can help!
TIA
JSouth

---------------------------------------
The customer may not always be right, but the customer is always the customer.

 

[NorthNone]

Gus, I found your other posting, "Hide flashing message box?" and found your answer. I'm distributing this to users outside my immediate office, so I don't want to have to change the registry keys on other machines, so that won't help me in my situation.

---------------------------------------
The customer may not always be right, but the customer is always the customer.