Results 1 to 2 of 2
  1. #1
    Neo44 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    3

    After upgrading from XP to W7 can not change outlook subject title from access


    I linked an Outlook (exchange) folder as a table in an access 2010 database. With VBA code I read this table, I perform some actions and then I finally change the field "Normalized Subject" of each processed record by adding text behind the extisting title. In OUTLOOK, after running my VBA code the Subject titles have changed as I want. However: This was before upgrading from XP to Windows 7. But after upgrading to Windows 7, my VBA code can not longer change the mail subject title anymore. Also I can not change the subject field "Nomralized Subject" manually direct in the table anymore.
    I get an error "No current record" as shown below.

    Set rst=db.openrecordset("Select * from OUTLOOK_FOLDER")
    With rst
    .movefirst
    Do until .EOF
    Title=rst("Normalized Subject")
    .......
    .......
    .Edit
    rst("Normalized Subject")=Title + " Processed"
    .Update
    debug.print rst("Normalized Subject") THE CODE STOPS AT THIS STATEMENT WITH ERROR: "NO CURRENT RECORD"
    .MoveNext
    End with

    Note: if I enter text in a record in the field "Normalized Subject" behind the existing title text manually in the linked outlook folder table directly, the field does not record the change and if I click again in the field then I get the message "no current record". The record however thereafter (luckily) still exists.

  2. #2
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    See the example here - http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

    Looks like you may need to add a bookmark to reset and keep the same record current after update.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 02-23-2014, 06:06 PM
  2. Change chart title with code
    By Pastor Del in forum Reports
    Replies: 6
    Last Post: 02-11-2014, 08:56 PM
  3. Upgrading from Access Maybe
    By Perceptus in forum Security
    Replies: 3
    Last Post: 06-29-2013, 12:20 AM
  4. Cannot change column title
    By Ancient Dragon in forum Access
    Replies: 3
    Last Post: 11-12-2012, 08:44 PM
  5. Replies: 2
    Last Post: 05-26-2012, 01:08 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums