N
n00bster
I'm fairly new to Access and was placed in charge of creating a Access DB for
members of a student association.
Its fairly basic with all the needed information stored on 1 table with a
unique key referenced to the Student unique number that they are registered
as within the university.
I'm trying to create a report that displays current members within the
organization which is fairly easy however I am unable to display their mug
shot.
The university stores a photo of each student and assigns then a unique
number to which they use for all computer related issues at school such as
log on, email addresses etc. This is really convenient as their photos are
stored and viewable by the web by just changing the student number you wish
to view.
Is there a simple and easy way to make access display each member of the
student association within my database picture from the internet?
e.g.
Richard = 22102
Bob = 22108
The link to view their portraits would be as follows:
http://universityphotos/studentpictures/22102.jpg = Richard
http://universityphotos/studentpictures/22108.jpg = Bob
The unique number are already stored within my database but I am unable to
find a simple way for access to simply display their picture within the
report from the URL.
Any help, guide or directions on where I can find a solution would be much
appreciated.
Thanks in advance.
P.S. The URL provided here are just made up for the sake of this example to
clearly explain my problem.
members of a student association.
Its fairly basic with all the needed information stored on 1 table with a
unique key referenced to the Student unique number that they are registered
as within the university.
I'm trying to create a report that displays current members within the
organization which is fairly easy however I am unable to display their mug
shot.
The university stores a photo of each student and assigns then a unique
number to which they use for all computer related issues at school such as
log on, email addresses etc. This is really convenient as their photos are
stored and viewable by the web by just changing the student number you wish
to view.
Is there a simple and easy way to make access display each member of the
student association within my database picture from the internet?
e.g.
Richard = 22102
Bob = 22108
The link to view their portraits would be as follows:
http://universityphotos/studentpictures/22102.jpg = Richard
http://universityphotos/studentpictures/22108.jpg = Bob
The unique number are already stored within my database but I am unable to
find a simple way for access to simply display their picture within the
report from the URL.
Any help, guide or directions on where I can find a solution would be much
appreciated.
Thanks in advance.
P.S. The URL provided here are just made up for the sake of this example to
clearly explain my problem.