I'm assuming that if a client has 3 wells then there are three records, each
with the client ID and a different picture.
If this is so, then you should be able to create a Report, group by client,
and place the photos in the Details section of the report. The client name
would be placed in the Group section. you can set a page break on groups
Does this help?
> I have finally figured out the instructions from support.microsoft.com on the
> article ID 210100 from Aug. 11, 2005. Looked all over this site but everyone
[quoted text clipped - 10 lines]
> on the form. Would appreciate your help or some type of direction. If you
> need more info please let me know.
Shar - 23 Oct 2006 21:09 GMT
Not sure, Right now when I go to my imput form, I have and image box next to
the imput information. I was trying to put 3 images on that form and only
when there are three would all show. May Boss was wanting everything on one
page. Then later she want all on CD.
Also new problem when I prent a report the picture will not print Image area
is blank. I've tried embedding the picture (not really wanting embedded) but
still will not print w/ picture on form.
Also would like to get away from typing path "C:\Documents and Settings
Sharlene\My Documents\My Pictures\SFN Water Wells\p.7403756" or what ever
picture is associated with the Last Name of the report. Did have ID # set
to Auto but other person in Office (who does know more of Access than me)
said not to do it that way. But she has no answers on this.
Everything looks good on the report and the input form not sure what to do
to get this to work correctly.
Here is what I done:
Table: tblImage
-------------------------
Field Name: ImageId
Data Type: AutoNumber (was told to change to number)
Indexed: Yes (No Duplicates)
Field Name: txtImageName
Data Type: Text
Table Properties: tblImage
------------------------------------
I created a "NoPicture.BMP" file stored it at C:\Windows\NoPicture.bmp
------------------------------------------------------------------------------------------
Form: firmImage
-------------------------
Caption: Image Form
RecordSource: tblImage
Image Control
----------------------
Name: ImageFrame
Picture: 'C:\Documents and Settings\Sharlene\My Documents\My Pictures\SFN
Water Wells\p7403756"
Text Box
-----------------
Name: txtImageID
ControlSource: ImageID
Text Box
----------------
Name: txtImageName
Control Source: ImageName (column in tables for the "C:\ " crap)
"Code"
Function setImagePath()
Dim strImagePath As String
On Error Goto PictureNotAvailable
strImagePath = Me.txtImageName
Me.ImageFrame.Picture = strImagePath
Exit Function
PictureNotAvailable:
strImagePath = "C:\Windows\NoPicture.BMP"
Me.ImageFrame.Picture = StrImagePath
End Function
I set OnCurrent and AfterUpdate events to =setImagePath()
until I entered the above line picture stayed the same throughout each
record. It just took for ever to find the section "OnCurrent and
AfterUpdate".
I really do appreciate all the help from this website. Still stuped on a
lot of it even after two courses thru the Tec colleges here. Thank You so
very much on the help.
> I'm assuming that if a client has 3 wells then there are three records, each
> with the client ID and a different picture.
[quoted text clipped - 19 lines]
> > on the form. Would appreciate your help or some type of direction. If you
> > need more info please let me know.
Shar - 24 Oct 2006 14:36 GMT
Bruce, I guess I did not answer your question to well. I was trying to get
away from so many records for one client. That is what I have to do now with
each having a picture - different angles of the same well. If a client has 3
well all iformation is the same only the pictures are different, the reason
is probably for water elsewhere on the property for cattle or the old well
ran out of water. On occasion there is only one well location different (GPS
Coordinates) then I can see having a seperate record. I forgot to mention
after the picture number I also enter .jpg since that is the type of pictures
I have.
> Not sure, Right now when I go to my imput form, I have and image box next to
> the imput information. I was trying to put 3 images on that form and only
[quoted text clipped - 94 lines]
> > > on the form. Would appreciate your help or some type of direction. If you
> > > need more info please let me know.
Would someone please give me some direction as how I can get the photos to
print on my report. I have search elsewhere on this site and found some
references but do not quite understand them. Please Help.
> I have finally figured out the instructions from support.microsoft.com on the
> article ID 210100 from Aug. 11, 2005. Looked all over this site but everyone
[quoted text clipped - 10 lines]
> on the form. Would appreciate your help or some type of direction. If you
> need more info please let me know.