[AccessD] Create reference only when needed

Kath Pelletti KP at sdsonline.net
Thu Jul 14 03:42:18 CDT 2005


<<.....plus it works with all versions
That part sounds good....the most frustrating aspect of being an access /vba developer has to be the fragility of the systems. Compared to writing mainframe applications, I still find this the trickiest aspect. The user changes something on the PC and crash goes the application. So this is something I need to learn. Thanks.
Kath
  ----- Original Message ----- 
  From: John Bartow 
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, July 14, 2005 12:40 PM
  Subject: RE: [AccessD] Create reference only when needed


  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

  -- 
  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