ps. code would have to be written to pull the images out of the MDB and save them as files. Then perhaps an ACCDB would have to be used to display them since I'm not sure if MDBs had a web browser control. If folks don't have Access, then Runtime can be used, which could be included in a download for them.
Welcome, Peter
Access can generally only show images if you download them to display them, which defeats the purpose of having them online.
However, there is another way. You can use the web browser control to display a little HTML file that references the image (code can be created to write these for you automatically). I am creating an example for you.
~crystal
On 2/18/2019 9:38 AM, randlov@post9.tele.dk [MS_Access_Professionals] wrote:
I recently joined the group, and have already had good use from some of the discussions.
The Access database I work with contains almost 30,000 images (11GB) of stereoscopic cards from Denmark (the 3D pictures, which were very popular around 1900).
I want the db to be available for a wider audience and have the idea, that the images can be stored on a server (in the cloud?). The users should execute the 10MB db with the MS Access Runtime and the VBA code must find the jpg images on the server.
One of the predefined queries will open a form showing the image with relevant information.
ElseIf Dir(BilledSti) = [LBNR] & ".jpg" Then
Me.Image12.Picture = strSAMLINGdrev & Left([LBNR], 2) & "\" & [LBNR] & ".jpg"
The string strSAMLINGdrev can typically have the value X:\RODS\SAMLING\, where X: is the drive where the images are. LBNR has the format AB1234, so the image shown in the form will e.g. be X:\RODS\SAMLING\AB\AB1234.jpg
Is it possible to replace part of this path with the IP address of a server? Like:
Me.Image12.Picture = "Myhomepage.dk" &"\RODS\" & Left([LBNR], 2) & "\" & [LBNR] & ".jpg"
I "inherited" the registration of the Danish stereo cards in 1996 and converted the information to a MS Access db. I am now 77 years old and have not been able to find a person with interest in Danish stereo cards and skills in Access VBA code to take over, so I hope that placing the db online might make it survive some years more being an important part of Danish cultural history.
Looking forward to your advice.
Peter
It's a mdb file developed in MS Access 2003
Distributed with AccessRuntime2013
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar