[AccessD] Create reference only when needed

John Bartow john at winhaven.net
Wed Jul 13 21:40:24 CDT 2005


Kath,
Speed shouldn't be a big deal. I use late binding with Word and it doesn't
seem to take any longer than earlier binding plus it works with all versions
of word. I say seems because to be clock ticks are not as important as user
impression. Give them the hourglass at the start of the routine and turn if
on and off a few times. Builds hope :o)

Here's an article from our newsletter that explains it quite well:
http://www.databaseadvisors.com/newsletters/newsletter072002/0207wordautomat
ionlpt1.htm

It really should be fairly easy after you browse that.

HTH
John B. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
Sent: Wednesday, July 13, 2005 8:15 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Create reference only when needed

John - I've never used it. BUT it may be the solution to this case as only
some of my users *have* Frontpage installed at all.

I'm a bit scared of the speed issues, but how do In convert code below to
use late binding instaed?

Kath

Private Sub CmdOpenFP_Click()

Dim oFPweb As FrontPage.Web
Dim oFP As FrontPage.Application
Dim FrontPageRunning As Boolean

'Determine whether FrontPage is already open or not FrontPageRunning =
IsFrontPageRunning()

If Not FrontPageRunning Then
    Set oFP = CreateObject("Frontpage.Application")
Else
    Set oFP = GetObject(, "Frontpage.Application") End If

'add code here later to make a copy of my file

'open file in front page------------------------------------------------
oFP.Webs.Open ("E:/Sds/Clients/CPP/Webletters/template.html")
 ' Show FrontPage
 oFPweb.Activate
 'Set oFP = Nothing

End Sub
  ----- Original Message -----
  From: John Bartow
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, July 14, 2005 10:56 AM
  Subject: RE: [AccessD] Create reference only when needed


  Have you considered late binding?

  John B.

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
  Sent: Wednesday, July 13, 2005 7:24 PM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] Create reference only when needed

  Can someone tell mew how to set a reference to a program (in this case
  Frontpage) only if the user has the software installed.

  I have an app that crashed because of missing references, so I want to
  remove them and set them using code when / if needed.

  TIA
  Kath
  --
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

  --
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list