Re: Access 2000 Find Inbox at Runtime

From: Tony Toews (ttoews_at_telusplanet.net)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 19:01:03 GMT

Bob Dydd <smileyBob@hotmail.com> wrote:

>I have an Access 2000 MDB with the Usual FrontEnd/BackEnd Arrangement.
>The program depends on being able link to "Inbox" in Ms Outlook 2000.
>
>This is easy enough to do from the FrontEnd and has been OK while me
>and the missus have been using the program ourselves.
>
>Now We want to be able to give the program to others who mainly do
>not have MS Access installed., or if they do, have no idea what it is
>about

For those without the runtime you need to use the MOD to create a runtime. Trouble
is it has problems when distributed to sites running different versions of software
and may no longer be available for A2000.

Microsoft Access (Office) Developer Edition FAQ
http://www.granite.ab.ca/access/developereditionfaq.htm

>To make matters worse some are using different versions of MS Outlook
>MS Outlook 2003 50%
>MS Outlook 2002 25%
>MS Outlook 2000 25%

Late binding means you can safely remove the reference and only have an error when
the app executes lines of code in question. Rather than erroring out while starting
up the app and not allowing the users in the app at all. Or when hitting a mid, left
or trim function call.

You'll want to install the reference if you are programming or debugging and want to
use the object intellisense while in the VBA editor. Then,. once your app is
running smoothly, remove the reference and setup the late binding statements.

Sample code:
' Declare an object variable to hold the object
' reference. Dim as Object causes late binding.
Dim objWordDoc As Object
Set objWordDoc = CreateObject(" Word.Document")

For more information including additional text and some detailed links see the "Late
Binding in Microsoft Access" page at http://www.granite.ab.ca/access/latebinding.htm

Tony 

--
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can 
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at 
http://www.granite.ab.ca/accsmstr.htm

Relevant Pages

  • Re: Access 2000 Find Inbox at Runtime
    ... up the app and not allowing the users in the app at all. ... You'll want to install the reference if you are programming or debugging and want to ... remove the reference and setup the late binding statements. ... Binding in Microsoft Access" page at http://www.granite.ab.ca/access/latebinding.htm ...
    (microsoft.public.outlook.program_vba)
  • Re: Access 2000 Find Inbox at Runtime
    ... up the app and not allowing the users in the app at all. ... You'll want to install the reference if you are programming or debugging and want to ... remove the reference and setup the late binding statements. ... Binding in Microsoft Access" page at http://www.granite.ab.ca/access/latebinding.htm ...
    (microsoft.public.outlook.general)
  • Re: dynamic linking/referencing Office libraries
    ... You don't need to create a reference at all. ... Use late binding instead. ... an error when the app executes lines of code in question. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Outlook dependency
    ... >like to ship with my installation the libraries, files, OLB's and other ... Late binding means you can safely remove the reference and only have ... an error when the app executes lines of code in question. ...
    (microsoft.public.access.forms)
  • Re: Access2000 db bombing in Access 2002
    ... Use Late Binding then. ... Late binding means you can safely remove the reference and only have ... an error when the app executes lines of code in question. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.conversion)