images in continuous forms

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

thanks

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


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

thanks

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?

"Allen Browne" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


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

thanks

.

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" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


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

thanks

.

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 - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"StuJol" wrote in message
...
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" wrote:

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" wrote in message
...
does anyone have a procedure for adding different images per
record in a continuous form view, using a2007.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"StuJol" wrote in message
...
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?

"Allen Browne" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


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

thanks

.

I experimented with some stuff after reading Allen's post and I come up with a solution.

Steps:
1. Saves images to a folder. I've saved my images to a diretory that's in the same directory of the database.

2. have a field in a table with the relative path to the image. e.g. Field Name: ImagePath, Value: image\mypicture.png

3. Create a public function that returns the path of the current project (CurrentProject.Path). I've called mine, GetCurrentPath().

3. On the continuous form create the following controls;
a. bound text box to ImagePath field.
b. unbound text box with the control source as '=GetCurrentPath() & "\" & [ImagePath]'. Name it ImagePathText.
c. unbound image control with the control source equal to the unbound text box. e.g. '=[ImagePathText]'






StuJol wrote:

Allen,Been playing around a little, trying to get vbcode to change the
22-Oct-09

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" wrote:

Previous Posts In This Thread:

On Thursday, October 22, 2009 9:03 AM
StuJol wrote:

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

thanks

On Thursday, October 22, 2009 10:48 AM
Allen Browne wrote:

The Image control has a Control Source in Access 2007.
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

On Thursday, October 22, 2009 12:04 PM
StuJol wrote:

thanks Allen, i've managed to get it working. keep up the good work.
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?

"Allen Browne" wrote:

On Thursday, October 22, 2009 12:46 PM
StuJol wrote:

Allen,Been playing around a little, trying to get vbcode to change the
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" wrote:

On Thursday, October 22, 2009 8:59 PM
Allen Browne wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

On Thursday, October 22, 2009 8:59 PM
Allen Browne wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Sending SMTP email from within BizTalk Orchestration
http://www.eggheadcafe.com/tutorials...il-from-w.aspx