image in report in access

[kojo88]

Hi there i got recommended to this site by a mate who is doing an A-level project, as am I! i was wondering if anyone knows a simple way of putting a picture box in a report which displays the contents of a text book with the file path i.e i want the picture box to display

CurrentProject.Path & txtImageLocation

i have tried and tried to get this to work but for some reason im not given many options with an image box in a report, I dont understand unboun/ bound objects and am not sure whether this can help!!

thanks in advance for any help

johnny ward

[ADezii]

Hi there i got recommended to this site by a mate who is doing an A-level project, as am I! i was wondering if anyone knows a simple way of putting a picture box in a report which displays the contents of a text book with the file path i.e i want the picture box to display

CurrentProject.Path & txtImageLocation

i have tried and tried to get this to work but for some reason im not given many options with an image box in a report, I dont understand unboun/ bound objects and am not sure whether this can help!!

thanks in advance for any help

johnny ward

In the Open Event of your Report:

Private Sub Report_Open(Cancel As Integer)
  Me![imgTest].Picture = "C:\Test\Test.bmp"
End Sub

NOTE: CurrentProject.Path does not return the trailing backslash, you may have to add it to your Path e.g.
C:\Documents and Settings\security\My Documents

[kojo88]

In the Open Event of your Report:

Private Sub Report_Open(Cancel As Integer)
  Me![imgTest].Picture = "C:\Test\Test.bmp"
End Sub

NOTE: CurrentProject.Path does not return the trailing backslash, you may have to add it to your Path e.g.
C:\Documents and Settings\security\My Documents

I now have a run-time error 2427 and message:"You entered an expression that has no value"

HELP!!!

[Rabbit]

Did you change [imgtest] to the name of your control?

[kojo88]

yes i changed it to picImage which is my image box

[Rabbit]

Try:

Me!Image1.Properties("Picture") = "C:\Test\Test.bmp"

[kojo88]

im getting same error!!!:(

somehow i think reports dont like picture boxes and stuff cos it wont give me functionality with command buttons either

[Rabbit]

That's weird cause I tried it and it works for me.

[NeoPa]

im getting same error!!!:(

somehow i think reports dont like picture boxes and stuff cos it wont give me functionality with command buttons either

Did you change the file reference to refer to your picture? And how?
Can you post the code you're actually using.

[kojo88]

    picImage.Visible = True
    picImage.Picture = CurrentProject.Path & txtImageLocation
    cmdShowImage.Caption = "Hide Image"
 

this is my code for how it works in a form, so why cant this work in a report?

[NeoPa]

The request for the code was only the second sentence :(
If you ignore the questions of the experts here, how do you expect us to help you?

[NeoPa]

I did notice in your code, though, that you don't add a '\' after the Path. The Path does NOT include a trailing '\' so this may be your problem (or maybe just one of them).

picImage.Picture = CurrentProject.Path & txtImageLocation

[kojo88]

thanks for your help, sorry it takes long to reply i am at college near enough 24/7 studying etc., so its difficult to get a spare minute to check up on the many forums i use

[NeoPa]

No problem Kojo.
As it's a forum, we don't expect immediate responses. Any time you post we can see that and respond appropriately.
Pleased to hear it's helped anyway :)