Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Pictures in Access form/report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sharlene - 20 Oct 2006 04:19 GMT
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
was over my head on description and instructions for "New Access User"
section.  I'm still trying to find answer to the rest of my problems. 1.)  I
have the pictures changing with each record but have to enter same info on
some records as I need 3 pictures per client sometimes.  How do I get more
than one picture - when needed- to the same location and on same record,
form, report....??  This is a db for water wells within our territory.  Some
homes will have 1-4 water well at a location but  one with different GPS
location yet client info is same. What do I need to do to get more than one
picture per page if needed?  2) Also I could not get the report section to
show the pictures (per article) since some fields reference the ones set up
on the form.  Would appreciate your help or some type of direction.  If you
need more info please let me know.
Signature

Shar

Bruce Meneghin - 20 Oct 2006 22:08 GMT
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.
Shar - 30 Oct 2006 15:41 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.