|
| 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
February 23rd, 2009, 11:07 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Show multiple photos (detail) for each user (master) on a form/sub
I wish to develop an access 2003 db which needs to allocate multiple
photographs - each with a selectable category - to individual users in a master/detail scenario. I wish to link to - not embed - each jpeg file and have tried using the image control on sub form. But, as I have now discovered with Access, as soon as I assign a picture to this control, all the records on the subform show the same (current) picture. Is there a clean solution to this scenario without having to embed each photo, as their numbers will be significant? Many thanks. 
|
|
#2
February 23rd, 2009, 11:47 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Show multiple photos (detail) for each user (master) on a form/sub
The simplest solution will be to upgrade to Access 2007.
In the new version, the image conrtrol has a Control Source property. You can therefore use the path to the linked JPG as the Control Source of the image control, and it will show correctly in a continuous form. More info on how to adapt to the new version: http://allenbrowne.com/Access2007.html -- 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. "Pete" wrote in message ... I wish to develop an access 2003 db which needs to allocate multiple photographs - each with a selectable category - to individual users in a master/detail scenario. I wish to link to - not embed - each jpeg file and have tried using the image control on sub form. But, as I have now discovered with Access, as soon as I assign a picture to this control, all the records on the subform show the same (current) picture. Is there a clean solution to this scenario without having to embed each photo, as their numbers will be significant? Many thanks.
|
|
#3
February 23rd, 2009, 12:17 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Show multiple photos (detail) for each user (master) on a form
Thanks Allen,
Given that an upgrade is not an option at this time, is there any way around this in Access 2003? Many thanks. "Allen Browne" wrote: The simplest solution will be to upgrade to Access 2007. In the new version, the image conrtrol has a Control Source property. You can therefore use the path to the linked JPG as the Control Source of the image control, and it will show correctly in a continuous form. More info on how to adapt to the new version: http://allenbrowne.com/Access2007.html -- 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. "Pete" wrote in message ... I wish to develop an access 2003 db which needs to allocate multiple photographs - each with a selectable category - to individual users in a master/detail scenario. I wish to link to - not embed - each jpeg file and have tried using the image control on sub form. But, as I have now discovered with Access, as soon as I assign a picture to this control, all the records on the subform show the same (current) picture. Is there a clean solution to this scenario without having to embed each photo, as their numbers will be significant? Many thanks.
|
|
#4
February 23rd, 2009, 02:41 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Show multiple photos (detail) for each user (master) on a form
Not sure what others to suggest.
Stephen Lebans may have something: http://www.lebans.com/toc.htm -- 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. "Pete" wrote in message ... Thanks Allen, Given that an upgrade is not an option at this time, is there any way around this in Access 2003? Many thanks. "Allen Browne" wrote: The simplest solution will be to upgrade to Access 2007.
|
|
#5
February 23rd, 2009, 04:28 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Show multiple photos (detail) for each user (master) on a form
Couldn't find anything in a Master/Detail setup.
Could I Create an instance of a form (one for each photo) for each record on the subform? Or would that just show the same image on each detail record as the Image control does? Thanks. "Allen Browne" wrote: Not sure what others to suggest. Stephen Lebans may have something: http://www.lebans.com/toc.htm -- 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. "Pete" wrote in message ... Thanks Allen, Given that an upgrade is not an option at this time, is there any way around this in Access 2003? Many thanks. "Allen Browne" wrote: The simplest solution will be to upgrade to Access 2007.
|
|
#6
February 23rd, 2009, 11:06 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Show multiple photos (detail) for each user (master) on a form
You could use multiple instances of the form, so each has one currrent
record. There are 3rd party controls you can buy. Unless someone else's policy is preventing you from upgrading, moving to A2007 would be by far the easiest. -- 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. "Pete" wrote in message ... Couldn't find anything in a Master/Detail setup. Could I Create an instance of a form (one for each photo) for each record on the subform? Or would that just show the same image on each detail record as the Image control does? Thanks. "Allen Browne" wrote: Not sure what others to suggest. Stephen Lebans may have something: http://www.lebans.com/toc.htm -- 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. "Pete" wrote in message ... Thanks Allen, Given that an upgrade is not an option at this time, is there any way around this in Access 2003? Many thanks. "Allen Browne" wrote: The simplest solution will be to upgrade to Access 2007.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
