Kamis, 21 Februari 2019

Re: [MS_AccessPros] Placing 30,000 images on a server

 

you're welcome, Peter! ~ happy to help

have an awesome day,
crystal

On 2/21/2019 9:47 AM, Peter Randløv randlov@post9.tele.dk [MS_Access_Professionals] wrote:
Thank you, Crystal ,for your messages and samples.
1. Now I know it is possible to do exactly what I want and
2. The code is relative simple, so even with my limited capabilities in VBA coding I think I can make it work (trail and error method).

And Dave,
I also use Access 2003 for development, and I even bought an expensive license from Microsoft for the 2003 runtime version, but distribution and installation was very complicated, so many persons gave up.
Now i distribute the database on an usb-stick with the free Access 2013 runtime (available in Danish), and I have a full version of Access 2013 in order to be sure that the mdb-file is forward compatible.
Crystal's files work fine in Access 2013, and I can see all what I need.
Peter


Den 21-02-2019 kl. 13:41 skrev Dave Williams davewillgmale@gmail.com [MS_Access_Professionals]:
 

Crystal,

It's not my problem - I was just interested in randlov's post, and
thought your example might be useful to me in the future, especially as
you told me that my preferred Access 2003 does not have the capability
but Access 2010 does. Thanks again for your example which is all I need
to know.

Dave W

On 21/02/2019 01:22, crystal 8 strive4peace2008@yahoo.com
[MS_Access_Professionals] wrote:
>
> you're welcome, Dave
>
> the next step would be to save the images from the database as files. If
> you upload a sample with a couple images, I can see what code can work..
>
> ~crystal
>
> On 2/20/2019 5:52 PM, Dave Williams davewillgmale@gmail.com
> [MS_Access_Professionals] wrote:
> > Thank you Crystal, Access 2010 opens it OK.
> > Regards,
> > Dave W
> >
> >
> > On 20/02/2019 16:28, crystal 8 strive4peace2008@yahoo.com
> > [MS_Access_Professionals] wrote:
> >> You should be able to open it with 2010. Access 2003 didn't have a web
> >> browser control.
> >>
> >> If folks don't have Access, then Runtime can be used, which could be
> >> included in a download for them.
> >>
> >> On 2/20/2019 5:43 AM, Dave Williams davewillgmale@gmail.com
> >> [MS_Access_Professionals] wrote:
> >>> What version of Access is that? I can't open it with Access 2003, like
> >>> the OP has. Can Access 2010 open it?
> >>> Regards,
> >>> Dave W
> >>>
> >>> On 18/02/2019 18:43, crystal 8 strive4peace2008@yahoo.com
> >>> [MS_Access_Professionals] wrote:
> >>>> Hi Peter,
> >>>>
> >>>> I put an example database showing how to display an image from
> the web
> >>>> using Access here:
> >>>>
> >>>> http://www.msaccessgurus.com/Downloads/WebBrowser_ImagePages_s4p.zip
> >>>>
> >>>> There are two types of web browser controls you can create.. I made a
> >>>> form for each one. The first is on the ribbon. The second,
> >>>> Class=Shell.Explorer.2, is created by choosing ActiveX from the
> >>>> control list and then getting the Web Browser control from there.
> >>>>
> >>>> the HTML files to display an image look like this:
> >>>>
> >>>> '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >>>> <html lang="en">
> >>>> <head> <!-- this section is optional -->
> >>>>    <meta charset="UTF-8">
> >>>>    <meta http-equiv="Content-Language" content="en-us">
> >>>>    <title>         Form and Popups </title>
> >>>>    <META name="description" content="Picture of Form and Popups for
> >>>> MyContacts" />
> >>>>    <meta name="Author" content="crystal (strive4peace)" />
> >>>>
> >>>>    <META name="copyright" content="© 2019 crystal long
> >>>> (strive4peace)">
> >>>> </head>
> >>>>
> >>>> <body>
> >>>>    <img src="../MyContacts_Popups..png"
> >>>>    title="Form and Popups for MyContacts"
> >>>>    alt="Picture of Form and Popups for MyContacts"
> >>>>    /> <!-- only SRC is necessary -->
> >>>> </body>
> >>>> </html>
> >>>> '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >>>>
> >>>> ~crystal
> >>>>
> >>>> VBA code you can use in your projects
> >>>> http://msaccessgurus.com/code.htm
> >>>>
> >>>> On 2/18/2019 12:10 PM, crystal 8 strive4peace2008@yahoo.com
> >>>> [MS_Access_Professionals] wrote:
> >>>>
> >>>
> >>> ------------------------------------
> >>> Posted by: Dave Williams <davewillgmale@gmail.com>
> >>> ------------------------------------
> >>>
> >>>
> >>> ------------------------------------
> >>>
> >>> Yahoo Groups Links
> >>>
> >>>
> >>>
> >>
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo Groups Links
> >
> >
> >
>
>


__._,_.___

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 (16)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar