Results 1 to 6 of 6

Thread: Can

  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can

    I trying to complie the following and getting compile error - Can

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Can

    John, if you are running Outlook 2000, I'm sorry to say that it won't run on Outlook 2000, but only on Outlook XP (2002) and 2003. I apologize for steering you wrong in <!post=this thread,487327>this thread<!/post> concerning bulk changes to the Display As field, I overlooked that you were running Outlook 2000.

    Upgrade time? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can

    Thanks

    Does that hold true for the following as well? Post: http://291509

    I'm getting:

    'Compile error - Sub or Function not defined
    SysCmd acSysCmdInitMeter, "Creating Outlook contacts...", intRecCount

    John


    'Copying Access records to Outlook (XP sp2)
    'Post: 291509
    'I ran code in Access that is supposed to copy records (name, address, etc.) from an
    'Access table into Outlook Contacts. Instead, my Contacts fills up with 30-40 people
    'all of whom live in Woodinville, WA. What's going on?

    'Here is the code located in module:

    Function ap_CreateOLContacts()

    Dim objContactItem As ContactItem
    Dim snpContacts As DAO.Recordset
    Dim intCurrRec As Integer, intRecCount As Integer

    Application.Echo True, "Initializing to create Outlook contacts. Please wait..."

    Set snpContacts = CurrentDb.OpenRecordset("tbl_board", dbOpenSnapshot)

    '-- Get the record count for the progress meter
    snpContacts.MoveLast
    intRecCount = snpContacts.RecordCount
    snpContacts.MoveFirst

    'Compile error - Sub or Function not defined
    SysCmd acSysCmdInitMeter, "Creating Outlook contacts...", intRecCount

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Can

    I don't have any experience with DAO, but in the Outlook VBE Tools | References have you set a reference to Access and to MS DAO 3.6 Object library?

    Back to your original objective, a more tedious route is (make a backup of all your contacts first) to export all your contacts to a CSV, open the CSV in Excel and run a formula to set all your Display As fields how you want, save the adjusted CSV file and reimport it to your contacts.

    Finally, a Lounge tip; your link to that post above is invalid, use this syntax <!t>[post#=291509]<!/t>, which will result in <post#=291509>post 291509</post#>.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can

    Thanks for the tip

    MS DAO 3.6 Object library was set OK

    Is SysCmd supported in O2k SP-3 (9.0.6627) WinXP SP-2?

    if so is there a reference for SysCmd?

    'Compile error - Sub or Function not defined
    SysCmd acSysCmdInitMeter, "Creating Outlook contacts...", intRecCount

    John

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can

    SysCmd is an Access VBA instruction, it has nothing to do with Outlook (the ac part in acSysCmdInitMeter is a giveaway - all Access constants begin with ac, those for Outlook with ol, such as olFolderInbox).

    Outlook VBA does not provide a way to set the text in the status bar.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •