Re: Re: Outlook problem

On 7 Mar 2006 08:08:09 -0800, CDMAPoster@xxxxxxxxxxxxxxxx wrote:

Tom Becker wrote:
On 6 Mar 2006 16:56:15 -0800, CDMAPoster@xxxxxxxxxxxxxxxx wrote:

Tom Becker wrote:
On 6 Mar 2006 12:56:02 -0800, CDMAPoster@xxxxxxxxxxxxxxxx wrote:

I'll post the entire list of referenced I used, tonight or tomorrow.

references (my brain was moving faster than my fingers)

After that, if you still have difficulties I'll try to help you find
the problem. It has to be something pretty simple.

Great! Thanks! If it worked before there must be a way.

Here it is (in the order I used):

Visual Basic For Applications
Microsoft Access 9.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Outlook 9.0 Object Library
Microsoft Office 9.0 Object Library
Microsoft Word 9.0 Object Library
Microsoft Calendar Control 9.0
Microsoft Windows Common Controls 6.0 (SP3)
Microsoft Office Web Components 9.0
Microsoft Forms 2.0 Object Library
LinkDC.adp

James A. Fortune
CDMAPoster@xxxxxxxxxxxxxxxx

Some of them are not on my list of references to select from.

I don't have the calandar control, I doubt if that is the problem.

I don't have Microsoft Windows Common Controls 6.0 (SP3)
(though I do have Service Pack 3 installed)

I don't have Microsoft Office Web Components 9.0

I don't have Microsoft Forms 2.0 Object Library

And I don't have LinkDC.adp

I'm still getting the same error. How did you get those references on
your list?

Automation shouldn't need many references, certainly not anything
special. As to how I got those references it looks like I'll have to
do some investigating. I know I had Enterprise Manager on the original
machine from some kind of MS developer's tools disk. I'll look to see
exactly what disk that was. I think many of the references were put
there automatically when I used various controls. Please post your
code excerpt and appropriate Dim statements. I wanted to make sure it
wasn't a references issue before looking at code. LinkDC.adp was
simply used to link to some hosted SQL Server data.

James A. Fortune
CDMAPoster@xxxxxxxxxxxxxxxx

I copied what you sent before:

Private Sub cmdSendRec_Click()
Dim MyExplorer As Explorer
Dim MyMenuBar As CommandBar
Dim MyMenuBarControl As CommandBarControl
Dim objOutlook As Outlook.Application

Set MyExplorer = objOutlook.ActiveExplorer
MyExplorer.Activate
MyExplorer.WindowState = olMaximized
Set MyMenuBar = MyExplorer.CommandBars.Item("Standard")
Set MyMenuBarControl = MyMenuBar.Controls.Item("Send/Re&ceive")
MyMenuBarControl.Execute
Set MyMenuBar = Nothing

'This needs a reference set to the Outlook Object library.
End Sub

I try this with Outlook already open. The "Receive" part doesn't
look right but I get the error on the first line.

.

Relevant Pages

  • RE: "Cant find project or library" after emailing files.
    ... Open the 'problem' workbook. ... NAME and GUID for each of the references shown when you ran ... Dim aryHiddensheets() ... ' 'Microsoft ActiveX Data Objects Recordset 2.5 Library ...
    (microsoft.public.excel.misc)
  • Re: Run-Time Error 429: ActiveX component cant create object
    ... I think I may not have all the correct references ... Microsoft Access 11.0 Object Library ... some other similar references but keep getting the same error message. ... 'Dim XLapp As Excel.Application ...
    (microsoft.public.access.externaldata)
  • Re: Duplicate a record with some changes
    ... Dim rs As DAO.Recordset ... If so, while in the VB Editor, select Tools | References from the menu bar, ... Microsoft DAO 3.6 Object Library, select it (by checking the box to the left ... need to select a different Business Unit and a different Business ...
    (microsoft.public.access.forms)
  • Re: Convert Microsoft script to VB
    ... Microsoft Scripting Runtime ... What references need to be set, ... For Each objItem in colItems ... Dim objWMIService As Object ...
    (microsoft.public.vb.general.discussion)
  • Re: Outlook problem
    ... Microsoft Access 9.0 Object Library ... Some of them are not on my list of references to select from. ... I don't have Microsoft Windows Common Controls 6.0 ... Dim MyExplorer As Explorer ...
    (comp.databases.ms-access)
Loading