ACCESS FEED: RE: [MS_AccessPros] Re: FE Updater

Rabu, 24 Juli 2013

RE: [MS_AccessPros] Re: FE Updater

Thank you.

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Wednesday, July 24, 2013 9:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: FE Updater

I just updated the file on my website. It should be okay for IE 8 and higher
on Windows 7. Let me know if you have any more issues with it.

Bill

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca"
<wrmosca@...> wrote:
>
> Roberto
>
> Thanks for reporting that. YOu must be using IE 8 or higher. It no longer
supports that property. Comment out these two lines:
> oIE.Left = (.availWidth - oIE.Width) \ 2
> oIE.Top = (.availheight - oIE.Height) \ 2
>
> All they do is center the IE window.
>
> Bill Mosca
>
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "RobertoARV"
<robertoarv@> wrote:
> >
> > WINDOWS SCRIPT HOST
> >
> > Line 57
> >
> > Char 17
> >
> > Error: Object doesn't Support this property or method: 'availWidth'
> >
> > Code:800A01B6
> >
> > Source : Microsoft VBScript runtime error
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of RobertoARV
> > Sent: Tuesday, July 23, 2013 6:07 PM
> > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: RE: [MS_AccessPros] Re: FE Updater
> >
> >
> >
> >
> >
> > Running in Windows 7 it show the following error:
> >
> > From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill
Mosca
> > Sent: Tuesday, July 23, 2013 3:10 PM
> > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] Re: FE Updater
> >
> > John
> >
> > It's pretty much just changing the values of the constants at the top of
the
> > code so they match your environment. If you decide to try it just post
back
> > here with any issues you have. Hopefully, I wrote the article clearly
enough
> > for you to follow.
> >
> > Bill
> >
> > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "jfakes.rm"
> > <jfakes@> wrote:
> > >
> > > Bill,
> > > I did read this, but thought it was outside of my VBA prowness. I'm
going
> > to spend some time to sift though it and see if I can figure it out. I
just
> > got MS Visual 2008 Express Edition installed on my computer so I can
give it
> > a try.
> > >
> > > Thanks,
> > >
> > > John F.
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca"
<wrmosca@>
> > wrote:
> > > >
> > > > John
> > > >
> > > > Have you read my article on updating and deploying FE's?
> > http://www.thatlldoit.com/Pages/howtosarticles.aspx No updater is needed
so
> > you can save your money for more important things like a good bottle of
> > wine.
> > > >
> > > > I use a VBScript that is available for download. The user gets a
link to
> > the script via email for the initial download. The script puts a
shortcut to
> > the script on the user's desktop and when launched, the script checks to
see
> > if the user has the latest copy. If he does the FE opens; if not then
the
> > files are downloaded and then the FE opens.
> > > >
> > > > You should be able to use my script after reading the article with
much
> > knowledge of VBA or VBScript (which is very much like VBA).
> > > >
> > > > Post back here if you need help with it.
> > > >
> > > > Regards,
> > > > Bill Mosca, Founder - MS_Access_Professionals
> > > > http://www.thatlldoit.com
> > > > Microsoft Office Access MVP
> > > >
> >
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
> > 1E
> > > > My nothing-to-do-with-Access blog
> > > > http://wrmosca.wordpress.com
> > > >
> > > >
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "jfakes.rm"
<jfakes@>
> > wrote:
> > > > >
> > > > > I have seen several versions of a Frontend (FE) updater, however,
I
> > would like to figure out the best way to complete the following steps:
> > > > >
> > > > > 1. How I can save a file on a shared server that a user would
click on
> > once to copy the FE updater database as well as the FE to the users
> > computer.
> > > > >
> > > > > 2. I would like the icon for the FE updater to be put on the users
> > desktop so that is the only icon they will see for the database. This
would
> > be what the user clicks on to check the version of the FE and either
update
> > it to the correct version then open the FE, or if the user has the
current
> > version, open the FE.
> > > > >
> > > > > I am not an IT person, just someone that has been "blessed"
(stuck)
> > with updating numerous databases with no training.
> > > > >
> > > > > I assume there is a way to do this using VBA, however, I don't
have
> > any VBA training either so I would like to see if there is a simple way
to
> > do this.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > John F.
> > > > >
> > > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

[Non-text portions of this message have been removed]