If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
images in continuous forms
does anyone have a procedure for adding different images per record in a
continuous form view, using a2007. thanks |
#2
|
|||
|
|||
images in continuous forms
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 |
#3
|
|||
|
|||
images in continuous forms
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 . |
#4
|
|||
|
|||
images in continuous forms
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 . |
#5
|
|||
|
|||
images in continuous forms
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. |
#6
|
|||
|
|||
images in continuous forms
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 . |
#7
|
|||
|
|||
Using vba code to change the image in continuous form
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 |
Thread Tools | |
Display Modes | |
|
|