Rabu, 24 Juli 2013

[MS_AccessPros] Re: FE Updater

 

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, "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@yahoogroups.com] On Behalf Of RobertoARV
> Sent: Tuesday, July 23, 2013 6:07 PM
> To: MS_Access_Professionals@yahoogroups.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@yahoogroups.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>
> 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> , "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> , "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> , "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]
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar