🚀 go-pugleaf

Matt:

Check out the following web pages - they might prove useful to you (especially when it comes to
avoiding the BLOAT problem caused by actually storing images in your tables):

http://www.mvps.org/access/forms/frm0030.htm
http://www.lebans.com/loadjpeggif.htm
... and/or (I'm not sure you need the preceding if you implement the following) ...
http://www.lebans.com/loadsavejpeg.htm

If you still need assistance, just post a reply within this thread (reply to this message, for
example) so we can find it.
--
Bruce M. Thompson, Microsoft Access MVP
bthmpson@big~SPAM_NOT~foot.com
>>No Email, Please. Keep all communications
    within the newsgroups so that all might benefit.<<


"Matt" <matt@slippednospampleasedisk.fsnet.co.uk> wrote in message
news:abbggm$kra$1@news6.svr.pol.co.uk...
> Hi
>
> I am building a database that requires the inclusion of JPEGS into the
> form for the particular table. All the required JPEGS are in one folder
> but I am having snags getting the pics into the form. Each form record
> already has data in it, I am now simply trying to add the pics.
> The pic field is an OLE object, and I am inserting the JPEG by right
> clicking on the relevant  field and choosing insert object, then create from
> file. I the select browse and locate the relevant pic. This pic will insert
> fine. I go to do the next record, and when I select browse, the folder
> containing the pics seems empty, although I know it isn't!
> The only way I can get it to work is by closing the whole database and
> opening it again.
> As I have a lot of records to do, it seems wrong that this is the only way
> to do it, and I must be doing something wrong.
>
> Can anyone please advise me what I am doing wrong and point me in the right
> direction.?
>
> Many thanks in advance
>
> Matt Newman
>
>

Your cross posting is a little excessive.

Check out MS Knowledgebase articles  Q198466, Q158941, Q210100.

Dave

I have the same problem.  I have pictures of all of our products in the
product table.  fields are productID, type, description, picture, price.

The backend (tables only) is about 40MB.  Could I use the same technique you
explain here.  I don't really need the pictures to show up on a form, but I
do need them to show up on a report.


"Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
news:OYEAWvq9BHA.2396@tkmsftngp05...
> Matt:
>
> Check out the following web pages - they might prove useful to you
(especially when it comes to
> avoiding the BLOAT problem caused by actually storing images in your
tables):
>
> http://www.mvps.org/access/forms/frm0030.htm
> http://www.lebans.com/loadjpeggif.htm
> ... and/or (I'm not sure you need the preceding if you implement the
following) ...
> http://www.lebans.com/loadsavejpeg.htm
>
> If you still need assistance, just post a reply within this thread (reply
to this message, for
> example) so we can find it.
> --
> Bruce M. Thompson, Microsoft Access MVP
> bthmpson@big~SPAM_NOT~foot.com
> >>No Email, Please. Keep all communications
>     within the newsgroups so that all might benefit.<<
>
>
> "Matt" <matt@slippednospampleasedisk.fsnet.co.uk> wrote in message
> news:abbggm$kra$1@news6.svr.pol.co.uk...
> > Hi
> >
> > I am building a database that requires the inclusion of JPEGS into the
> > form for the particular table. All the required JPEGS are in one folder
> > but I am having snags getting the pics into the form. Each form record
> > already has data in it, I am now simply trying to add the pics.
> > The pic field is an OLE object, and I am inserting the JPEG by right
> > clicking on the relevant  field and choosing insert object, then create
from
> > file. I the select browse and locate the relevant pic. This pic will
insert
> > fine. I go to do the next record, and when I select browse, the folder
> > containing the pics seems empty, although I know it isn't!
> > The only way I can get it to work is by closing the whole database and
> > opening it again.
> > As I have a lot of records to do, it seems wrong that this is the only
way
> > to do it, and I must be doing something wrong.
> >
> > Can anyone please advise me what I am doing wrong and point me in the
right
> > direction.?
> >
> > Many thanks in advance
> >
> > Matt Newman
> >
> >
>
>
>

OK, I got it to work on the forms.  Now, how do I get the picks to show up
on a report?  Can this be done?


"Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
news:C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com...
> I have the same problem.  I have pictures of all of our products in the
> product table.  fields are productID, type, description, picture, price.
>
> The backend (tables only) is about 40MB.  Could I use the same technique
you
> explain here.  I don't really need the pictures to show up on a form, but
I
> do need them to show up on a report.
>
>
> "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
> news:OYEAWvq9BHA.2396@tkmsftngp05...
> > Matt:
> >
> > Check out the following web pages - they might prove useful to you
> (especially when it comes to
> > avoiding the BLOAT problem caused by actually storing images in your
> tables):
> >
> > http://www.mvps.org/access/forms/frm0030.htm
> > http://www.lebans.com/loadjpeggif.htm
> > ... and/or (I'm not sure you need the preceding if you implement the
> following) ...
> > http://www.lebans.com/loadsavejpeg.htm
> >
> > If you still need assistance, just post a reply within this thread
(reply
> to this message, for
> > example) so we can find it.
> > --
> > Bruce M. Thompson, Microsoft Access MVP
> > bthmpson@big~SPAM_NOT~foot.com
> > >>No Email, Please. Keep all communications
> >     within the newsgroups so that all might benefit.<<
> >
> >
> > "Matt" <matt@slippednospampleasedisk.fsnet.co.uk> wrote in message
> > news:abbggm$kra$1@news6.svr.pol.co.uk...
> > > Hi
> > >
> > > I am building a database that requires the inclusion of JPEGS into the
> > > form for the particular table. All the required JPEGS are in one
folder
> > > but I am having snags getting the pics into the form. Each form record
> > > already has data in it, I am now simply trying to add the pics.
> > > The pic field is an OLE object, and I am inserting the JPEG by right
> > > clicking on the relevant  field and choosing insert object, then
create
> from
> > > file. I the select browse and locate the relevant pic. This pic will
> insert
> > > fine. I go to do the next record, and when I select browse, the folder
> > > containing the pics seems empty, although I know it isn't!
> > > The only way I can get it to work is by closing the whole database and
> > > opening it again.
> > > As I have a lot of records to do, it seems wrong that this is the only
> way
> > > to do it, and I must be doing something wrong.
> > >
> > > Can anyone please advise me what I am doing wrong and point me in the
> right
> > > direction.?
> > >
> > > Many thanks in advance
> > >
> > > Matt Newman
> > >
> > >
> >
> >
> >
>
>
>

You don't say "how" you got it to work in a form, but I presume that you can use the same approach
in your report. You might want to enlighten us on the "how" of your success before I can feel
confident about my presumption, however.
--
Bruce M. Thompson, Microsoft Access MVP
bthmpson@big~SPAM_NOT~foot.com
>>No Email, Please. Keep all communications
    within the newsgroups so that all might benefit.<<

"Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
news:dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com...
> OK, I got it to work on the forms.  Now, how do I get the picks to show up
> on a report?  Can this be done?
>
>
> "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
> news:C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com...
> > I have the same problem.  I have pictures of all of our products in the
> > product table.  fields are productID, type, description, picture, price.
> >
> > The backend (tables only) is about 40MB.  Could I use the same technique
> you
> > explain here.  I don't really need the pictures to show up on a form, but
> I
> > do need them to show up on a report.
> >
> >
> > "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
> > news:OYEAWvq9BHA.2396@tkmsftngp05...
> > > Matt:
> > >
> > > Check out the following web pages - they might prove useful to you
> > (especially when it comes to
> > > avoiding the BLOAT problem caused by actually storing images in your
> > tables):
> > >
> > > http://www.mvps.org/access/forms/frm0030.htm
> > > http://www.lebans.com/loadjpeggif.htm
> > > ... and/or (I'm not sure you need the preceding if you implement the
> > following) ...
> > > http://www.lebans.com/loadsavejpeg.htm
> > >
> > > If you still need assistance, just post a reply within this thread
> (reply
> > to this message, for
> > > example) so we can find it.
> > > --
> > > Bruce M. Thompson, Microsoft Access MVP
> > > bthmpson@big~SPAM_NOT~foot.com
> > > >>No Email, Please. Keep all communications
> > >     within the newsgroups so that all might benefit.<<
> > >
> > >
> > > "Matt" <matt@slippednospampleasedisk.fsnet.co.uk> wrote in message
> > > news:abbggm$kra$1@news6.svr.pol.co.uk...
> > > > Hi
> > > >
> > > > I am building a database that requires the inclusion of JPEGS into the
> > > > form for the particular table. All the required JPEGS are in one
> folder
> > > > but I am having snags getting the pics into the form. Each form record
> > > > already has data in it, I am now simply trying to add the pics.
> > > > The pic field is an OLE object, and I am inserting the JPEG by right
> > > > clicking on the relevant  field and choosing insert object, then
> create
> > from
> > > > file. I the select browse and locate the relevant pic. This pic will
> > insert
> > > > fine. I go to do the next record, and when I select browse, the folder
> > > > containing the pics seems empty, although I know it isn't!
> > > > The only way I can get it to work is by closing the whole database and
> > > > opening it again.
> > > > As I have a lot of records to do, it seems wrong that this is the only
> > way
> > > > to do it, and I must be doing something wrong.
> > > >
> > > > Can anyone please advise me what I am doing wrong and point me in the
> > right
> > > > direction.?
> > > >
> > > > Many thanks in advance
> > > >
> > > > Matt Newman
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>

I found out how to do it on the link in your above response to Matt.


"Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
news:u5lXnZ29BHA.1656@tkmsftngp07...
> You don't say "how" you got it to work in a form, but I presume that you
can use the same approach
> in your report. You might want to enlighten us on the "how" of your
success before I can feel
> confident about my presumption, however.
> --
> Bruce M. Thompson, Microsoft Access MVP
> bthmpson@big~SPAM_NOT~foot.com
> >>No Email, Please. Keep all communications
>     within the newsgroups so that all might benefit.<<
>
> "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
> news:dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com...
> > OK, I got it to work on the forms.  Now, how do I get the picks to show
up
> > on a report?  Can this be done?
> >
> >
> > "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
> > news:C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com...
> > > I have the same problem.  I have pictures of all of our products in
the
> > > product table.  fields are productID, type, description, picture,
price.
> > >
> > > The backend (tables only) is about 40MB.  Could I use the same
technique
> > you
> > > explain here.  I don't really need the pictures to show up on a form,
but
> > I
> > > do need them to show up on a report.
> > >
> > >
> > > "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
> > > news:OYEAWvq9BHA.2396@tkmsftngp05...
> > > > Matt:
> > > >
> > > > Check out the following web pages - they might prove useful to you
> > > (especially when it comes to
> > > > avoiding the BLOAT problem caused by actually storing images in your
> > > tables):
> > > >
> > > > http://www.mvps.org/access/forms/frm0030.htm
> > > > http://www.lebans.com/loadjpeggif.htm
> > > > ... and/or (I'm not sure you need the preceding if you implement the
> > > following) ...
> > > > http://www.lebans.com/loadsavejpeg.htm
> > > >
> > > > If you still need assistance, just post a reply within this thread
> > (reply
> > > to this message, for
> > > > example) so we can find it.
> > > > --
> > > > Bruce M. Thompson, Microsoft Access MVP
> > > > bthmpson@big~SPAM_NOT~foot.com
> > > > >>No Email, Please. Keep all communications
> > > >     within the newsgroups so that all might benefit.<<
> > > >
> > > >
> > > > "Matt" <matt@slippednospampleasedisk.fsnet.co.uk> wrote in message
> > > > news:abbggm$kra$1@news6.svr.pol.co.uk...
> > > > > Hi
> > > > >
> > > > > I am building a database that requires the inclusion of JPEGS into
the
> > > > > form for the particular table. All the required JPEGS are in one
> > folder
> > > > > but I am having snags getting the pics into the form. Each form
record
> > > > > already has data in it, I am now simply trying to add the pics.
> > > > > The pic field is an OLE object, and I am inserting the JPEG by
right
> > > > > clicking on the relevant  field and choosing insert object, then
> > create
> > > from
> > > > > file. I the select browse and locate the relevant pic. This pic
will
> > > insert
> > > > > fine. I go to do the next record, and when I select browse, the
folder
> > > > > containing the pics seems empty, although I know it isn't!
> > > > > The only way I can get it to work is by closing the whole database
and
> > > > > opening it again.
> > > > > As I have a lot of records to do, it seems wrong that this is the
only
> > > way
> > > > > to do it, and I must be doing something wrong.
> > > > >
> > > > > Can anyone please advise me what I am doing wrong and point me in
the
> > > right
> > > > > direction.?
> > > > >
> > > > > Many thanks in advance
> > > > >
> > > > > Matt Newman
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
>

<chuckle>

I supplied 3 links in my response to Matt. They represent at least 2 different solutions.

Which link is it that worked for you?

Could you provide any details on what you did to implement the method provided via the link that
worked for you?

(These questions are not just to allow others, and myself, to understand how to approach helping you
make this work, but they are also to provide a clearer explanation of the problem and of what the
final solution might be for those who are having similar problems.)
--
Bruce M. Thompson, Microsoft Access MVP
bthmpson@big~SPAM_NOT~foot.com
>>No Email, Please. Keep all communications
    within the newsgroups so that all might benefit.<<


"Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
news:f2wC8.143604$Lj.11383922@bin4.nnrp.aus1.giganews.com...
> I found out how to do it on the link in your above response to Matt.
>
>
> "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
> news:u5lXnZ29BHA.1656@tkmsftngp07...
> > You don't say "how" you got it to work in a form, but I presume that you
> can use the same approach
> > in your report. You might want to enlighten us on the "how" of your
> success before I can feel
> > confident about my presumption, however.
> > --
> > Bruce M. Thompson, Microsoft Access MVP
> > bthmpson@big~SPAM_NOT~foot.com
> > >>No Email, Please. Keep all communications
> >     within the newsgroups so that all might benefit.<<
> >
> > "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
> > news:dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com...
> > > OK, I got it to work on the forms.  Now, how do I get the picks to show
> up
> > > on a report?  Can this be done?
> > >
> > >
> > > "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
> > > news:C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com...
> > > > I have the same problem.  I have pictures of all of our products in
> the
> > > > product table.  fields are productID, type, description, picture,
> price.
> > > >
> > > > The backend (tables only) is about 40MB.  Could I use the same
> technique
> > > you
> > > > explain here.  I don't really need the pictures to show up on a form,
> but
> > > I
> > > > do need them to show up on a report.
> > > >
> > > >
> > > > "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
> > > > news:OYEAWvq9BHA.2396@tkmsftngp05...
> > > > > Matt:
> > > > >
> > > > > Check out the following web pages - they might prove useful to you
> > > > (especially when it comes to
> > > > > avoiding the BLOAT problem caused by actually storing images in your
> > > > tables):
> > > > >
> > > > > http://www.mvps.org/access/forms/frm0030.htm
> > > > > http://www.lebans.com/loadjpeggif.htm
> > > > > ... and/or (I'm not sure you need the preceding if you implement the
> > > > following) ...
> > > > > http://www.lebans.com/loadsavejpeg.htm
> > > > >
> > > > > If you still need assistance, just post a reply within this thread
> > > (reply
> > > > to this message, for
> > > > > example) so we can find it.
> > > > > --
> > > > > Bruce M. Thompson, Microsoft Access MVP
> > > > > bthmpson@big~SPAM_NOT~foot.com
> > > > > >>No Email, Please. Keep all communications
> > > > >     within the newsgroups so that all might benefit.<<
> > > > >
> > > > >
> > > > > "Matt" <matt@slippednospampleasedisk.fsnet.co.uk> wrote in message
> > > > > news:abbggm$kra$1@news6.svr.pol.co.uk...
> > > > > > Hi
> > > > > >
> > > > > > I am building a database that requires the inclusion of JPEGS into
> the
> > > > > > form for the particular table. All the required JPEGS are in one
> > > folder
> > > > > > but I am having snags getting the pics into the form. Each form
> record
> > > > > > already has data in it, I am now simply trying to add the pics.
> > > > > > The pic field is an OLE object, and I am inserting the JPEG by
> right
> > > > > > clicking on the relevant  field and choosing insert object, then
> > > create
> > > > from
> > > > > > file. I the select browse and locate the relevant pic. This pic
> will
> > > > insert
> > > > > > fine. I go to do the next record, and when I select browse, the
> folder
> > > > > > containing the pics seems empty, although I know it isn't!
> > > > > > The only way I can get it to work is by closing the whole database
> and
> > > > > > opening it again.
> > > > > > As I have a lot of records to do, it seems wrong that this is the
> only
> > > > way
> > > > > > to do it, and I must be doing something wrong.
> > > > > >
> > > > > > Can anyone please advise me what I am doing wrong and point me in
> the
> > > > right
> > > > > > direction.?
> > > > > >
> > > > > > Many thanks in advance
> > > > > >
> > > > > > Matt Newman
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

I used the first link.  It was the one for Q148463


"Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
news:eNhNey29BHA.1012@tkmsftngp04...
> <chuckle>
>
> I supplied 3 links in my response to Matt. They represent at least 2
different solutions.
>
> Which link is it that worked for you?
>
> Could you provide any details on what you did to implement the method
provided via the link that
> worked for you?
>
> (These questions are not just to allow others, and myself, to understand
how to approach helping you
> make this work, but they are also to provide a clearer explanation of the
problem and of what the
> final solution might be for those who are having similar problems.)
> --
> Bruce M. Thompson, Microsoft Access MVP
> bthmpson@big~SPAM_NOT~foot.com
> >>No Email, Please. Keep all communications
>     within the newsgroups so that all might benefit.<<
>
>
> "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
> news:f2wC8.143604$Lj.11383922@bin4.nnrp.aus1.giganews.com...
> > I found out how to do it on the link in your above response to Matt.
> >
> >
> > "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
> > news:u5lXnZ29BHA.1656@tkmsftngp07...
> > > You don't say "how" you got it to work in a form, but I presume that
you
> > can use the same approach
> > > in your report. You might want to enlighten us on the "how" of your
> > success before I can feel
> > > confident about my presumption, however.
> > > --
> > > Bruce M. Thompson, Microsoft Access MVP
> > > bthmpson@big~SPAM_NOT~foot.com
> > > >>No Email, Please. Keep all communications
> > >     within the newsgroups so that all might benefit.<<
> > >
> > > "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in
message
> > > news:dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com...
> > > > OK, I got it to work on the forms.  Now, how do I get the picks to
show
> > up
> > > > on a report?  Can this be done?
> > > >
> > > >
> > > > "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in
message
> > > > news:C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com...
> > > > > I have the same problem.  I have pictures of all of our products
in
> > the
> > > > > product table.  fields are productID, type, description, picture,
> > price.
> > > > >
> > > > > The backend (tables only) is about 40MB.  Could I use the same
> > technique
> > > > you
> > > > > explain here.  I don't really need the pictures to show up on a
form,
> > but
> > > > I
> > > > > do need them to show up on a report.
> > > > >
> > > > >
> > > > > "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in
message
> > > > > news:OYEAWvq9BHA.2396@tkmsftngp05...
> > > > > > Matt:
> > > > > >
> > > > > > Check out the following web pages - they might prove useful to
you
> > > > > (especially when it comes to
> > > > > > avoiding the BLOAT problem caused by actually storing images in
your
> > > > > tables):
> > > > > >
> > > > > > http://www.mvps.org/access/forms/frm0030.htm
> > > > > > http://www.lebans.com/loadjpeggif.htm
> > > > > > ... and/or (I'm not sure you need the preceding if you implement
the
> > > > > following) ...
> > > > > > http://www.lebans.com/loadsavejpeg.htm
> > > > > >
> > > > > > If you still need assistance, just post a reply within this
thread
> > > > (reply
> > > > > to this message, for
> > > > > > example) so we can find it.
> > > > > > --
> > > > > > Bruce M. Thompson, Microsoft Access MVP
> > > > > > bthmpson@big~SPAM_NOT~foot.com
> > > > > > >>No Email, Please. Keep all communications
> > > > > >     within the newsgroups so that all might benefit.<<
> > > > > >
> > > > > >
> > > > > > "Matt" <matt@slippednospampleasedisk.fsnet.co.uk> wrote in
message
> > > > > > news:abbggm$kra$1@news6.svr.pol.co.uk...
> > > > > > > Hi
> > > > > > >
> > > > > > > I am building a database that requires the inclusion of JPEGS
into
> > the
> > > > > > > form for the particular table. All the required JPEGS are in
one
> > > > folder
> > > > > > > but I am having snags getting the pics into the form. Each
form
> > record
> > > > > > > already has data in it, I am now simply trying to add the
pics.
> > > > > > > The pic field is an OLE object, and I am inserting the JPEG by
> > right
> > > > > > > clicking on the relevant  field and choosing insert object,
then
> > > > create
> > > > > from
> > > > > > > file. I the select browse and locate the relevant pic. This
pic
> > will
> > > > > insert
> > > > > > > fine. I go to do the next record, and when I select browse,
the
> > folder
> > > > > > > containing the pics seems empty, although I know it isn't!
> > > > > > > The only way I can get it to work is by closing the whole
database
> > and
> > > > > > > opening it again.
> > > > > > > As I have a lot of records to do, it seems wrong that this is
the
> > only
> > > > > way
> > > > > > > to do it, and I must be doing something wrong.
> > > > > > >
> > > > > > > Can anyone please advise me what I am doing wrong and point me
in
> > the
> > > > > right
> > > > > > > direction.?
> > > > > > >
> > > > > > > Many thanks in advance
> > > > > > >
> > > > > > > Matt Newman
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
>

Okay. In the report, in place of the form's "OnCurrent" event procedure to set the image control's
"Picture" property, you would use the "OnFormat" event procedure for the section of the report that
contains the image control:

'*********************START EXAMPLE
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

      'Set the Picture property of the image control
    Me![ImageFrame].Picture = Me![ImagePath]

      'If no image path or typo in same, hide image control so wrong image won't show
      '  Disable error handling, first, in case typo in image path value
    On Error Resume Next
    Me![ImageFrame].Visible = (Len("" & Me.ImagePath.Value) > 0) _
                                And Dir$("" & Me.ImagePath.Value) <> ""

      'Re-enable error handling
    On Error Goto ...

End Sub
'**********************END EXAMPLE

"Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
news:OpxC8.109288$q8.11508423@bin3.nnrp.aus1.giganews.com...
> I used the first link.  It was the one for Q148463
<snip>

thanks for the help.


"Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
news:OTXFT049BHA.1828@tkmsftngp05...
> Okay. In the report, in place of the form's "OnCurrent" event procedure to
set the image control's
> "Picture" property, you would use the "OnFormat" event procedure for the
section of the report that
> contains the image control:
>
> '*********************START EXAMPLE
> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
>
>       'Set the Picture property of the image control
>     Me![ImageFrame].Picture = Me![ImagePath]
>
>       'If no image path or typo in same, hide image control so wrong image
won't show
>       '  Disable error handling, first, in case typo in image path value
>     On Error Resume Next
>     Me![ImageFrame].Visible = (Len("" & Me.ImagePath.Value) > 0) _
>                                 And Dir$("" & Me.ImagePath.Value) <> ""
>
>       'Re-enable error handling
>     On Error Goto ...
>
> End Sub
> '**********************END EXAMPLE
>
> "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
> news:OpxC8.109288$q8.11508423@bin3.nnrp.aus1.giganews.com...
> > I used the first link.  It was the one for Q148463
> <snip>
>
>
>

Thanks to all who posted possible solutions. I have tried most of them, and
have succeeded in a separate table with the images. I tried to have the
images in the form but not the table, but got bogged down with the
properties.
All I need do now I imagine is link the pics to their relevant details.
I am going to be building a web site to link to this database, using
ultradev. Has anyone any tips before I embark on that? It will include a
shopping basket!

Many thanks again

Matt
"Matt" <matt@slippednospampleasedisk.fsnet.co.uk> wrote in message
news:abbggm$kra$1@news6.svr.pol.co.uk...
> Hi
>
> I am building a database that requires the inclusion of JPEGS into the
> form for the particular table. All the required JPEGS are in one folder
> but I am having snags getting the pics into the form. Each form record
> already has data in it, I am now simply trying to add the pics.
> The pic field is an OLE object, and I am inserting the JPEG by right
> clicking on the relevant  field and choosing insert object, then create
from
> file. I the select browse and locate the relevant pic. This pic will
insert
> fine. I go to do the next record, and when I select browse, the folder
> containing the pics seems empty, although I know it isn't!
> The only way I can get it to work is by closing the whole database and
> opening it again.
> As I have a lot of records to do, it seems wrong that this is the only way
> to do it, and I must be doing something wrong.
>
> Can anyone please advise me what I am doing wrong and point me in the
right
> direction.?
>
> Many thanks in advance
>
> Matt Newman
>
>

Perhaps my example database illustrating three approaches to handling images
in Access would be of some use. You can download either an Access 97 or an
Access 2000 version from http://members.tripod.com/accdevel. Both downloads
include an article and some sample JPG images.

As has been suggested, you simply need to use Report events that correspond
to the form events. Stephen Lebans recently informed us that using the
OnPrint event rather than the OnFormat event has been suggested by
Microsoft's tech support to alleviate running out of memory or system
resources when printing images.

--
Larry Linson
   http://www.ntpcug.org -- North Texas PC User Group
   http://members.tripod.com/ntaccess -- Access SIG
   http://members.tripod.com/accdevel -- Access Samples and Examples