467,169 Members | 956 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,169 developers. It's quick & easy.

Images on continuous forms

Is it possible to display different images on continuous forms. The path to
the picture is held in a table, and the photos are held in another folder. I
am trying to avoid using OLE Object due to file size problems and problems
of making sure the database is up-to-date.

Thanks

Phil
Aug 22 '06 #1
  • viewed: 2256
Share:
2 Replies
Phil Stanton wrote:
Is it possible to display different images on continuous forms. The path to
the picture is held in a table, and the photos are held in another folder. I
am trying to avoid using OLE Object due to file size problems and problems
of making sure the database is up-to-date.
I've done this not by using Access continuous forms but instead setting up my own unbound
set of controls and writing code to do all record navigation and display/modification.

Set up the necessary controls to display the maximum number of rows and then hide the rows
you don't need. Add buttons to move through the records. Of course, that's a gross
simplification.

Requires lots of coding but is limited only by your imagination. No embedded objects
required; use only path/file references with error coding (as you outlined). The point is
that if you are willing to invest the time in coding you can achieve your goal using just VBA.
--
'---------------
'John Mishefske
'---------------
Aug 23 '06 #2
Sounds a very interesting approach.

I would be eternally grateful if you could send me something to have a look
at. It would save me the time of re-inventing the wheel.

Phil
"John Mishefske" <jm**********@SPAMyahoo.comwrote in message
news:b2*******************@tornado.rdc-kc.rr.com...
Phil Stanton wrote:
>Is it possible to display different images on continuous forms. The path
to the picture is held in a table, and the photos are held in another
folder. I am trying to avoid using OLE Object due to file size problems
and problems of making sure the database is up-to-date.

I've done this not by using Access continuous forms but instead setting up
my own unbound set of controls and writing code to do all record
navigation and display/modification.

Set up the necessary controls to display the maximum number of rows and
then hide the rows you don't need. Add buttons to move through the
records. Of course, that's a gross simplification.

Requires lots of coding but is limited only by your imagination. No
embedded objects required; use only path/file references with error coding
(as you outlined). The point is that if you are willing to invest the time
in coding you can achieve your goal using just VBA.
--
'---------------
'John Mishefske
'---------------

Aug 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Lauren Quantrell | last post: by
2 posts views Thread by panwala_bhavesh@yahoo.com | last post: by
1 post views Thread by blueheelers@gmail.com | last post: by
8 posts views Thread by Steffen Beck | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.