By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,775 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,775 IT Pros & Developers. It's quick & easy.

Images on continuous forms

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.