Phil Stanton wrote:
Quote:
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
'---------------
