images in continuous forms

[StuJol]

does anyone have a procedure for adding different images per record in a
continuous form view, using a2007.

thanks

 

[Allen Browne]

The Image control has a Control Source in Access 2007.

So, if you have the fully qualified file name in a field, just set the
Control Source of your image control to this field. No code needed.

 

[StuJol]

thanks Allen, i've managed to get it working. keep up the good work.

Do you also know of any good writeups on preparing a a2007 database to be
distrubuted to other people. eg security measures to take? or is it just the
same as a2003?

 

[StuJol]

Allen,

Been playing around a little, trying to get vbcode to change the filename of
the image depending on certain values. i've tried a few methods but keep
getting error, 'you cant assign a value to this object'. is this something to
do with it being a continuous form??

im trying to acheive, i have a continuous form with a date field. if the
date field is less then the current date, then display a warning symbol on
the row.

i can manual enter the file path in my table but would prefer to do it using
code.

 

[Allen Browne]

Can't recall if I tried using code with the image control in a continuous
form, since it's not needed. Presumably you are using Form_Current.

 

[Allen Browne]

Security? You can still use an MDW with an MDB, but not with an ACCDB.