[AccessD] Office 10.0 Library vs. Office 9.0 Library

Shamil Salakhetdinov shamil at smsconsulting.spb.ru
Tue Feb 4 14:24:24 CST 2003


> How can I convert this to late binding?
Rocky,

This is easy - just use this code:

Dim cbc As Object ' CommandBarControl
Set cbc = CommandBars("Menu Bar").FindControl(ID:=4, recursive:=True)
cbc.Enabled = False

and remove the reference to the MS Office object library.

HTH,
Shamil
  ----- Original Message ----- 
  From: Rocky Smolin - Beach Access Software 
  To: accessd at databaseadvisors.com 
  Sent: Tuesday, February 04, 2003 10:35 PM
  Subject: Re: [AccessD] Office 10.0 Library vs. Office 9.0 Library


  Shamil:

  I'm having a little trouble finding enough help in Help and the ADH to figure out how to do late binding.  I'm currently using the following three lines to turn off the print button:

  Dim cbc As CommandBarControl
  Set cbc = CommandBars("Menu Bar").FindControl(ID:=4, recursive:=True)
  cbc.Enabled = False

  How can I convert this to late binding?

  (BTW, I'm trying to repair my Office installation now.  Maybe it will get rid of Version 10 and replace it with Version 9 which will solve the problem.)

  Best,

  Rocky

    ----- Original Message ----- 
    From: Shamil Salakhetdinov 
    To: accessd at databaseadvisors.com 
    Sent: Tuesday, February 04, 2003 10:25 AM
    Subject: Re: [AccessD] Office 10.0 Library vs. Office 9.0 Library


    Rocky,

    The only stable solution I know is to use late binding - then you'll not need a reference to Office 9 or 10.

    HTH,
    Shamil
      ----- Original Message ----- 
      From: Rocky Smolin - Beach Access Software 
      To: AccessD at databaseadvisors.com 
      Sent: Tuesday, February 04, 2003 7:30 PM
      Subject: [AccessD] Office 10.0 Library vs. Office 9.0 Library


      Dear List:

      In order to turn off the print button on the file menu I used the CommandBar object which required the Office Library.  I have Version 10.0.  My customer, however, has Version 9.0.  He doesn't have 10.0.  I don't have 9.0.  So now in the update we have to uncheck the 10.0 (missing) library, and check the 9.0 library. Awkward phone support at best.

      What's the best way around this?  Can I get 9.0?  Or can he get 10.0?  Or what?  They're running Office 2000.  Pro, I believe.


      MTIA

      Rocky Smolin
      Beach Access Software

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030204/7979ba58/attachment-0002.html>


More information about the AccessD mailing list