I am using Access 2016.
I am trying to include images in a database but cannot see how to do it. I have had a look in the forum and can see that the question has been raised many times in the past, but the questions either do not deal with my problem or contain solutions in VBA or SQL which are beyond me.
What I am trying to do is design a database dealing with operas. Part of this requires a form and a report which would, for each person on a list of singers, show a CV and a picture. I do not want the picture files to be in the database as it would slow everything down and probably exceed the 2GB limit on the database.
There is a video on youtube by a man called Richard Rost headed " Display images in Microsoft Access Forms and Reports" which is exactly what I am trying to do. It tells me to create a new form, use a text field to show the path to the pictures and set the control source from the image button to this field. I have done all this but cannot see any pictures coming up when I look at the form. I have done this several times setting up new test databases to do so but still cannot see pictures.
I cannot understand why it works for him and not for me. I suspect the only diiference between us is that I am running Windows 10 on an Imac through a virtual machine, but I cannot see how this would make any difference as I have checked the file path carefully.
I do not understand why this should be difficult to achieve. I can see that the position was different for Access 1997 and earlier as it only dealt with OLE but the facility for doing what I want to do seems to have been built into Access 2016.
I assume that I am just doing something very silly. Can anyone tell me what it is? Alternatively, if this bit of Access is flakey, is there another way of doing this without having to write code?
Phrygian
I am trying to include images in a database but cannot see how to do it. I have had a look in the forum and can see that the question has been raised many times in the past, but the questions either do not deal with my problem or contain solutions in VBA or SQL which are beyond me.
What I am trying to do is design a database dealing with operas. Part of this requires a form and a report which would, for each person on a list of singers, show a CV and a picture. I do not want the picture files to be in the database as it would slow everything down and probably exceed the 2GB limit on the database.
There is a video on youtube by a man called Richard Rost headed " Display images in Microsoft Access Forms and Reports" which is exactly what I am trying to do. It tells me to create a new form, use a text field to show the path to the pictures and set the control source from the image button to this field. I have done all this but cannot see any pictures coming up when I look at the form. I have done this several times setting up new test databases to do so but still cannot see pictures.
I cannot understand why it works for him and not for me. I suspect the only diiference between us is that I am running Windows 10 on an Imac through a virtual machine, but I cannot see how this would make any difference as I have checked the file path carefully.
I do not understand why this should be difficult to achieve. I can see that the position was different for Access 1997 and earlier as it only dealt with OLE but the facility for doing what I want to do seems to have been built into Access 2016.
I assume that I am just doing something very silly. Can anyone tell me what it is? Alternatively, if this bit of Access is flakey, is there another way of doing this without having to write code?
Phrygian